DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 218: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj

214: woru.resource_seq_num,
215: woru.instance_id,
216: woru.serial_number,
217: woru.assigned_units
218: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj
219: WHERE woru.wip_entity_id = l_obj_id
220: AND wdj.wip_entity_id = l_obj_id
221: -- AND wdj.firm_planned_flag = l_cur_firm_flag
222: AND l_obj_type_id = 1;

Line 729: UPDATE WIP_OPERATION_RESOURCE_USAGE WORU

725: WHERE WOR.WIP_ENTITY_ID = l_work_object_id
726: AND l_work_object_type_id = 1;
727:
728:
729: UPDATE WIP_OPERATION_RESOURCE_USAGE WORU
730: SET WORU.START_DATE = WORU.START_DATE + l_offset_days,
731: WORU.COMPLETION_DATE = WORU.COMPLETION_DATE + l_offset_days
732: WHERE WORU.WIP_ENTITY_ID = l_work_object_id
733: AND l_work_object_type_id = 1;