Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit and Ledger

/******************************************************************* *PURPOSE: SQL Query to get Organization Structure along with LE, BU and Ledger * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT horg.name enterprise , horg.organization_id… Read More »Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit and Ledger

SQL Query to Fetch BPM Approval Groups Information

/******************************************************************* *PURPOSE: SQL Query to extract BPM Approval Groups Information * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT fwg.approvalgroupid ,fwg.approvalgroupname, fwgm.member, fwgm.type, fwgm.sequence FROM fa_fusion_soainfra.wfapprovalgroups fwg,… Read More »SQL Query to Fetch BPM Approval Groups Information