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 461: mtl_system_items_kfv item

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

Line 527: mtl_system_items_kfv item

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

Line 601: mtl_system_items_kfv item

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

Line 673: mtl_system_items_kfv item

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

Line 743: mtl_system_items_kfv item

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

Line 809: mtl_system_items_kfv item

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