Posts in: Organization Details
Organization Details -- Organization Parameters1.sql
Retrieves organization names and parameters by joining inventory parameters with business unit names and MSC calendars.
Read More →Business Units.sql
Fetches detailed Business Unit information including manager IDs, legal entities, primary ledgers, and effective dates.
Read More →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 →