Search Results wsm_enabled_flag




Overview
Explore in AI Chat

Overview

The view APPS.CST_XLA_INV_ORG_PARAMS_REF_V is a Cost Management (CST) reference view that consolidates inventory organization costing parameters and cost type attributes into a single denormalized structure. It serves as a reference source for Subledger Accounting (XLA) processing and reporting, exposing the organization-level costing configuration required when inventory transactions, cost adjustments, and period-driven cost events are transformed into accounting entries. The view draws its data from the inventory organization parameters maintained in MTL_PARAMETERS and the cost type definitions held in CST_COST_TYPES, joining them so that a single row presents both the organization's costing behavior and its associated cost type characteristics.

Because the name carries the XLA token, this object is most commonly encountered in the context of the Cost Management accounting engine, where it is used to resolve the reference parameters applied during accounting rule evaluation. It also supplies the COST_CUTOFF_DATE attribute—the column most frequently searched in this context—which records the cutoff date used by the costing processes for a given inventory organization.

Underlying Base Objects

The documented base objects referenced by this view are:

  • CST_COST_TYPES (accessed through a synonym) — provides cost type attributes such as the cost type name, BOM_SNAPSHOT_FLAG, ALLOW_UPDATES_FLAG, and AVAILABLE_TO_ENG_FLAG.
  • MTL_PARAMETERS (accessed through a synonym) — provides the inventory organization parameters, aliased as mp1 in the view definition, supplying organization identifiers, cost method, project reference controls, and flags governing process manufacturing, warehouse management, EAM, consigned inventory, and cost group accounting.

The join is driven from MTL_PARAMETERS (alias mp1) to CST_COST_TYPES (alias ct) through the AVG_RATES_COST_TYPE_ID column, which links the organization's average rates cost type to its definition.

Key Columns

Common Use Cases and Queries

The view is typically queried to verify organization costing configuration, to retrieve the cost cutoff date, or to support XLA accounting diagnostics. A representative query returning the cutoff date and primary costing attributes is:

SELECT inv_organization_id, master_organization_id, primary_cost_method, cost_cutoff_date, avg_rates_cost_type, cost_group_accounting FROM apps.cst_xla_inv_org_params_ref_v WHERE inv_organization_id = :org_id;

A second pattern joins the view to accounting events to confirm the reference configuration applied during subledger processing:

SELECT p.inv_organization_id, p.cost_cutoff_date, p.primary_cost_method, p.bom_snapshot_flag FROM apps.cst_xla_inv_org_params_ref_v p WHERE p.project_reference_enabled = 'Y' ORDER BY p.inv_organization_id;

These queries are commonly used during period-close troubleshooting, when reconciling cost cutoff behavior, or when validating that the correct cost type and account references are available to the XLA engine.