59: FROM wip_discrete_jobs wdj,
60: wip_entities we,
61: mtl_serial_numbers msn,
62: csi_item_instances cii,
63: mtl_parameters mp,
64: bom_resource_equipments bre,
65: bom_dept_res_instances bdri,
66: wip_operations wo
67: WHERE
216:
217:
218:
219: select calendar_code, calendar_exception_set_id into l_calendar_code, l_exception_set_id
220: from mtl_parameters where organization_id=p_org_id;
221:
222: l_stmt_num := 15;
223: SELECT bom_resource_downtime_group_s.nextval
224: INTO l_downtime_group_id