Search Results cst_organization_definitions




Overview
Explore in AI Chat

Overview

CST_ORGANIZATION_DEFINITIONS is a public APPS-owned view that exposes the master list of inventory organizations configured within an Oracle E-Business Suite instance. It is documented under the BOM – Bills of Material product, although its output is referenced across costing, inventory, manufacturing, and financial reporting. The view provides a single denormalized result set that resolves each inventory organization to its business group, organization code, descriptive name in the user's session language, ledger, chart of accounts, currency, and the operating unit and legal entity assignments held in the HR organization information flexfield.

The view is defined with the text preserved in ETRM and is marked VALID. Because it joins human resources organization structures to inventory parameters and the general ledger ledgers, it functions as a bridging object between the HRMS organization model and the inventory/costing application schema in both release 12.1.1 and 12.2.2. The view text is identical in structure across these releases, though the underlying ledger model reflects the 12.x transition to the GL_LEDGERS schema.

Underlying Base Objects

The view is constructed from five referenced objects, all resolved through APPS-owned synonyms: HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_ALL_ORGANIZATION_UNITS_TL, MTL_PARAMETERS, and GL_LEDGERS. The join path is:

The DECODE/TRANSLATE construct in the ledger join ensures that only genuinely numeric ORG_INFORMATION1 values match a ledger row; non-numeric values resolve to -99999 and are excluded.

Key Columns

  • ORGANIZATION_ID – Primary identifier of the inventory organization.
  • BUSINESS_GROUP_ID – Business group to which the organization belongs.
  • USER_DEFINITION_ENABLE_DATE / DISABLE_DATE – Effective date range from HR_ALL_ORGANIZATION_UNITS (DATE_FROM/DATE_TO).
  • ORGANIZATION_CODE – Inventory organization short code from MTL_PARAMETERS.
  • ORGANIZATION_NAME – Translated organization name.
  • SET_OF_BOOKS_ID – Ledger identifier (historical set of books column).
  • CHART_OF_ACCOUNTS_ID – Chart of accounts associated with the ledger.
  • CURRENCY_CODE – Ledger currency.
  • OPERATING_UNIT / LEGAL_ENTITY – Numeric operating unit and legal entity identifiers sourced from ORG_INFORMATION2 and ORG_INFORMATION3.

Common Use Cases and Queries

The view is commonly used in costing and inventory extracts to resolve organization identifiers into meaningful codes, names, and ledger context without navigating multiple HRMS and GL tables.

  • Populating organization lookups in costing reports and interfaces.
  • Mapping inventory organizations to their ledger and currency for financial reconciliation.
  • Determining operating unit and legal entity context for multi-org reporting.

Sample query:

SELECT organization_id, organization_code, organization_name, ledger_id, currency_code FROM cst_organization_definitions WHERE business_group_id = :p_bg_id ORDER BY organization_code;

Because the view enforces the ACCOUNTING INFORMATION context and joins MTL_PARAMETERS, only rows meeting a valid inventory and ledger configuration are returned.