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 457: bom_operational_routings rtg,

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

Line 521: bom_operational_routings rtg,

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

Line 593: bom_operational_routings rtg,

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

Line 664: bom_operational_routings rtg,

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

Line 733: bom_operational_routings rtg,

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

Line 799: bom_operational_routings rtg,

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