eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_OPERATION_SEQUENCES

Line 316: FROM BOM_OPERATION_SEQUENCES oper,

312: WHERE tmp.AssemblyItemName = P_assembly_item_name
313: AND tmp.OrganizationCode = P_organization_code
314: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
315: AND EXISTS (SELECT 1
316: FROM BOM_OPERATION_SEQUENCES oper,
317: bom_operational_routings rtg,
318: mtl_parameters org,
319: mtl_system_items_kfv item
320: WHERE rtg.routing_sequence_id = oper.routing_sequence_id

Line 391: FROM BOM_OPERATION_SEQUENCES oper,

387: WHERE tmp.AssemblyItemName = P_assembly_item_name
388: AND tmp.OrganizationCode = P_organization_code
389: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
390: AND NOT EXISTS (SELECT 1
391: FROM BOM_OPERATION_SEQUENCES oper,
392: bom_operational_routings rtg,
393: mtl_parameters org,
394: mtl_system_items_kfv item
395: WHERE rtg.routing_sequence_id = oper.routing_sequence_id

Line 456: bom_operation_sequences oper,

452: AND tmp.OrganizationCode = P_organization_code
453: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
454: AND NOT EXISTS (SELECT 1
455: FROM BOM_OPERATION_RESOURCES oper_res,
456: bom_operation_sequences oper,
457: bom_operational_routings rtg,
458: mtl_parameters org,
459: mtl_system_items_kfv item
460: WHERE oper.operation_sequence_id = oper_res.operation_sequence_id

Line 520: bom_operation_sequences oper,

516: AND tmp.OrganizationCode = P_organization_code
517: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
518: AND EXISTS (SELECT 1
519: FROM BOM_OPERATION_RESOURCES oper_res,
520: bom_operation_sequences oper,
521: bom_operational_routings rtg,
522: mtl_parameters org,
523: mtl_system_items_kfv item
524: WHERE oper.operation_sequence_id = oper_res.operation_sequence_id

Line 594: BOM_OPERATION_SEQUENCES oper,

590: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
591: AND EXISTS (SELECT 1
592: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
593: bom_operational_routings rtg,
594: BOM_OPERATION_SEQUENCES oper,
595: mtl_parameters org,
596: mtl_system_items_kfv item
597: WHERE oper.operation_sequence_id = sub_oper.operation_sequence_id
598: AND rtg.routing_sequence_id = oper.routing_sequence_id

Line 665: BOM_OPERATION_SEQUENCES oper,

661: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
662: AND NOT EXISTS (SELECT 1
663: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
664: bom_operational_routings rtg,
665: BOM_OPERATION_SEQUENCES oper,
666: mtl_parameters org,
667: mtl_system_items_kfv item
668: WHERE oper.operation_sequence_id = sub_oper.operation_sequence_id
669: AND rtg.routing_sequence_id = oper.routing_sequence_id

Line 734: bom_operation_sequences oper1,

730: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
731: AND NOT EXISTS (SELECT 1
732: FROM bom_operation_networks op_network,
733: bom_operational_routings rtg,
734: bom_operation_sequences oper1,
735: bom_operation_sequences oper2,
736: mtl_parameters org,
737: mtl_system_items_kfv item
738: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id

Line 735: bom_operation_sequences oper2,

731: AND NOT EXISTS (SELECT 1
732: FROM bom_operation_networks op_network,
733: bom_operational_routings rtg,
734: bom_operation_sequences oper1,
735: bom_operation_sequences oper2,
736: mtl_parameters org,
737: mtl_system_items_kfv item
738: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id
739: AND op_network.to_op_seq_id = oper2.operation_sequence_id

Line 800: bom_operation_sequences oper1,

796: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
797: AND EXISTS (SELECT 1
798: FROM bom_operation_networks op_network,
799: bom_operational_routings rtg,
800: bom_operation_sequences oper1,
801: bom_operation_sequences oper2,
802: mtl_parameters org,
803: mtl_system_items_kfv item
804: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id

Line 801: bom_operation_sequences oper2,

797: AND EXISTS (SELECT 1
798: FROM bom_operation_networks op_network,
799: bom_operational_routings rtg,
800: bom_operation_sequences oper1,
801: bom_operation_sequences oper2,
802: mtl_parameters org,
803: mtl_system_items_kfv item
804: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id
805: AND op_network.to_op_seq_id = oper2.operation_sequence_id