DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 582: UPDATE wip_req_operation_cost_details w

578: l_stmt_num := 70;
579:
580: IF (l_costing_method IN (2, 5, 6)) THEN
581:
582: UPDATE wip_req_operation_cost_details w
583: SET (relieved_variance_value)
584: = (SELECT NVL(applied_matl_value,0)
585: - NVL(relieved_matl_completion_value,0)
586: - NVL(relieved_matl_scrap_value,0)

Line 587: FROM wip_req_operation_cost_details w2

583: SET (relieved_variance_value)
584: = (SELECT NVL(applied_matl_value,0)
585: - NVL(relieved_matl_completion_value,0)
586: - NVL(relieved_matl_scrap_value,0)
587: FROM wip_req_operation_cost_details w2
588: WHERE w.wip_entity_id = w2.wip_entity_id
589: AND w.organization_id = w2.organization_id
590: AND w.inventory_item_id = w2.inventory_item_id
591: AND w.operation_seq_num = w2.operation_seq_num