DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_OPERATION_RESOURCES

Line 564: UPDATE wip_operation_resources w

560: IN (SELECT wip_entity_id
561: FROM wip_cost_txn_interface wcti
562: WHERE wcti.group_id = p_wcti_group_id );
563:
564: UPDATE wip_operation_resources w
565: SET (relieved_variance_value)
566: = (SELECT NVL(applied_resource_value,0)
567: - NVL(relieved_res_completion_value,0)
568: - NVL(relieved_res_scrap_value,0)

Line 569: FROM wip_operation_resources w2

565: SET (relieved_variance_value)
566: = (SELECT NVL(applied_resource_value,0)
567: - NVL(relieved_res_completion_value,0)
568: - NVL(relieved_res_scrap_value,0)
569: FROM wip_operation_resources w2
570: WHERE w.wip_entity_id = w2.wip_entity_id
571: AND w.organization_id = w2.organization_id
572: AND w.operation_seq_num = w2.operation_seq_num
573: AND w.resource_seq_num = w2.resource_seq_num)