566: sum( CWL.temp_relieved_qty * CWLCD.layer_cost ),
567: sum( CWL.temp_relieved_qty * CWLCD.layer_cost )
568: from
569: cst_wip_layers CWL,
570: cst_wip_layer_cost_details CWLCD
571: where
572: CWL.wip_entity_id = WROCD.wip_entity_id and
573: CWL.operation_seq_num = WROCD.operation_seq_num and
574: CWL.inventory_item_id = WROCD.inventory_item_id and
1566: sum( CWL.temp_relieved_qty * CWLCD.layer_cost ),
1567: sum( CWL.temp_relieved_qty * CWLCD.layer_cost )
1568: from
1569: cst_wip_layers CWL,
1570: cst_wip_layer_cost_details CWLCD
1571: where
1572: CWL.wip_entity_id = WROCD.wip_entity_id and
1573: CWL.operation_seq_num = WROCD.operation_seq_num and
1574: CWL.inventory_item_id = WROCD.inventory_item_id and