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_OPERATIONAL_ROUTINGS

Line 120: FROM bom_operational_routings rtg

116: WHERE org.organization_code = tmp.OrganizationCode
117: AND item.organization_id = org.organization_id
118: AND item.concatenated_segments = tmp.AssemblyItemName
119: AND NOT EXISTS (SELECT 1
120: FROM bom_operational_routings rtg
121: WHERE rtg.assembly_item_id = item.inventory_item_id
122: AND rtg.organization_id = item.organization_id
123: AND NVL(rtg.alternate_routing_designator,'$$##$$') = NVL(tmp.AlternateRoutingCode,'$$##$$'))
124: UNION ALL

Line 169: FROM bom_operational_routings rtg

165: WHERE org.organization_code = tmp.OrganizationCode
166: AND item.organization_id = org.organization_id
167: AND item.concatenated_segments = tmp.AssemblyItemName
168: AND EXISTS (SELECT 1
169: FROM bom_operational_routings rtg
170: WHERE rtg.assembly_item_id = item.inventory_item_id
171: AND rtg.organization_id = item.organization_id
172: AND NVL(rtg.alternate_routing_designator,'$$##$$') = NVL(tmp.AlternateRoutingCode,'$$##$$'));
173:

Line 317: bom_operational_routings rtg,

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
321: AND item.inventory_item_id = rtg.assembly_item_id

Line 392: bom_operational_routings rtg,

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
396: AND item.inventory_item_id = rtg.assembly_item_id

Line 459: bom_operational_routings rtg,

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
463: AND rtg.routing_sequence_id = oper.routing_sequence_id

Line 525: bom_operational_routings rtg,

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
529: AND rtg.routing_sequence_id = oper.routing_sequence_id

Line 598: bom_operational_routings rtg,

594: AND tmp.OrganizationCode = P_organization_code
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

Line 670: bom_operational_routings rtg,

666: AND tmp.OrganizationCode = P_organization_code
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

Line 739: bom_operational_routings rtg,

735: AND tmp.OrganizationCode = P_organization_code
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

Line 805: bom_operational_routings rtg,

801: AND tmp.OrganizationCode = P_organization_code
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