APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_RESOURCES

Line 318: from bom_resources

314: and wjdi.operation_seq_num = p_operation_seq_num
315: and wjdi.resource_seq_num = p_resource_seq_num
316: and wjdi.resource_instance_id = p_resource_instance_id
317: and p_resource_id in (select resource_id
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,

Line 386: from bom_resources

382: and wjdi.operation_seq_num = p_operation_seq_num
383: and wjdi.resource_seq_num = p_resource_seq_num
384: and wjdi.resource_instance_id = p_resource_instance_id
385: and l_resource_id in (select resource_id
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,

Line 642: from bom_resources br, wip_operation_resources wor

638:
639: begin
640: select br.resource_type
641: into l_resource_type
642: from bom_resources br, wip_operation_resources wor
643: where wor.wip_entity_id = p_wip_entity_id
644: and wor.organization_id = p_organization_id
645: and wor.operation_seq_num = cur_row.operation_seq_num
646: and wor.resource_seq_num = cur_row.resource_seq_num

Line 874: from bom_resources br, wip_operation_resources wor

870:
871: begin
872: select br.resource_type
873: into l_resource_type
874: from bom_resources br, wip_operation_resources wor
875: where wor.wip_entity_id = p_wip_entity_id
876: and wor.organization_id = p_organization_id
877: and wor.operation_seq_num = cur_row.operation_seq_num
878: and wor.resource_seq_num = cur_row.resource_seq_num