DBA Data[Home] [Help]

APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_RESOURCE_EQUIPMENTS

Line 317: from bom_resource_equipments breq,

313: from bom_resources
314: where resource_type = 1) /* machine type resource */
315: and p_resource_serial_number not in(
316: select bdri.serial_number
317: from bom_resource_equipments breq,
318: bom_dept_res_instances_eqp_v bdri,
319: mtl_system_items_kfv msik,
320: bom_department_resources bdr
321: where bdr.resource_id = p_resource_id

Line 385: from bom_resource_equipments breq,

381: from bom_resources
382: where resource_type = 1) /* machine type resource */
383: and p_resource_serial_number not in(
384: select bdri.serial_number
385: from bom_resource_equipments breq,
386: bom_dept_res_instances_eqp_v bdri,
387: mtl_system_items_kfv msik,
388: bom_department_resources bdr
389: where bdr.resource_id = l_resource_id