DBA Data[Home] [Help]

APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_DEPT_RES_INSTANCES

Line 227: from bom_dept_res_instances

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 (
226: select instance_id
227: from bom_dept_res_instances
228: where resource_id=p_resource_id and department_id=p_dept_id);
229:
230: l_error_exists boolean := false;
231: l_dept_id number;

Line 281: from bom_dept_res_instances

277: and wjdi.resource_seq_num = p_resource_seq_num
278: and wjdi.resource_instance_id = p_resource_instance_id
279: and wjdi.resource_instance_id not in (
280: select instance_id
281: from bom_dept_res_instances
282: where resource_id=l_resource_id and department_id=l_dept_id);
283: end if;
284:
285: end valid_resource_instance;

Line 318: bom_dept_res_instances_eqp_v bdri,

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

Line 386: bom_dept_res_instances_eqp_v bdri,

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