DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OPERATION_RESOURCES

Line 196: FROM WIP_OPERATION_RESOURCES WOR

192: CURSOR workorder_resources_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS
193: select WOR.START_DATE, WOR.COMPLETION_DATE,
194: WOR.OPERATION_SEQ_NUM,
195: WOR.RESOURCE_SEQ_NUM
196: FROM WIP_OPERATION_RESOURCES WOR
197: WHERE WOR.WIP_ENTITY_ID = l_obj_id
198: AND l_obj_type_id = 1;
199:
200: CURSOR workorder_res_inst_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS

Line 722: UPDATE WIP_OPERATION_RESOURCES WOR

718: WHERE WO.WIP_ENTITY_ID = l_work_object_id
719: AND l_work_object_type_id = 1;
720:
721:
722: UPDATE WIP_OPERATION_RESOURCES WOR
723: SET WOR.START_DATE = WOR.START_DATE + l_offset_days,
724: WOR.COMPLETION_DATE = WOR.COMPLETION_DATE + l_offset_days
725: WHERE WOR.WIP_ENTITY_ID = l_work_object_id
726: AND l_work_object_type_id = 1;