Search Results cst_per_close_dtls_v




Overview
Explore in AI Chat

Overview

CST_PER_CLOSE_DTLS_V is an Oracle E-Business Suite reporting view owned by the APPS schema. It consolidates period-close detail information drawn from two distinct sources: MTL_PER_CLOSE_DTLS, which stores period-end on-hand balances and unit costs, and CST_PERIOD_CLOSE_SUMMARY, which stores rollback quantities and rollback values. By combining both data sets through a UNION ALL operation, the view presents a single, unified result set of period-close lines keyed by accounting period, organization, cost group, and inventory item. This makes it suitable for period-close reconciliation, cost accounting analysis, and downstream reporting or integration where a consolidated view of period-end inventory positions and rollback activity is required. In the EBS 12.1.1 and 12.2.2 releases, the view resides in the BOM (Bills of Material) product family and is documented in ETRM as VALID.

Underlying Base Objects

The view is defined strictly over two documented base objects, both referenced as SYNONYMs in the APPS schema:

  • MTL_PER_CLOSE_DTLS — supplies the period-end on-hand snapshot, including period-end quantity and period-end unit cost.
  • CST_PERIOD_CLOSE_SUMMARY — supplies rollback quantities and rollback values for the cost period close process.

The two sources are joined logically by UNION ALL rather than a relational join, so no key-level merge occurs. Each source independently contributes rows sharing the same column projection. Note that the two branches are not perfectly symmetric: the first branch projects SECONDARY_INVENTORY (from MTL_PER_CLOSE_DTLS), while the second projects SUBINVENTORY_CODE (from CST_PERIOD_CLOSE_SUMMARY) in the same column position. Columns are aligned positionally, so consumers must interpret that position with care depending on the originating branch.

Key Columns

  • ACCT_PERIOD_ID — the accounting period identifier, the primary search key for this view. It links to the period definitions used by the cost and inventory close processes.
  • ORGANIZATION_ID — the inventory organization to which the close detail belongs.
  • COST_GROUP_ID — the cost group associated with the line, used in cost group reporting.
  • SECONDARY_INVENTORY / SUBINVENTORY_CODE — the storage location. The first branch returns SECONDARY_INVENTORY; the second returns SUBINVENTORY_CODE in the same position.
  • INVENTORY_ITEM_ID — the inventory item identifier for the close line.
  • PERIOD_END_QUANTITY — period-end on-hand quantity from MTL_PER_CLOSE_DTLS.
  • PERIOD_END_UNIT_COST — period-end unit cost from MTL_PER_CLOSE_DTLS.

For rows originating in CST_PERIOD_CLOSE_SUMMARY, PERIOD_END_QUANTITY carries ROLLBACK_QUANTITY and PERIOD_END_UNIT_COST carries a derived value: DECODE(ROLLBACK_QUANTITY, 0, 0, ROLLBACK_VALUE / ROLLBACK_QUANTITY). This yields the rollback unit amount, guarding against division by zero.

Common Use Cases and Queries

Typical uses include reviewing all period-close detail for a given accounting period across organizations, reconciling period-end quantities against rollback quantities, and feeding cost-close reporting. A common query filters by period:

  • SELECT ACCT_PERIOD_ID, ORGANIZATION_ID, COST_GROUP_ID, INVENTORY_ITEM_ID, PERIOD_END_QUANTITY, PERIOD_END_UNIT_COST FROM APPS.CST_PER_CLOSE_DTLS_V WHERE ACCT_PERIOD_ID = :p_period_id;
  • Joining to MTL_SYSTEM_ITEMS_VL on INVENTORY_ITEM_ID for item descriptions.
  • Aggregating PERIOD_END_QUANTITY and value (quantity × unit cost) by ORGANIZATION_ID and COST_GROUP_ID.

Because the view is a UNION ALL, consumers should expect duplicate item/organization combinations when the same item appears in both base tables, and should apply appropriate aggregation or source filtering for their reporting purpose.