Search Results qty_source

Overview

BOM.CST_INV_QTY_TEMP is a global temporary table in the Oracle E-Business Suite Cost Management module (BOM schema). It serves as a transient staging area that stores intermediate results for period close summarization, standard cost updates, and inventory valuation reports. The table is defined as a global temporary table with a data duration of SYS$SESSION, meaning rows inserted by one session are visible only to that session and are automatically removed when the session terminates or the transaction completes. This isolation model allows concurrent cost processes to run without interfering with one another.

The table is documented as standalone under the heuristic Data Vault classification mined from its foreign key structure. Rather than functioning as a persistent hub or link, its temporary and process-driven nature suggests it operates as a transient satellite-like staging construct, capturing calculated quantities and valuation amounts emitted by cost manager concurrent programs before they are aggregated or posted to permanent cost tables.

Key Information Stored

The most significant columns reflect the table's role as an aggregation vehicle for inventory valuation and rollback logic:

• QTY_SOURCE (NUMBER) — Identifies the code module that created the row. This is the column most commonly used to segregate results by originating process.
• ORGANIZATION_ID (NUMBER) — The organization identifier scoping the valuation data.
• INVENTORY_ITEM_ID (NUMBER) — The item identifier for the row being valued.
• COST_GROUP_ID (NUMBER) — Foreign key to CST_COST_GROUPS, identifying the cost group context.
• COST_TYPE_ID (NUMBER) — Foreign key to CST_COST_TYPES, defining the cost type against which asset status is checked.
• SUBINVENTORY_CODE (VARCHAR2) — The subinventory holding the on-hand quantity.
• ACCOUNTED_VALUE, ROLLBACK_VALUE, and ROLLBACK_QTY (NUMBER) — The three quantitative measures: summed accounting distribution value, value to be rolled back, and the quantity contributing to inventory value.
• REVISION (VARCHAR2) — The item revision associated with the quantity.
• TXN_SOURCE_TYPE_ID (NUMBER) — The transaction source type for the row being rolled back.
• CATEGORY_ID (NUMBER) — Category identifier enabling category-level valuation.
• FROM_ORGANIZATION_ID / TO_ORGANIZATION_ID (NUMBER) — The origin and destination organizations for intransit quantities.
• INTRANSIT_INV_ACCOUNT (NUMBER) — The account holding intransit value.
• RCV_TRANSACTION_ID and SHIPMENT_LINE_ID (NUMBER) — Receiving and shipment line identifiers linking to the receiving module.

No surrogate primary key is documented; the table is populated and consumed by set-based processes rather than keyed lookups. COST_GROUP_ID and COST_TYPE_ID are the only documented foreign keys.

Common Use Cases and Queries

The primary consumers of this table are the Cost Manager period-close programs, standard cost update routines, and inventory valuation reports. A typical diagnostic query isolates rows by source module:

• SELECT qty_source, organization_id, inventory_item_id, accounted_value, rollback_qty FROM bom.cst_inv_qty_temp WHERE qty_source = :source AND organization_id = :org;
• Aggregation for valuation summaries: SELECT organization_id, inventory_item_id, SUM(accounted_value) FROM bom.cst_inv_qty_temp GROUP BY organization_id, inventory_item_id;
• Intransit reconciliation joining FROM_ORGANIZATION_ID and TO_ORGANIZATION_ID to trace shipped quantities against RCV_TRANSACTION_ID and SHIPMENT_LINE_ID.
• Rollback validation comparing ROLLBACK_VALUE against ACCOUNTED_VALUE to identify mismatches before final period close.

Because the table is session-scoped, queries must be executed within the same database session that spawned the cost process; otherwise the table appears empty.

Related Objects

• CST_COST_GROUPS — joined on COST_GROUP_ID to resolve cost group definitions.
• CST_COST_TYPES — joined on COST_TYPE_ID to resolve cost type context.
• CST_INV_QTY_TEMP is consumed by the cost manager concurrent programs that write to permanent inventory valuation and period-close tables such as CST_PERIOD_CLOSE_SUMMARY and CST_ITEM_COSTS.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID for item description in valuation reports.
• MTL_SECONDARY_INVENTORIES — joined on SUBINVENTORY_CODE for subinventory validation.
• RCV_SHIPMENT_LINES — joined on SHIPMENT_LINE_ID for receiving reconciliation.
• MTL_MATERIAL_TRANSACTIONS — source of transaction activity aggregated into rollback quantities.