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 458: bom_operation_sequences oper,

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

Line 524: bom_operation_sequences oper,

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

Line 599: BOM_OPERATION_SEQUENCES oper,

595: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
596: AND EXISTS (SELECT 1
597: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
598: bom_operational_routings rtg,
599: BOM_OPERATION_SEQUENCES oper,
600: mtl_parameters org,
601: mtl_system_items_kfv item
602: WHERE oper.operation_sequence_id = sub_oper.operation_sequence_id
603: AND rtg.routing_sequence_id = oper.routing_sequence_id

Line 671: BOM_OPERATION_SEQUENCES oper,

667: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
668: AND NOT EXISTS (SELECT 1
669: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
670: bom_operational_routings rtg,
671: BOM_OPERATION_SEQUENCES oper,
672: mtl_parameters org,
673: mtl_system_items_kfv item
674: WHERE oper.operation_sequence_id = sub_oper.operation_sequence_id
675: AND rtg.routing_sequence_id = oper.routing_sequence_id

Line 740: bom_operation_sequences oper1,

736: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
737: AND NOT EXISTS (SELECT 1
738: FROM bom_operation_networks op_network,
739: bom_operational_routings rtg,
740: bom_operation_sequences oper1,
741: bom_operation_sequences oper2,
742: mtl_parameters org,
743: mtl_system_items_kfv item
744: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id

Line 741: bom_operation_sequences oper2,

737: AND NOT EXISTS (SELECT 1
738: FROM bom_operation_networks op_network,
739: bom_operational_routings rtg,
740: bom_operation_sequences oper1,
741: bom_operation_sequences oper2,
742: mtl_parameters org,
743: mtl_system_items_kfv item
744: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id
745: AND op_network.to_op_seq_id = oper2.operation_sequence_id

Line 806: bom_operation_sequences oper1,

802: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
803: AND EXISTS (SELECT 1
804: FROM bom_operation_networks op_network,
805: bom_operational_routings rtg,
806: bom_operation_sequences oper1,
807: bom_operation_sequences oper2,
808: mtl_parameters org,
809: mtl_system_items_kfv item
810: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id

Line 807: bom_operation_sequences oper2,

803: AND EXISTS (SELECT 1
804: FROM bom_operation_networks op_network,
805: bom_operational_routings rtg,
806: bom_operation_sequences oper1,
807: bom_operation_sequences oper2,
808: mtl_parameters org,
809: mtl_system_items_kfv item
810: WHERE op_network.from_op_seq_id = oper1.operation_sequence_id
811: AND op_network.to_op_seq_id = oper2.operation_sequence_id