DBA Data[Home] [Help]

APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 793: UPDATE WIP_OP_RESOURCE_INSTANCES

789: WHERE WIP_ENTITY_ID = p_wip_entity_id
790: AND OPERATION_SEQ_NUM = p_op_seq_num
791: AND RESOURCE_SEQ_NUM = op_res_info_tbl(i).res_seq_num;
792:
793: UPDATE WIP_OP_RESOURCE_INSTANCES
794: set start_date = l_res_start_date
795: , completion_date = l_res_completion_date
796: WHERE WIP_ENTITY_ID = p_wip_entity_id
797: AND OPERATION_SEQ_NUM = p_op_seq_num

Line 1749: FROM WIP_OP_RESOURCE_INSTANCES

1745: l_WipOperResource_tbl,
1746: l_WipOperResInst_tbl,
1747: l_WipOperResInstSt_tbl,
1748: l_WipOperResInstEnd_tbl
1749: FROM WIP_OP_RESOURCE_INSTANCES
1750: WHERE wip_entity_id = p_wip_entity_id
1751: AND organization_id = p_organization_id;
1752:
1753: IF l_WipOperResInst_tbl.COUNT > 0 THEN