DBA Data[Home] [Help]

APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 812: UPDATE WIP_OP_RESOURCE_INSTANCES

808: WHERE WIP_ENTITY_ID = p_wip_entity_id
809: AND OPERATION_SEQ_NUM = p_op_seq_num
810: AND RESOURCE_SEQ_NUM = op_res_info_tbl(i).res_seq_num;
811:
812: UPDATE WIP_OP_RESOURCE_INSTANCES
813: set start_date = l_res_start_date
814: , completion_date = l_res_completion_date
815: WHERE WIP_ENTITY_ID = p_wip_entity_id
816: AND OPERATION_SEQ_NUM = p_op_seq_num

Line 1768: FROM WIP_OP_RESOURCE_INSTANCES

1764: l_WipOperResource_tbl,
1765: l_WipOperResInst_tbl,
1766: l_WipOperResInstSt_tbl,
1767: l_WipOperResInstEnd_tbl
1768: FROM WIP_OP_RESOURCE_INSTANCES
1769: WHERE wip_entity_id = p_wip_entity_id
1770: AND organization_id = p_organization_id;
1771:
1772: IF l_WipOperResInst_tbl.COUNT > 0 THEN