xle_registrations

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

by Shailender Thallam
July 3, 2020July 3, 2020

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

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

by Shailender Thallam
July 3, 2020July 3, 2020

/******************************************************************* *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