DBA Data[Home] [Help]

APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_RESOURCE_EQUIPMENTS

Line 322: from bom_resource_equipments breq,

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

Line 390: from bom_resource_equipments breq,

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