318: from bom_resources
319: where resource_type = 1) /* machine type resource */
320: and p_resource_serial_number not in(
321: select bdri.serial_number
322: from bom_resource_equipments breq,
323: bom_dept_res_instances_eqp_v bdri,
324: mtl_system_items_kfv msik,
325: bom_department_resources bdr
326: where bdr.resource_id = p_resource_id
386: from bom_resources
387: where resource_type = 1) /* machine type resource */
388: and p_resource_serial_number not in(
389: select bdri.serial_number
390: from bom_resource_equipments breq,
391: bom_dept_res_instances_eqp_v bdri,
392: mtl_system_items_kfv msik,
393: bom_department_resources bdr
394: where bdr.resource_id = l_resource_id