Search Results cst_acct_info_v




Overview
Explore in AI Chat

Overview

CST_ACCT_INFO_V is a public synonym view owned by the APPS schema in Oracle E-Business Suite. It exposes the accounting information associated with an inventory organization, resolving the flexfield-style organization information records maintained against the HR organization model into discrete, numeric identifiers. The view is catalogued under the BOM — Bills of Material product family, where it supports costing and manufacturing flows that require the ledger, legal entity, and operating unit context of an inventory organization. Because accounting context is a prerequisite for inventory valuation, cost grouping, and manufacturing accounting, CST_ACCT_INFO_V functions as a lightweight, read-only projection that downstream reports, concurrent programs, and integration interfaces can join against using only an ORGANIZATION_ID.

The view is documented with STATUS VALID in the APPS schema and does not materialize any data of its own; it derives all values at query time.

Underlying Base Objects

The view is defined over a single referenced base object: HR_ORGANIZATION_INFORMATION, accessed through a synonym. That table stores descriptive and classifying attributes of organizations as key-value pairs, each row identified by an ORG_INFORMATION_CONTEXT and a numbered ORG_INFORMATIONn column.

CST_ACCT_INFO_V filters HR_ORGANIZATION_INFORMATION to the context 'ACCOUNTING INFORMATION' and converts the string-valued flexfield segments into numbers. The mapping is positional: ORG_INFORMATION1 becomes LEDGER_ID, ORG_INFORMATION2 becomes LEGAL_ENTITY, and ORG_INFORMATION3 becomes OPERATING_UNIT. ORGANIZATION_ID is carried through unchanged as the join key to HR_ALL_ORGANIZATION_UNITS and the inventory organization tables used by costing and BOM.

Key Columns

  • ORGANIZATION_ID — The inventory organization identifier. This is the primary correlation key and maps to organization_id in HR_ALL_ORGANIZATION_UNITS and the inventory organization master.
  • LEDGER_ID — Derived from TO_NUMBER(ORG_INFORMATION1). Identifies the general ledger ledger (set of books in 12.1.1 nomenclature) in which the organization's inventory and manufacturing transactions are accounted.
  • LEGAL_ENTITY — Derived from TO_NUMBER(ORG_INFORMATION2). Identifies the legal entity associated with the organization, used in intercompany and legal reporting.
  • OPERATING_UNIT — Derived from TO_NUMBER(ORG_INFORMATION3). Identifies the operating unit that owns or transacts against the organization, relevant for Multi-Org secured reporting.

All three accounting columns are cast with TO_NUMBER, so the view returns numeric IDs rather than the descriptive flexfield text stored in the base table.

Common Use Cases and Queries

Typical applications include inventory valuation reports that must segregate balances by ledger, cost rollup and manufacturing accounting programs that require legal entity and operating unit context, and integration extracts that publish organization accounting attributes to external systems. The view is also used to resolve the accounting setup of an organization when diagnosing costing or period-close issues.

Retrieve accounting context for a single organization:

  • SELECT organization_id, ledger_id, legal_entity, operating_unit FROM cst_acct_info_v WHERE organization_id = :org_id;

List all inventory organizations with their ledger assignment:

  • SELECT organization_id, ledger_id, legal_entity, operating_unit FROM cst_acct_info_v ORDER BY organization_id;

Join to the inventory organization master to obtain names:

  • SELECT v.organization_id, o.name, v.ledger_id, v.legal_entity, v.operating_unit FROM cst_acct_info_v v, hr_all_organization_units o WHERE v.organization_id = o.organization_id;

Because the view reads directly from HR_ORGANIZATION_INFORMATION, it reflects the current organization configuration and requires no refresh. Users should ensure appropriate organization-level security is applied when querying across multiple operating units in a Multi-Org environment.