Search Results project_reference_enabled

Overview

CST_XLA_INV_ORG_PARAMS_REF_V is an APPS-owned database view that consolidates inventory organization costing parameters for consumption by Oracle Subledger Accounting (XLA) and Cost Management reporting. The view name encodes its purpose: CST (Cost Management), XLA (Subledger Accounting), INV_ORG_PARAMS (inventory organization parameters), REF (reference), and V (view). Its central function is to expose the cost collection and project reference attributes of an inventory organization alongside the flags, attributes, and cost type properties needed to determine whether transactional cost data is eligible for subledger accounting transfer.

The view is primarily defined over MTL_PARAMETERS, the table that stores inventory organization-level setup, including cost method, project reference and project manufacturing cost collection settings, process and warehouse management flags, and the descriptive flexfield (attribute) columns. It is joined to CST_COST_TYPES to enrich each row with the properties of the organization's average rates cost type. The inclusion of the PM_COST_COLLECTION_ENABLED column makes this view the reference source for the parameter that users search on as "pm_cost_collection_enabled."

Because the view normalizes numeric and null-prone flags into conformed 'Y'/'N' values via DECODE and NVL, it presents a stable, reporting-friendly interface that insulates downstream consumers from the raw storage conventions of MTL_PARAMETERS.

Underlying Base Objects

Per the documented 12.2.2 metadata, the view is defined over two referenced base objects, accessed through APPS synonyms:

• MTL_PARAMETERS (SYNONYM) — the primary source, aliased as MP1 in the view text, supplying organization identifiers, cost method, project reference and project manufacturing cost collection flags, project control level, process/WSM/WMS/EAM/WCS/consigned flags, cost cutoff date, encumbrance reversal flag, deferral of logical transactions, cost group accounting, and all ORG_INV_ATTRIBUTE flexfield columns.
• CST_COST_TYPES (SYNONYM) — joined (aliased as CT) to retrieve the average rates cost type, supplying COST_TYPE, BOM_SNAPSHOT_FLAG, ALLOW_UPDATES_FLAG, and AVAILABLE_TO_ENG_FLAG.

The join key is the cost type identifier (AVG_RATES_COST_TYPE_ID in MTL_PARAMETERS matched to the cost type in CST_COST_TYPES), with the organization identifiers (ORGANIZATION_ID, COST_ORGANIZATION_ID, MASTER_ORGANIZATION_ID, MAINT_ORGANIZATION_ID) carried through from MTL_PARAMETERS.

Key Columns

• INV_ORGANIZATION_ID / MASTER_ORGANIZATION_ID / COST_ORGANIZATION_ID / MAINT_ORGANIZATION_ID — the inventory, master, costing, and maintenance organization identifiers for the parameter row.
• PRIMARY_COST_METHOD — the organization's primary costing method (e.g., standard, average, FIFO).
• PROJECT_REFERENCE_ENABLED — 'Y'/'N' indicator of whether project references are enabled for the organization.
• PM_COST_COLLECTION_ENABLED — the searched parameter; a 'Y'/'N' flag (DECODE of PM_COST_COLLECTION_ENABLED) indicating whether project manufacturing cost collection is enabled.
• PROJECT_CONTROL_LEVEL — the project control level governing project-related transactions.
• AVG_RATES_COST_TYPE_ID / AVG_RATES_COST_TYPE — the identifier and name of the average rates cost type.
• BOM_SNAPSHOT_FLAG / ALLOW_UPDATES_FLAG / AVAILABLE_TO_ENG_FLAG — cost type properties from CST_COST_TYPES, normalized to 'Y'/'N'.
• PROCESS_ENABLED_FLAG, WSM_ENABLED_FLAG, WMS_ENABLED_FLAG, EAM_ENABLED_FLAG — organization capability flags.
• CONSIGNED_ORG_FLAG, WCS_ENABLED, DEFER_LOGICAL_TRANSACTIONS, COST_GROUP_ACCOUNTING, ENCUMBRANCE_REVERSAL_FLAG — additional inventory and costing configuration flags.
• COST_CUTOFF_DATE — the cost cutoff date for the organization.
• ORG_INV_ATTRIBUTE_CATEGORY and ORG_INV_ATTRIBUTE1–15 — the descriptive flexfield context and segment values from MTL_PARAMETERS.

Common Use Cases and Queries

Typical consumers use this view to confirm organization costing prerequisites before running cost collection, create accounting, or project manufacturing processes. A common query identifies organizations with project manufacturing cost collection enabled:

• SELECT inv_organization_id, project_reference_enabled, pm_cost_collection_enabled FROM cst_xla_inv_org_params_ref_v WHERE pm_cost_collection_enabled = 'Y';
• SELECT inv_organization_id, primary_cost_method, avg_rates_cost_type FROM cst_xla_inv_org_params_ref_v ORDER BY inv_organization_id;
• SELECT inv_organization_id, cost_cutoff_date, encumbrance_reversal_flag FROM cst_xla_inv_org_params_ref_v;

Because all flags are pre-normalized to 'Y'/'N', these predicates are portable across 12.1.1 and 12.2.2 without decoding underlying numeric storage. Reports and XLA diagnostics frequently join this view to CST_COST_TYPES-derived reporting or to accounting event data to validate that cost collection was correctly configured for the organization whose transactions are being accounted.