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 MTL_PARAMETERS

Line 114: mtl_parameters org,

110: , NULL DG_Description
111: , NULL ser_start_op_seq
112: , NULL row_identifier
113: FROM bom_routing_header_temp tmp,
114: mtl_parameters org,
115: mtl_system_items_kfv item
116: WHERE org.organization_code = tmp.OrganizationCode
117: AND item.organization_id = org.organization_id
118: AND item.concatenated_segments = tmp.AssemblyItemName

Line 163: mtl_parameters org,

159: , NULL DG_Description
160: , NULL ser_start_op_seq
161: , NULL row_identifier
162: FROM bom_routing_header_temp tmp,
163: mtl_parameters org,
164: mtl_system_items_kfv item
165: WHERE org.organization_code = tmp.OrganizationCode
166: AND item.organization_id = org.organization_id
167: AND item.concatenated_segments = tmp.AssemblyItemName

Line 202: mtl_parameters org,

198: , 'CREATE' transaction_type
199: , NULL return_status
200: , NULL row_identifier
201: FROM bom_rtg_revisions_temp tmp,
202: mtl_parameters org,
203: mtl_system_items_kfv item
204: WHERE org.organization_code = tmp.OrganizationCode
205: AND item.organization_id = org.organization_id
206: AND item.concatenated_segments = tmp.AssemblyItemName

Line 241: mtl_parameters org,

237: , 'UPDATE' transaction_type
238: , NULL return_status
239: , NULL row_identifier
240: FROM bom_rtg_revisions_temp tmp,
241: mtl_parameters org,
242: mtl_system_items_kfv item
243: WHERE org.organization_code = tmp.OrganizationCode
244: AND item.organization_id = org.organization_id
245: AND item.concatenated_segments = tmp.AssemblyItemName

Line 318: mtl_parameters org,

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
322: AND item.organization_id = rtg.organization_id

Line 393: mtl_parameters org,

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
397: AND item.organization_id = rtg.organization_id

Line 458: mtl_parameters org,

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

Line 522: mtl_parameters org,

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

Line 595: mtl_parameters org,

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

Line 666: mtl_parameters org,

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

Line 736: mtl_parameters org,

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

Line 802: mtl_parameters org,

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