Results for “cst_quantity_layers”

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

Overview

CST_QUANTITY_LAYERS, owned by the BOM (Bills of Material) schema, is a foundational cost management table within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The table stores cost information for each inventory valuation layer, supporting the standard costing and actual costing engines that underpin inventory valuation, cost rollup, and period-close processing. Each row represents a discrete quantity layer associated with an inventory item and organization, capturing both the quantity on hand and the elemental cost buildup (material, material overhead, resource, outside processing, and overhead) at the planning (PL) and total (TL) levels.

Based on the heuristic Data Vault classification mined from its foreign key structure, CST_QUANTITY_LAYERS exhibits a satellite-leaning profile: it holds descriptive, time-variant measures and cost attributes keyed to parent hub entities such as inventory items and cost groups, rather than serving as a pure hub or link. This classification is offered as a modeling suggestion for downstream analytics or warehouse design, not as an EBS-native construct.

Key Information Stored

The primary key is CST_QUANTITY_LAYERS_PK, defined on the surrogate LAYER_ID column, which uniquely identifies each cost layer. Two unique indexes act as business-key candidates: CST_QUANTITY_LAYERS_U1 on LAYER_ID and CST_QUANTITY_LAYERS_U2, a composite on (INVENTORY_ITEM_ID, ORGANIZATION_ID, COST_GROUP_ID).

The most consequential columns include:

• LAYER_ID — surrogate primary key and the join point for all dependent detail tables.
• INVENTORY_ITEM_ID and ORGANIZATION_ID — foreign references to MTL_SYSTEM_ITEMS_B, identifying the item and inventory organization.
• COST_GROUP_ID — references CST_COST_GROUPS, enabling cost-group-specific layer segmentation.
• LAYER_QUANTITY — the quantity represented by the layer.
• CREATE_TRANSACTION_ID and UPDATE_TRANSACTION_ID — audit links to the transactions that created or modified the layer.
• MATERIAL_COST, MATERIAL_OVERHEAD_COST, RESOURCE_COST, OUTSIDE_PROCESSING_COST, OVERHEAD_COST — the elemental cost components.
• ITEM_COST, UNBURDENED_COST, BURDEN_COST — aggregated total, unburdened, and burdened costs.
• PL_ITEM_COST and TL_ITEM_COST — planning-level and total-level item costs.
• Standard WHO/audit columns (LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, etc.).

Common Use Cases and Queries

Typical use cases include inventory valuation reporting, cost layer reconciliation, variance analysis, and integration into cost accounting extracts. A common query pattern joins the layer to the item master to retrieve descriptive attributes alongside cost:

• Layer-to-item joins: SELECT q.LAYER_ID, q.LAYER_QUANTITY, q.ITEM_COST, m.SEGMENT1 FROM BOM.CST_QUANTITY_LAYERS q, MTL_SYSTEM_ITEMS_B m WHERE q.INVENTORY_ITEM_ID = m.INVENTORY_ITEM_ID AND q.ORGANIZATION_ID = m.ORGANIZATION_ID;
• Cost-group filtering using COST_GROUP_ID to isolate layers under a specific costing method.
• Detail-level drilldowns joining to CST_LAYER_COST_DETAILS on LAYER_ID to expand elemental cost breakdowns.
• Ageing and audit reporting using CREATE_TRANSACTION_ID and LAST_UPDATE_DATE.

Related Objects

The following objects are most significant in relation to CST_QUANTITY_LAYERS:

• MTL_SYSTEM_ITEMS_B — referenced via INVENTORY_ITEM_ID and ORGANIZATION_ID.
• CST_COST_GROUPS — referenced via COST_GROUP_ID.
• CST_LAYER_COST_DETAILS — child table referencing LAYER_ID.
• CST_LAYER_COST_DETAILS_EFC — EFC (Enterprise Financial Center) counterpart referencing LAYER_ID.
• CST_INV_LAYERS — references LAYER_ID, linking quantity layers to inventory layers.
• MTL_ACTUAL_COST_SUBELEMENT and MTL_ACTUAL_COST_SUBELEMENT_EFC — reference LAYER_ID for actual cost element buildup.
• MTL_CST_ACTUAL_COST_DETAIL_EFC and CST_QUANTITY_LAYERS_EFC — reference LAYER_ID, supporting EFC and detailed actual cost reconciliation.