Product: | BOM - Bills of Material |
---|---|
Description: | Stores the item cost and quantity in a period and cost group. |
Implementation/DBA Data: | APPS.CSTFV_PAC_ITEM_COSTS |
SELECT /* REGULAR ATTRIBUTES */ CPIC.COST_LAYER_ID /*PK*/
, CPIC.PAC_PERIOD_ID /*PK*/
, CPIC.COST_GROUP_ID /*PK*/
, CPIC.INVENTORY_ITEM_ID /*PK*/
, CCG.ORGANIZATION_ID
, CPIC.BUY_QUANTITY
, CPIC.MAKE_QUANTITY
, CPIC.ISSUE_QUANTITY
, CPIC.TOTAL_LAYER_QUANTITY
, CPIC.ITEM_COST
, CPIC.ITEM_BUY_COST
, CPIC.ITEM_MAKE_COST
, CPIC.BEGIN_ITEM_COST
, CPIC.MATERIAL_COST
, CPIC.MATERIAL_OVERHEAD_COST
, CPIC.RESOURCE_COST
, CPIC.OVERHEAD_COST
, CPIC.OUTSIDE_PROCESSING_COST
, CPIC.UNBURDENED_COST
, CPIC.BURDEN_COST /* FOREIGN KEYS RESOLVED */
, CPP.PERIOD_NAME
, CCG.COST_GROUP
, '_KF:INV:MSTK:SY' /* ID */ /* WHO */
, CPIC.CREATION_DATE
, CPIC.CREATED_BY
, CPIC.LAST_UPDATE_DATE
, CPIC.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, CST_PAC_PERIODS CPP
, CST_COST_GROUPS CCG
, CST_PAC_ITEM_COSTS CPIC
WHERE CPIC.PAC_PERIOD_ID = CPP.PAC_PERIOD_ID
AND CPIC.COST_GROUP_ID = CCG.COST_GROUP_ID
AND SY.ORGANIZATION_ID = CCG.ORGANIZATION_ID AND CCG.COST_GROUP_TYPE = 2
AND SY.INVENTORY_ITEM_ID = CPIC.INVENTORY_ITEM_ID
AND '_SEC:CCG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY