Results for “inventory_value”

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

Overview

APPS.CST_PERIOD_SUMMARY_V is a consolidation view in the Oracle E-Business Suite inventory and costing schema. It presents period-end inventory valuation results at the organization, accounting period, and secondary inventory (subinventory) level. The view is defined over two complementary data sources — MTL_PERIOD_SUMMARY and CST_PERIOD_CLOSE_SUMMARY — and merges their results into a single result set using a UNION ALL construct.

The view exists to give reporting tools, concurrent programs, and custom integrations a single access point for period summary information without requiring callers to reconcile the two underlying tables themselves. Period summary records originate from the period close and inventory valuation processes, while period close summary records hold rollback-oriented adjustment values captured during the close cycle. By exposing both through one view, CST_PERIOD_SUMMARY_V allows reports such as inventory value summaries and period close reconciliations to retrieve a unified picture of inventory value across reporting periods.

It is owned by the APPS schema and is documented under the BOM — Bills of Material product family, which shares the Oracle Inventory and Cost Management data model. The view is marked VALID in the ETRM metadata for release 12.2.2 and is equally applicable to 12.1.1, where the same underlying tables and lookup conventions exist.

Underlying Base Objects

The view is defined over four referenced objects: MTL_PERIOD_SUMMARY (SYNONYM), CST_PERIOD_CLOSE_SUMMARY (SYNONYM), MTL_SECONDARY_INVENTORIES (SYNONYM), and MFG_LOOKUPS (VIEW).

• MTL_PERIOD_SUMMARY — Supplies the primary inventory valuation rows. The view selects ACCT_PERIOD_ID, ORGANIZATION_ID, SECONDARY_INVENTORY, and INVENTORY_VALUE from this table, joining to the secondary inventory definition to obtain a description.
• CST_PERIOD_CLOSE_SUMMARY — Supplies close-cycle adjustment rows. The view sums NVL(ROLLBACK_VALUE, 0) rather than the accounted value, because the accounted value is adjusted to the rollback value. Results are grouped by accounting period, organization, and subinventory.
• MTL_SECONDARY_INVENTORIES — Joined with an outer join (+) on both ORGANIZATION_ID and the subinventory name, providing the SECONDARY_INVENTORY_NAME and DESCRIPTION for each row.
• MFG_LOOKUPS — Joined on LOOKUP_TYPE = 'CST_PER_CLOSE_MISC' and LOOKUP_CODE = 1 to supply a default MEANING where no subinventory is present (for example, organization-level totals).

The UNION ALL preserves all rows from both branches, including duplicates across the two sources, so totals are additive rather than de-duplicated.

Key Columns

• ACCT_PERIOD_ID — Identifier of the accounting period (from GL/ORG period definitions) to which the summary row belongs.
• ORGANIZATION_ID — Inventory organization for which the valuation is reported.
• SECONDARY_INVENTORY — The subinventory name; NULL where the row represents an organization-level or non-subinventory total.
• DESCRIPTION — A DECODE result: when SECONDARY_INVENTORY is NULL, the MFG_LOOKUPS meaning is returned; otherwise the subinventory description from MTL_SECONDARY_INVENTORIES.
• INVENTORY_VALUE — For the MTL_PERIOD_SUMMARY branch, the stored inventory value. For the CST_PERIOD_CLOSE_SUMMARY branch, the sum of rollback values. The two branches carry different semantics under the same column name, which is an important consideration when writing queries.

Common Use Cases and Queries

The view is typically used to report period-end inventory value by organization, period, and subinventory, and to reconcile close-summary adjustments against the primary period summary. A representative query joining to organization and period definitions follows:

• Inventory value by organization and period:
  SELECT cps.acct_period_id, cps.organization_id, cps.secondary_inventory, cps.description, cps.inventory_value FROM apps.cst_period_summary_v cps WHERE cps.organization_id = :org_id AND cps.acct_period_id = :period_id ORDER BY cps.secondary_inventory;
• Total value per organization and period:
  SELECT organization_id, acct_period_id, SUM(inventory_value) FROM apps.cst_period_summary_v GROUP BY organization_id, acct_period_id;
• Subinventory-level detail:
  SELECT secondary_inventory, description, inventory_value FROM apps.cst_period_summary_v WHERE organization_id = :org_id AND acct_period_id = :period_id AND secondary_inventory IS NOT NULL ORDER BY description;

Because the view relies on outer joins and UNION ALL, no GROUP BY is applied across branches, and the INVENTORY_VALUE column mixes stored valuation with summed rollback values. Consumers should therefore treat rows as period-level components rather than as a single normalized measure when interpreting results.