DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 210: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj

206: woru.resource_seq_num,
207: woru.instance_id,
208: woru.serial_number,
209: woru.assigned_units
210: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj
211: WHERE woru.wip_entity_id = l_obj_id
212: AND wdj.wip_entity_id = l_obj_id
213: -- AND wdj.firm_planned_flag = l_cur_firm_flag
214: AND l_obj_type_id = 1;

Line 701: UPDATE WIP_OPERATION_RESOURCE_USAGE WORU

697: WHERE WOR.WIP_ENTITY_ID = l_work_object_id
698: AND l_work_object_type_id = 1;
699:
700:
701: UPDATE WIP_OPERATION_RESOURCE_USAGE WORU
702: SET WORU.START_DATE = WORU.START_DATE + l_offset_days,
703: WORU.COMPLETION_DATE = WORU.COMPLETION_DATE + l_offset_days
704: WHERE WORU.WIP_ENTITY_ID = l_work_object_id
705: AND l_work_object_type_id = 1;