eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CST_WIP_LAYER_COSTS_DTLS_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_WIP_LAYER_COSTS_DTLS_V

View Text

SELECT CWL.WIP_ENTITY_ID
, CWL.WIP_LAYER_ID
, CWL.OPERATION_SEQ_NUM
, CWL.INVENTORY_ITEM_ID
, CWL.INV_LAYER_ID
, CWL.APPLIED_MATL_QTY
, CWL.RELIEVED_MATL_COMP_QTY + CWL.RELIEVED_MATL_SCRAP_QTY + CWL.RELIEVED_MATL_FINAL_COMP_QTY
, SUM(DECODE(CWLCD.COST_ELEMENT_ID
, 1
, NVL(CWLCD.LAYER_COST
, 0)
, 0))
, SUM(DECODE(CWLCD.COST_ELEMENT_ID
, 2
, NVL(CWLCD.LAYER_COST
, 0)
, 0))
, SUM(DECODE(CWLCD.COST_ELEMENT_ID
, 3
, NVL(CWLCD.LAYER_COST
, 0)
, 0))
, SUM(DECODE(CWLCD.COST_ELEMENT_ID
, 4
, NVL(CWLCD.LAYER_COST
, 0)
, 0))
, SUM(DECODE(CWLCD.COST_ELEMENT_ID
, 5
, NVL(CWLCD.LAYER_COST
, 0)
, 0))
, SUM(NVL(CWLCD.LAYER_COST
, 0))
, CWL.CREATE_TXN_ID
FROM CST_WIP_LAYERS CWL
, CST_WIP_LAYER_COST_DETAILS CWLCD
WHERE CWLCD.WIP_LAYER_ID = CWL.WIP_LAYER_ID
AND CWLCD.INV_LAYER_ID = CWL.INV_LAYER_ID GROUP BY CWL.WIP_ENTITY_ID
, CWL.WIP_LAYER_ID
, CWL.OPERATION_SEQ_NUM
, CWL.INVENTORY_ITEM_ID
, CWL.INV_LAYER_ID
, CWL.APPLIED_MATL_QTY
, CWL.RELIEVED_MATL_COMP_QTY + CWL.RELIEVED_MATL_SCRAP_QTY + CWL.RELIEVED_MATL_FINAL_COMP_QTY
, CWL.CREATE_TXN_ID

Columns

Name
WIP_ENTITY_ID
WIP_LAYER_ID
OPERATION_SEQ_NUM
INVENTORY_ITEM_ID
INV_LAYER_ID
ISSUED_QUANTITY
RELIEVED_QUANTITY
MATERIAL_COST
MATERIAL_OVERHEAD_COST
RESOURCE_COST
OUTSIDE_PROCESSING_COST
OVERHEAD_COST
TOTAL_UNIT_COST
CREATE_TRANSACTION_ID