APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_DEPT_RES_INSTANCES

Line 226: from bom_dept_res_instances bdri,

222: and wjdi.operation_seq_num = p_operation_seq_num
223: and wjdi.resource_seq_num = p_resource_seq_num
224: and wjdi.resource_instance_id = p_resource_instance_id
225: and wjdi.resource_instance_id not in ( select bdri.instance_id
226: from bom_dept_res_instances bdri,
227: bom_department_resources bdr
228: where bdr.department_id = p_dept_id
229: and bdr.resource_id = p_resource_id
230: and bdri.resource_id = bdr.resource_id

Line 282: from bom_dept_res_instances bdri,

278: and wjdi.operation_seq_num = p_operation_seq_num
279: and wjdi.resource_seq_num = p_resource_seq_num
280: and wjdi.resource_instance_id = p_resource_instance_id
281: and wjdi.resource_instance_id not in ( select bdri.instance_id
282: from bom_dept_res_instances bdri,
283: bom_department_resources bdr
284: where bdr.department_id = l_dept_id
285: and bdr.resource_id = l_resource_id
286: and bdri.resource_id = bdr.resource_id

Line 323: bom_dept_res_instances_eqp_v bdri,

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
327: and bdr.department_id = p_dept_id

Line 391: bom_dept_res_instances_eqp_v bdri,

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
395: and bdr.department_id = l_dept_id