DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_OPERATION_RESOURCES

Line 598: UPDATE wip_operation_resources w

594: IN (SELECT wip_entity_id
595: FROM wip_cost_txn_interface wcti
596: WHERE wcti.group_id = p_wcti_group_id );
597:
598: UPDATE wip_operation_resources w
599: SET (relieved_variance_value)
600: = (SELECT NVL(applied_resource_value,0)
601: - NVL(relieved_res_completion_value,0)
602: - NVL(relieved_res_scrap_value,0)

Line 603: FROM wip_operation_resources w2

599: SET (relieved_variance_value)
600: = (SELECT NVL(applied_resource_value,0)
601: - NVL(relieved_res_completion_value,0)
602: - NVL(relieved_res_scrap_value,0)
603: FROM wip_operation_resources w2
604: WHERE w.wip_entity_id = w2.wip_entity_id
605: AND w.organization_id = w2.organization_id
606: AND w.operation_seq_num = w2.operation_seq_num
607: AND w.resource_seq_num = w2.resource_seq_num)