DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 548: UPDATE wip_req_operation_cost_details w

544: l_stmt_num := 70;
545:
546: IF (l_costing_method IN (2, 5, 6)) THEN
547:
548: UPDATE wip_req_operation_cost_details w
549: SET (relieved_variance_value)
550: = (SELECT NVL(applied_matl_value,0)
551: - NVL(relieved_matl_completion_value,0)
552: - NVL(relieved_matl_scrap_value,0)

Line 553: FROM wip_req_operation_cost_details w2

549: SET (relieved_variance_value)
550: = (SELECT NVL(applied_matl_value,0)
551: - NVL(relieved_matl_completion_value,0)
552: - NVL(relieved_matl_scrap_value,0)
553: FROM wip_req_operation_cost_details w2
554: WHERE w.wip_entity_id = w2.wip_entity_id
555: AND w.organization_id = w2.organization_id
556: AND w.inventory_item_id = w2.inventory_item_id
557: AND w.operation_seq_num = w2.operation_seq_num