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_SYSTEM_ITEMS_KFV

Line 115: mtl_system_items_kfv item

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
119: AND NOT EXISTS (SELECT 1

Line 164: mtl_system_items_kfv item

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
168: AND EXISTS (SELECT 1

Line 203: mtl_system_items_kfv item

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
207: AND tmp.AssemblyItemName = P_assembly_item_name

Line 242: mtl_system_items_kfv item

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
246: AND tmp.AssemblyItemName = P_assembly_item_name

Line 319: mtl_system_items_kfv item

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
323: AND item.concatenated_segments = tmp.AssemblyItemName

Line 394: mtl_system_items_kfv item

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
398: AND item.concatenated_segments = tmp.AssemblyItemName

Line 459: mtl_system_items_kfv item

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

Line 523: mtl_system_items_kfv item

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

Line 596: mtl_system_items_kfv item

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

Line 667: mtl_system_items_kfv item

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

Line 737: mtl_system_items_kfv item

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

Line 803: mtl_system_items_kfv item

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