APPS.WIP_RES_INST_VALIDATIONS dependencies on BOM_RESOURCES

Line 313: from bom_resources

309: and wjdi.operation_seq_num = p_operation_seq_num
310: and wjdi.resource_seq_num = p_resource_seq_num
311: and wjdi.resource_instance_id = p_resource_instance_id
312: and p_resource_id in (select resource_id
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,

Line 381: from bom_resources

377: and wjdi.operation_seq_num = p_operation_seq_num
378: and wjdi.resource_seq_num = p_resource_seq_num
379: and wjdi.resource_instance_id = p_resource_instance_id
380: and l_resource_id in (select resource_id
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,

Line 637: from bom_resources br, wip_operation_resources wor

633:
634: begin
635: select br.resource_type
636: into l_resource_type
637: from bom_resources br, wip_operation_resources wor
638: where wor.wip_entity_id = p_wip_entity_id
639: and wor.organization_id = p_organization_id
640: and wor.operation_seq_num = cur_row.operation_seq_num
641: and wor.resource_seq_num = cur_row.resource_seq_num

Line 869: from bom_resources br, wip_operation_resources wor

865:
866: begin
867: select br.resource_type
868: into l_resource_type
869: from bom_resources br, wip_operation_resources wor
870: where wor.wip_entity_id = p_wip_entity_id
871: and wor.organization_id = p_organization_id
872: and wor.operation_seq_num = cur_row.operation_seq_num
873: and wor.resource_seq_num = cur_row.resource_seq_num