DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_OPERATION_OVERHEADS

Line 613: UPDATE wip_operation_overheads w

609: IN (SELECT wip_entity_id
610: FROM wip_cost_txn_interface wcti
611: WHERE wcti.group_id = p_wcti_group_id);
612:
613: UPDATE wip_operation_overheads w
614: SET (relieved_variance_value)
615: = (SELECT NVL(applied_ovhd_value,0)
616: - NVL(relieved_ovhd_completion_value,0)
617: - NVL(relieved_ovhd_scrap_value,0)

Line 618: FROM wip_operation_overheads w2

614: SET (relieved_variance_value)
615: = (SELECT NVL(applied_ovhd_value,0)
616: - NVL(relieved_ovhd_completion_value,0)
617: - NVL(relieved_ovhd_scrap_value,0)
618: FROM wip_operation_overheads w2
619: WHERE w.wip_entity_id = w2.wip_entity_id
620: AND w.organization_id = w2.organization_id
621: AND w.operation_seq_num = w2.operation_seq_num
622: AND w.resource_seq_num = w2.resource_seq_num