DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OPERATIONS

Line 171: FROM WIP_OPERATIONS WO

167: CURSOR workorder_operations_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS
168: select WO.FIRST_UNIT_START_DATE START_DATE,
169: WO.FIRST_UNIT_COMPLETION_DATE COMPLETION_DATE,
170: WO.OPERATION_SEQ_NUM,WO.DESCRIPTION,WO.LONG_DESCRIPTION
171: FROM WIP_OPERATIONS WO
172: WHERE WO.WIP_ENTITY_ID = l_obj_id
173: AND l_obj_type_id = 1;
174:
175: CURSOR workorder_material_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS

Line 685: UPDATE WIP_OPERATIONS WO

681: AND l_work_object_type_id = 1;
682:
683:
684:
685: UPDATE WIP_OPERATIONS WO
686: SET WO.FIRST_UNIT_START_DATE = WO.FIRST_UNIT_START_DATE + l_offset_days,
687: WO.FIRST_UNIT_COMPLETION_DATE = WO.FIRST_UNIT_COMPLETION_DATE + l_offset_days,
688: WO.LAST_UNIT_START_DATE = WO.LAST_UNIT_START_DATE + l_offset_days,
689: WO.LAST_UNIT_COMPLETION_DATE = WO.LAST_UNIT_COMPLETION_DATE + l_offset_days