I am working on Fusion Applications for which I want to write a Report (BI) that gives me Approvals for PO/Requisitions.
I have been given access to the following tables from SOA Infra such as:
SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFTASKHISTORY TO FUSION_RUNTIME;
SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFASSIGNEE TO FUSION_RUNTIME;
SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFTASK TO FUSION_RUNTIME;
SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFAPPROVALGROUPS TO FUSION_RUNTIME;
SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS TO FUSION_RUNTIME;
IS there a way to find how these tables are related or a repository of the SOA Infra tables and their relations
Any guidance to this would be appreciated.