Results for “cstbv_pac_quantity_layers”

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

Overview

CSTBV_PAC_QUANTITY_LAYERS is an Oracle E-Business Suite (EBS) view owned by the APPS schema and defined as a read-only reporting object within the Bills of Material (BOM) product family. Its documented purpose is to present the layer quantity of an item by period, bridging the periodic average costing (PAC) infrastructure with inventory item and cost group information. The view carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2 and is exposed primarily for reporting, inquiry, and integration scenarios where users require visibility into quantity layers tied to a specific PAC period and cost group.

A notable characteristic of the view is the presence of the BEGIN_LAYER_QUANTITY column, which corresponds to the user search term. This column exposes the opening layer quantity for an item within a given PAC period, allowing comparisons between beginning and ending layer quantities across cost layers. Because the view is defined WITH READ ONLY, it is suitable for query and reporting purposes only and cannot be used as a DML target.

Underlying Base Objects

The view is defined over four base objects accessed through APPS synonyms:

• CST_PAC_QUANTITY_LAYERS (CPQL) — the primary table, supplying the quantity layer records, cost layer identifiers, PAC period, cost group, inventory item, and quantity values.
• CST_PAC_PERIODS (CPP) — joined on CPQL.PAC_PERIOD_ID = CPP.PAC_PERIOD_ID to resolve the period name.
• CST_COST_GROUPS (CCG) — joined on CPQL.COST_GROUP_ID = CCG.COST_GROUP_ID, restricted to COST_GROUP_TYPE = 2, and used to resolve the cost group name and organization.
• MTL_SYSTEM_ITEMS (SY) — joined on SY.ORGANIZATION_ID = CCG.ORGANIZATION_ID and SY.INVENTORY_ITEM_ID = CPQL.INVENTORY_ITEM_ID, enforcing organization-level item context.

The join structure therefore enforces that only quantity layers belonging to a valid PAC period, a type-2 cost group, and a matching inventory item within the same organization are returned.

Key Columns

• QUANTITY_LAYER_ID and COST_LAYER_ID — composite primary key columns identifying the layer record.
• PAC_PERIOD_ID / PAC_PERIOD_NAME — the PAC period identifier and resolved period name.
• COST_GROUP_ID / COST_GROUP_NAME — the cost group identifier and name.
• INVENTORY_ITEM_ID — the inventory item identity used in organization-scoped joins.
• LAYER_QUANTITY — the ending quantity held in the layer for the period.
• BEGIN_LAYER_QUANTITY — the opening quantity of the layer at the beginning of the PAC period.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, UPDATED_BY — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include periodic average cost analysis, layer movement reporting, and reconciliation of beginning versus ending layer quantities by item, cost group, and period.

• Compare beginning and ending layer quantities for an item within a PAC period.
• Report layer quantities across cost groups within an organization.
• Feed downstream cost accounting extracts and reconciliation reports.

Sample query:

SELECT inventory_item_id, pac_period_name, cost_group_name, begin_layer_quantity, layer_quantity FROM apps.cstbv_pac_quantity_layers WHERE inventory_item_id = :item_id AND pac_period_name = :period_name ORDER BY cost_group_name;

The view is read-only and should be consumed strictly for inquiry and reporting within the BOM and Cost Management reporting landscape.