Search Results cst_inv_layers_n1

Overview

CST_INV_LAYERS is a core costing table owned by the BOM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the inventory cost layers generated for each receipt transaction. One inventory layer is created for every receipt into inventory, and each layer is scoped within an organization, item, and cost group. The table records both the quantity and cost information associated with that layer, forming the basis for periodic costing, layer consumption, and cost group valuation.

CST_INV_LAYERS is physically stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its indexes reside in APPS_TS_TX_IDX. The heuristic Data Vault classification for this object is standalone, meaning it does not participate as a conventional hub, link, or satellite in the mined relationship model. This classification reflects that CST_INV_LAYERS primarily links to CST_QUANTITY_LAYERS via LAYER_ID, but is not itself a dependent child of a broader integration hub.

Key Information Stored

The table contains 23 documented columns. The most significant include:

• INV_LAYER_ID — Surrogate primary key; uniquely identifies an inventory layer. Backed by unique index CST_INV_LAYERS_U1.
• LAYER_ID — Foreign key to CST_QUANTITY_LAYERS; groups related inventory layers under a parent quantity layer. Part of unique index CST_INV_LAYERS_U2 (LAYER_ID, INV_LAYER_ID).
• ORGANIZATION_ID — Owning inventory organization.
• INVENTORY_ITEM_ID — Item identifier for the layer.
• CREATION_QUANTITY — Quantity originally created for the layer.
• LAYER_QUANTITY — Current remaining quantity in the layer (consumed as issues occur). Indexed via CST_INV_LAYERS_N2.
• LAYER_COST — Unit or layer cost used for valuation.
• UNBURDENED_COST — Item unit cost minus this level's material overhead.
• BURDEN_COST — This level's material overhead contribution.
• CREATE_TRANSACTION_ID / TRANSACTION_ACTION_ID — Transaction identifiers that created and acted on the layer.
• TRANSACTION_SOURCE_ID / TRANSACTION_SOURCE_TYPE_ID / TRANSACTION_SOURCE — Source transaction context; TRANSACTION_SOURCE_TYPE_ID references MTL_TXN_SOURCE_TYPES. Indexed via CST_INV_LAYERS_N1.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID — Standard WHO and concurrent program audit columns.

Common Use Cases and Queries

Cost accountants and supply chain analysts use CST_INV_LAYERS to trace inventory valuation, reconcile layer balances, and audit receipt-driven costing. Typical queries include:

• Retrieving layers for an item and organization: SELECT inv_layer_id, layer_quantity, layer_cost FROM bom.cst_inv_layers WHERE organization_id = :org AND inventory_item_id = :item;
• Identifying remaining quantity by layer to assess consumption: filtering on LAYER_QUANTITY > 0.
• Reconciling back to the parent quantity layer: joining to CST_QUANTITY_LAYERS on LAYER_ID.
• Auditing receipts by transaction source: joining TRANSACTION_SOURCE_TYPE_ID to MTL_TXN_SOURCE_TYPES.
• Analyzing overhead split using BURDEN_COST and UNBURDENED_COST for period-end valuation reporting.

Related Objects

• CST_QUANTITY_LAYERS — Parent layer table; join on LAYER_ID.
• MTL_TXN_SOURCE_TYPES — Lookup for TRANSACTION_SOURCE_TYPE_ID.
• MTL_TRANSACTIONS / MTL_MATERIAL_TRANSACTIONS — Source receipts referenced by CREATE_TRANSACTION_ID.
• CST_ITEM_COSTS — Item cost basis supporting LAYER_COST valuation.
• MTL_SYSTEM_ITEMS_B — Item master; join on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• CST_LAYER_COST_DETAILS — Detailed layer cost breakdowns in period costing.
• ORG_ORGANIZATION_DEFINITIONS — Organization validation for ORGANIZATION_ID.

The primary key CST_INV_LAYERS_PK (INV_LAYER_ID) and unique indexes CST_INV_LAYERS_U1 and CST_INV_LAYERS_U2 enforce layer identity and support efficient joins across the costing subsystem.