DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 206: FROM WIP_OP_RESOURCE_INSTANCES WORI

202: wORI.OPERATION_SEQ_NUM,
203: WORI.RESOURCE_SEQ_NUM,
204: WORI.INSTANCE_ID,
205: WORI.SERIAL_NUMBER
206: FROM WIP_OP_RESOURCE_INSTANCES WORI
207: WHERE WORI.WIP_ENTITY_ID = l_obj_id
208: AND l_obj_type_id = 1;
209:
210: CURSOR workorder_res_usage_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS

Line 736: UPDATE WIP_OP_RESOURCE_INSTANCES WORI

732: WHERE WORU.WIP_ENTITY_ID = l_work_object_id
733: AND l_work_object_type_id = 1;
734:
735:
736: UPDATE WIP_OP_RESOURCE_INSTANCES WORI
737: SET WORI.START_DATE = WORI.START_DATE + l_offset_days,
738: WORI.COMPLETION_DATE = WORI.COMPLETION_DATE + l_offset_days
739: WHERE WORI.WIP_ENTITY_ID = l_work_object_id
740: AND l_work_object_type_id = 1;