DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_OPERATION_OVERHEADS

Line 579: UPDATE wip_operation_overheads w

575: IN (SELECT wip_entity_id
576: FROM wip_cost_txn_interface wcti
577: WHERE wcti.group_id = p_wcti_group_id);
578:
579: UPDATE wip_operation_overheads w
580: SET (relieved_variance_value)
581: = (SELECT NVL(applied_ovhd_value,0)
582: - NVL(relieved_ovhd_completion_value,0)
583: - NVL(relieved_ovhd_scrap_value,0)

Line 584: FROM wip_operation_overheads w2

580: SET (relieved_variance_value)
581: = (SELECT NVL(applied_ovhd_value,0)
582: - NVL(relieved_ovhd_completion_value,0)
583: - NVL(relieved_ovhd_scrap_value,0)
584: FROM wip_operation_overheads w2
585: WHERE w.wip_entity_id = w2.wip_entity_id
586: AND w.organization_id = w2.organization_id
587: AND w.operation_seq_num = w2.operation_seq_num
588: AND w.resource_seq_num = w2.resource_seq_num