Results for “std_qty”

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

Overview

CM_SCST_LED (Standard Costs Ledger) is a table owned by the GMF schema within Oracle E-Business Suite, belonging to the Process Manufacturing Financials (GMF) product family. In EBS 12.1.1 and 12.2.2 the object remains a VALID dictionary table with 34 documented columns. Its purpose is to act as a cost ledger capturing the outcome of the cost rollup process, recording the performed cost calculations for each manufactured product. Rows are inserted during cost rollup, and the table preserves the formula and routing detail underlying each calculated standard cost, giving process manufacturers a persistent audit trail of how component, resource, and overhead amounts were derived for a given item, warehouse, and routing quantity.

From a Data Vault modeling perspective, the metadata's heuristic classification is link. This reflects the table's structural role as a junction between items, resources, components, warehouses, and units of measure rather than a pure descriptive satellite. Analysts modeling this source into a vault-style warehouse should treat RUDTL_ID as the effective key, with item, resource, and component references forming the link relationships.

Key Information Stored

The documented primary key is CM_SCST_LED_PK, defined on the surrogate column RUDTL_ID. No additional unique index is documented, so RUDTL_ID is the sole business-key candidate available in the metadata. The most significant descriptive and foreign-key columns include:

• ITEM_ID and INVENTORY_ITEM_ID — the product whose standard cost is being rolled up; these join to the item master tables.
• WHSE_CODE and ORGANIZATION_ID — the warehouse and inventory organization context for the costing calculation.
• RESOURCES, RESOURCE_COUNT, and RESOURCE_USAGE — identification and consumption detail for routing resources used in the rollup.
• CMPNTCOST_ID — reference to the component cost detail row in CM_CMPT_DTL.
• LINE_TYPE — classifies the ledger line (for example, component versus resource cost).
• STD_QTY, ROUTING_QTY, PRODUCT_QTY, ITEM_QTY, ITEM_FMQTY, and CMPNT_COST — the quantitative basis and component cost amounts used in the calculation.
• NOMINAL_COST and COST_ALLOC — the resulting nominal cost and its allocation.
• FORM_PROD_UM / FORM_PROD_UOM, ITEM_FMQTY_UM / ITEM_FMQTY_UOM, and USAGE_UM / USAGE_UOM — unit-of-measure columns (with both legacy and newer naming variants present in the 34-column definition) joining to SY_UOMS_MST.
• Standard audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, DELETE_MARK, and the concurrent request columns REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical reporting scenarios include tracing the component and resource cost build-up behind a rolled-up standard cost, reconciling GMF costing results against GL postings, and auditing which rollup request produced a given set of ledger rows. Because REQUEST_ID and PROGRAM_ID are captured, cost accountants can isolate the output of a specific rollup run.

A representative query joins the ledger to the item master and resource master:

• SELECT l.RUDTL_ID, l.ITEM_ID, l.WHSE_CODE, l.RESOURCES, l.NOMINAL_COST, l.CMPNT_COST FROM GMF.CM_SCST_LED l WHERE l.DELETE_MARK = 0 AND l.ITEM_ID = :item_id;
• Rollup-run audit: SELECT * FROM GMF.CM_SCST_LED WHERE REQUEST_ID = :request_id ORDER BY RUDTL_ID;
• Cost detail drill-down: join CM_SCST_LED.CMPNTCOST_ID = CM_CMPT_DTL.CMPNTCOST_ID to expand component cost components.

Related Objects

The FK metadata identifies the principal dependencies and dependents of this table:

• CM_CMPT_DTL — referenced via CM_SCST_LED.CMPNTCOST_ID, supplying component cost detail.
• CR_RSRC_MST and CR_RSRC_MST_B — referenced via CM_SCST_LED.RESOURCES, providing resource definitions.
• IC_ITEM_MST and IC_ITEM_MST_B — referenced via CM_SCST_LED.ITEM_ID, the item master.
• IC_WHSE_MST — referenced via CM_SCST_LED.WHSE_CODE, the warehouse master.
• SY_UOMS_MST — referenced three times via FORM_PROD_UM, ITEM_FMQTY_UM, and USAGE_UM, supplying unit-of-measure validation.
• CM_SCST_LED_EFC — the dependent table referencing CM_SCST_LED.RUDTL_ID, typically used for extended/effective cost attributes.