Results for “cst_xla_wip_org_params_ref_v”

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

Overview

The view APPS.CST_XLA_WIP_ORG_PARAMS_REF_V is a reference view owned by the APPS schema and is associated with the BOM - Bills of Material product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its status is VALID. The view consolidates Work in Process (WIP) organization-level parameters with corresponding Work in Process Supply Chain (WSM) parameters, producing a flattened, single-row-per-organization reference that the Costing and Subledger Accounting (XLA) infrastructure can consume.

Because the object name carries the CST_XLA prefix and the _REF_V suffix, its principal role is to expose reference data used to build accounting definitions, derive subledger accounting rules, and support reporting over WIP organization parameters. It centralizes attributes that would otherwise require joining WIP_PARAMETERS and WSM_PARAMETERS independently, thereby simplifying downstream views, concurrent programs, and integration extracts that depend on a stable, denormalized projection of WIP setup data.

Underlying Base Objects

The view is defined over two documented base objects, both exposed as synonyms in the APPS schema:

• WIP_PARAMETERS (SYNONYM) — the driving table, aliased WIP, supplying organization-level WIP parameters.
• WSM_PARAMETERS (SYNONYM) — aliased WSP, joined on WSP.ORGANIZATION_ID with an outer join ((+)), supplying estimated scrap accounting configuration.

The join condition is WIP.ORGANIZATION_ID = WSP.ORGANIZATION_ID (+), meaning every qualifying WIP organization is preserved. Where no matching WSM parameter row exists, ESTIMATED_SCRAP_ACCOUNTING resolves to NULL and is subsequently decoded to 'N'. The view therefore behaves as a left outer join from WIP_PARAMETERS to WSM_PARAMETERS, keyed by ORGANIZATION_ID.

Key Columns

The view projects the following columns, each aliased with an ORG_ or WIP_ prefix to distinguish its origin:

• WIP_ORGANIZATION_ID — the WIP organization identifier, derived from WIP.ORGANIZATION_ID; the join key to both base objects.
• REPETITIVE_VARIANCE_TYPE — the variance treatment parameter for repetitive manufacturing, sourced from WIP_PARAMETERS.
• ESTIMATED_SCRAP_ACCOUNTING — a decoded flag derived from WSM_PARAMETERS.ESTIMATED_SCRAP_ACCOUNTING, returning 'Y' when the base value is 1 and 'N' otherwise.
• ORG_WIP_ATTRIBUTE_CATEGORY — the descriptive flexfield (DFF) context value for the WIP organization parameters.
• ORG_WIP_ATTRIBUTE1 through ORG_WIP_ATTRIBUTE15 — the fifteen DFF segment values of the WIP organization parameter flexfield.

The DFF columns inherit the flexfield structure configured on WIP_PARAMETERS, and the category column identifies which segment context applies. This makes the view valuable for setups that store organization-specific accounting or reporting information in WIP parameter DFFs.

Common Use Cases and Queries

Typical usage includes subledger accounting rule construction, WIP organization setup verification, and reporting integrated with estimated scrap and repetitive variance configuration. A representative query returns organization-level WIP and WSM parameters:

• Retrieve all organizations with their repetitive variance type and estimated scrap accounting flag.
• Filter by a specific organization to validate setup: WHERE WIP_ORGANIZATION_ID = :org_id.
• Report DFF-configured attributes for a given attribute category.
• Join the view to ORG_ORGANIZATION_DEFINITIONS on WIP_ORGANIZATION_ID to display organization names alongside parameters.

The following sample SQL illustrates standard use:

• SELECT wip_organization_id, repetitive_variance_type, estimated_scrap_accounting, org_wip_attribute_category, org_wip_attribute1 FROM cst_xla_wip_org_params_ref_v WHERE estimated_scrap_accounting = 'Y';

Because the view is read-only and derived entirely from configuration tables, it should be treated as a query reference rather than an updateable entity. All columns reflect the current committed state of WIP_PARAMETERS and WSM_PARAMETERS.