APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_DEPARTMENT_RESOURCES

Line 227: bom_department_resources bdr

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
231: and bdri.department_id = nvl(bdr.share_from_dept_id,bdr.department_id));

Line 283: bom_department_resources bdr

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
287: and bdri.department_id = nvl(bdr.share_from_dept_id,bdr.department_id));

Line 325: bom_department_resources bdr

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
328: and bdri.resource_id = bdr.resource_id
329: and bdri.department_id = nvl(bdr.share_from_dept_id, bdr.department_id)

Line 393: bom_department_resources bdr

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
396: and bdri.resource_id = bdr.resource_id
397: and bdri.department_id = nvl(bdr.share_from_dept_id, bdr.department_id)