Posts in: Fusion
LEDG_LE_BU_INV_MFG_CST.sql
A collection of queries mapping the hierarchy between Ledgers, Legal Entities, Business Units, Inventory Organizations, and Manufacturing Plants.
Read More →Organization Details -- Organization Details.sql
Provides a high-level view of Organization and Business Unit names along with Set IDs using scalar subqueries.
Read More →Organization Details -- Organization Parameters.sql
Retrieves core organization parameters and associated manufacturing calendars.
Read More →Order Management Parameters.sql
SQL query script extracted from Order Management Parameters.sql.
Read More →Customer, SHIP_TO and BILL_TO Information on an Order.sql
Retrieves Order Management data including header and line details from Customer, SHIP_TO and BILL_TO Information on an Order.sql.
Read More →