Search Results cst_inv_qty_temp

Overview

CST_INV_QTY_TEMP is a transient staging table owned by the BOM (Bills of Material) schema in Oracle EBS 12.1.1 and 12.2.2. As its name and documented description indicate, it stores intermediate results generated during period close summarization, standard cost update processing, and inventory valuation reporting. The table is not a permanent transactional store; instead, it functions as a scratch pad that cost management concurrent programs populate, join, and subsequently purge to produce summarized inventory quantities and values. Because period close and standard cost update routines frequently operate over large volumes of inventory transactions spanning multiple organizations, cost groups, and cost types, this intermediate persistence is used to avoid repeatedly re-reading the underlying transaction tables.

The documented physical schema in ETRM 12.2.2 shows 17 columns under the BOM schema. Foreign key relationships link the table to CST_COST_GROUPS (via COST_GROUP_ID) and CST_COST_TYPES (via COST_TYPE_ID). Heuristic Data Vault classification mined from the FK structure identifies this object as standalone. In Data Vault modeling terms, a standalone classification suggests the table behaves like a hub-oriented reference or a domain-specific staging entity rather than a pure link resolving many-to-many relationships; the classification is offered as a modeling suggestion, not as a physical constraint.

Key Information Stored

The 17 documented columns support quantity sourcing, organizational context, costing dimensions, and valuation outputs. The most consequential columns are:

• QTY_SOURCE — identifies the origin of the quantity record, distinguishing between the various summarization processes (period close, standard cost update, valuation report) that populate the table.
• ORGANIZATION_ID — the inventory organization owning the summarized quantity.
• INVENTORY_ITEM_ID — the item for which quantities and values are aggregated.
• COST_GROUP_ID — foreign key to CST_COST_GROUPS, grouping items for costing purposes.
• COST_TYPE_ID — foreign key to CST_COST_TYPES, defining whether the record reflects frozen, average, or standard cost basis.
• SUBINVENTORY_CODE — the subinventory within the organization to which the quantity applies.
• ACCOUNTED_VALUE — the accounted monetary value of the summarized quantity.
• ROLLBACK_VALUE and ROLLBACK_QTY — captured prior values used to restore state if a costing process is rolled back or fails.
• REVISION — the item revision associated with the summarized quantity.
• FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID — organizational endpoints for transfer-related quantities.
• RCV_TRANSACTION_ID and SHIPMENT_LINE_ID — references tying summarized quantities to receiving and shipping events.
• INTRANSIT_INV_ACCOUNT — the account associated with in-transit inventory quantities.

The metadata does not document an explicitly named surrogate primary key or a unique business-key index on this table; given its temporary nature, it is typically populated and consumed without reliance on a stable natural key.

Common Use Cases and Queries

Primary use cases center on three concurrent processes: period close summarization, standard cost update, and inventory valuation reporting. Typical supporting queries aggregate quantities and values by cost group, cost type, and organization, for example:

• Summing ACCOUNTED_VALUE grouped by ORGANIZATION_ID, COST_GROUP_ID, and COST_TYPE_ID to produce valuation rollups.
• Filtering by QTY_SOURCE to isolate the output of a single costing program during diagnostic review.
• Comparing ACCOUNTED_VALUE against ROLLBACK_VALUE to verify rollback integrity after an aborted cost update.
• Reporting on FROM_ORGANIZATION_ID / TO_ORGANIZATION_ID pairs to audit inter-org transfer quantities captured through RCV_TRANSACTION_ID and SHIPMENT_LINE_ID.

Because content is transient, queries are generally meaningful only during or immediately following the originating concurrent request.

Related Objects

The table participates in a small, well-defined relationship set:

• CST_COST_GROUPS — joined via CST_INV_QTY_TEMP.COST_GROUP_ID = CST_COST_GROUPS.COST_GROUP_ID.
• CST_COST_TYPES — joined via CST_INV_QTY_TEMP.COST_TYPE_ID = CST_COST_TYPES.COST_TYPE_ID.
• MTL_SYSTEM_ITEMS_B — resolves INVENTORY_ITEM_ID to item descriptions and attributes.
• MTL_PARAMETERS — resolves ORGANIZATION_ID to organization codes.
• MTL_SECONDARY_INVENTORIES — resolves SUBINVENTORY_CODE.
• RCV_TRANSACTIONS — resolves RCV_TRANSACTION_ID to receiving details.
• RCV_SHIPMENT_LINES — resolves SHIPMENT_LINE_ID to shipment line information.

These relationships make the table a focal joining point for valuation, inter-org transfer, and receiving reconciliation analysis during costing cycles.