Results for “disposition_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CST_XLA_INV_DISPOSITIONS_REF_V is a reference view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Within the ETRM metadata it is catalogued under the BOM (Bills of Material) product family and is described as exposing "User defined alias accounts." The view functions as a thin projection layer that surfaces the disposition identifier, the inventory organization identifier, and the associated distribution account from the underlying generic dispositions table. Its role in EBS reporting and integration is to provide Subledger Accounting (XLA) and Cost Management (CST) consumers with a stable, read-only reference to the accounting flexfield assignment defined for each inventory disposition. Because the distribution account is stored as a user-defined alias, this view abstracts the base table so that downstream accounting event generation, reconciliation reports, and custom integrations can resolve the disposition-to-account relationship without directly querying the transactional generic dispositions table.

Underlying Base Objects

The view is defined over a single documented base object: MTL_GENERIC_DISPOSITIONS, accessed through a SYNONYM in the APPS schema. The view text is a direct pass-through selection with no joins, filters, or aggregation, meaning every row and column exposed by the view is a one-to-one image of the corresponding columns in the base table. The view therefore carries no independent persistence and no materialized data; it is a virtual projection whose cardinality and content are entirely determined by MTL_GENERIC_DISPOSITIONS. Changes to the base table, such as insertion of a new disposition or modification of an assigned distribution account, are immediately visible through the view. Because it references the base object through an APPS synonym, the view resolves within the standard APPS schema namespace used by all EBS application code and concurrent programs.

Key Columns

• DISPOSITION_ID — The unique identifier of the inventory disposition. This column is the primary correlation key used to link a disposition definition to its accounting treatment in subledger and cost accounting flows.
• ORGANIZATION_ID — The inventory organization to which the disposition belongs. This column provides the organizational context required for multi-org reporting and for enforcing inventory accounting rules at the organization level.
• DISTRIBUTION_ACCOUNT — The user-defined alias account associated with the disposition. This is the column most frequently targeted by users searching for "distribution_account," since it is the direct source of the accounting flexfield reference applied to inventory dispositions.

Common Use Cases and Queries

The view is typically used to resolve the distribution account for a given disposition or organization, to validate account assignments, and to drive accounting event generation in Subledger Accounting. A common pattern is to join the view back to disposition-driven transaction data using DISPOSITION_ID and ORGANIZATION_ID. A representative query is:

SELECT disposition_id, organization_id, distribution_account
FROM apps.cst_xla_inv_dispositions_ref_v
WHERE organization_id = :p_org_id;

A more specific lookup returns the account for a single disposition:

SELECT distribution_account
FROM apps.cst_xla_inv_dispositions_ref_v
WHERE disposition_id = :p_disposition_id
AND organization_id = :p_org_id;

Because the view performs no filtering, these queries return all matching rows, and callers should expect the multiplicity present in MTL_GENERIC_DISPOSITIONS. The view is also useful in reconciliation extracts and custom Concurrent Programs that require a lightweight reference to disposition account assignments without touching the full transactional table. As with any APPS synonym-backed view, queries should be executed with the standard EBS initialization and multi-org context in place.