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_BOM_ISETUP_IMP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 112: mtl_system_items_kfv item,

108: NULL DeleteGroupName ,
109: NULL DGDescription ,
110: NULL RowIdentifier
111: FROM bom_bill_of_materials_temp tmp,
112: mtl_system_items_kfv item,
113: mtl_parameters org
114: WHERE org.organization_code = tmp.OrganizationCode
115: AND item.concatenated_segments = tmp.AssemblyItemName
116: AND item.organization_id = org.organization_id

Line 155: mtl_system_items_kfv item,

151: NULL DeleteGroupName ,
152: NULL DGDescription ,
153: NULL RowIdentifier
154: FROM bom_bill_of_materials_temp tmp,
155: mtl_system_items_kfv item,
156: mtl_parameters org
157: WHERE org.organization_code = tmp.OrganizationCode
158: AND item.concatenated_segments = tmp.AssemblyItemName
159: AND item.organization_id = org.organization_id

Line 231: mtl_system_items_kfv item1,

227: FROM bom_inventory_components_temp tmp
228: WHERE EXISTS (SELECT 1
229: FROM bom_inventory_components comp,
230: bom_bill_of_materials bom,
231: mtl_system_items_kfv item1,
232: mtl_system_items_kfv item2,
233: mtl_parameters org
234: WHERE bom.bill_sequence_id = comp.bill_sequence_id
235: AND item1.inventory_item_id = bom.assembly_item_id

Line 232: mtl_system_items_kfv item2,

228: WHERE EXISTS (SELECT 1
229: FROM bom_inventory_components comp,
230: bom_bill_of_materials bom,
231: mtl_system_items_kfv item1,
232: mtl_system_items_kfv item2,
233: mtl_parameters org
234: WHERE bom.bill_sequence_id = comp.bill_sequence_id
235: AND item1.inventory_item_id = bom.assembly_item_id
236: AND item1.organization_id = bom.organization_id

Line 312: mtl_system_items_kfv item1,

308: WHERE NOT EXISTS
309: (SELECT 1
310: FROM bom_inventory_components comp,
311: bom_bill_of_materials bom,
312: mtl_system_items_kfv item1,
313: mtl_system_items_kfv item2,
314: mtl_parameters org
315: WHERE bom.bill_sequence_id = comp.bill_sequence_id
316: AND item1.inventory_item_id = bom.assembly_item_id

Line 313: mtl_system_items_kfv item2,

309: (SELECT 1
310: FROM bom_inventory_components comp,
311: bom_bill_of_materials bom,
312: mtl_system_items_kfv item1,
313: mtl_system_items_kfv item2,
314: mtl_parameters org
315: WHERE bom.bill_sequence_id = comp.bill_sequence_id
316: AND item1.inventory_item_id = bom.assembly_item_id
317: AND item1.organization_id = bom.organization_id

Line 367: mtl_system_items_kfv item1,

363: FROM bom_substitute_components sub,
364: bom_inventory_components comp,
365: bom_bill_of_materials bom,
366: mtl_parameters org,
367: mtl_system_items_kfv item1,
368: mtl_system_items_kfv item2,
369: mtl_system_items_kfv item3
370: WHERE comp.component_sequence_id = sub.component_sequence_id
371: AND bom.bill_sequence_id = comp.bill_sequence_id

Line 368: mtl_system_items_kfv item2,

364: bom_inventory_components comp,
365: bom_bill_of_materials bom,
366: mtl_parameters org,
367: mtl_system_items_kfv item1,
368: mtl_system_items_kfv item2,
369: mtl_system_items_kfv item3
370: WHERE comp.component_sequence_id = sub.component_sequence_id
371: AND bom.bill_sequence_id = comp.bill_sequence_id
372: AND item1.inventory_item_id = bom.assembly_item_id

Line 369: mtl_system_items_kfv item3

365: bom_bill_of_materials bom,
366: mtl_parameters org,
367: mtl_system_items_kfv item1,
368: mtl_system_items_kfv item2,
369: mtl_system_items_kfv item3
370: WHERE comp.component_sequence_id = sub.component_sequence_id
371: AND bom.bill_sequence_id = comp.bill_sequence_id
372: AND item1.inventory_item_id = bom.assembly_item_id
373: AND item1.organization_id = bom.organization_id

Line 426: mtl_system_items_kfv item1,

422: FROM bom_substitute_components sub,
423: bom_inventory_components comp,
424: bom_bill_of_materials bom,
425: mtl_parameters org,
426: mtl_system_items_kfv item1,
427: mtl_system_items_kfv item2,
428: mtl_system_items_kfv item3
429: WHERE comp.component_sequence_id = sub.component_sequence_id
430: AND bom.bill_sequence_id = comp.bill_sequence_id

Line 427: mtl_system_items_kfv item2,

423: bom_inventory_components comp,
424: bom_bill_of_materials bom,
425: mtl_parameters org,
426: mtl_system_items_kfv item1,
427: mtl_system_items_kfv item2,
428: mtl_system_items_kfv item3
429: WHERE comp.component_sequence_id = sub.component_sequence_id
430: AND bom.bill_sequence_id = comp.bill_sequence_id
431: AND item1.inventory_item_id = bom.assembly_item_id

Line 428: mtl_system_items_kfv item3

424: bom_bill_of_materials bom,
425: mtl_parameters org,
426: mtl_system_items_kfv item1,
427: mtl_system_items_kfv item2,
428: mtl_system_items_kfv item3
429: WHERE comp.component_sequence_id = sub.component_sequence_id
430: AND bom.bill_sequence_id = comp.bill_sequence_id
431: AND item1.inventory_item_id = bom.assembly_item_id
432: AND item1.organization_id = bom.organization_id

Line 483: mtl_system_items_kfv item1,

479: FROM bom_reference_designators ref,
480: bom_inventory_components comp,
481: bom_bill_of_materials bom,
482: mtl_parameters org,
483: mtl_system_items_kfv item1,
484: mtl_system_items_kfv item2
485: WHERE comp.component_sequence_id = ref.component_sequence_id
486: AND bom.bill_sequence_id = comp.bill_sequence_id
487: AND item1.inventory_item_id = bom.assembly_item_id

Line 484: mtl_system_items_kfv item2

480: bom_inventory_components comp,
481: bom_bill_of_materials bom,
482: mtl_parameters org,
483: mtl_system_items_kfv item1,
484: mtl_system_items_kfv item2
485: WHERE comp.component_sequence_id = ref.component_sequence_id
486: AND bom.bill_sequence_id = comp.bill_sequence_id
487: AND item1.inventory_item_id = bom.assembly_item_id
488: AND item1.organization_id = bom.organization_id

Line 536: mtl_system_items_kfv item1,

532: FROM bom_reference_designators ref,
533: bom_inventory_components comp,
534: bom_bill_of_materials bom,
535: mtl_parameters org,
536: mtl_system_items_kfv item1,
537: mtl_system_items_kfv item2
538: WHERE comp.component_sequence_id = ref.component_sequence_id
539: AND bom.bill_sequence_id = comp.bill_sequence_id
540: AND item1.inventory_item_id = bom.assembly_item_id

Line 537: mtl_system_items_kfv item2

533: bom_inventory_components comp,
534: bom_bill_of_materials bom,
535: mtl_parameters org,
536: mtl_system_items_kfv item1,
537: mtl_system_items_kfv item2
538: WHERE comp.component_sequence_id = ref.component_sequence_id
539: AND bom.bill_sequence_id = comp.bill_sequence_id
540: AND item1.inventory_item_id = bom.assembly_item_id
541: AND item1.organization_id = bom.organization_id

Line 590: mtl_system_items_kfv item1,

586: FROM bom_component_operations comp_oper,
587: bom_inventory_components comp,
588: bom_bill_of_materials bom,
589: mtl_parameters org,
590: mtl_system_items_kfv item1,
591: mtl_system_items_kfv item2
592: WHERE comp.component_sequence_id = comp_oper.component_sequence_id
593: AND bom.bill_sequence_id = comp.bill_sequence_id
594: AND item1.inventory_item_id = bom.assembly_item_id

Line 591: mtl_system_items_kfv item2

587: bom_inventory_components comp,
588: bom_bill_of_materials bom,
589: mtl_parameters org,
590: mtl_system_items_kfv item1,
591: mtl_system_items_kfv item2
592: WHERE comp.component_sequence_id = comp_oper.component_sequence_id
593: AND bom.bill_sequence_id = comp.bill_sequence_id
594: AND item1.inventory_item_id = bom.assembly_item_id
595: AND item1.organization_id = bom.organization_id

Line 642: mtl_system_items_kfv item1,

638: FROM bom_component_operations comp_oper,
639: bom_inventory_components comp,
640: bom_bill_of_materials bom,
641: mtl_parameters org,
642: mtl_system_items_kfv item1,
643: mtl_system_items_kfv item2
644: WHERE comp.component_sequence_id = comp_oper.component_sequence_id
645: AND bom.bill_sequence_id = comp.bill_sequence_id
646: AND item1.inventory_item_id = bom.assembly_item_id

Line 643: mtl_system_items_kfv item2

639: bom_inventory_components comp,
640: bom_bill_of_materials bom,
641: mtl_parameters org,
642: mtl_system_items_kfv item1,
643: mtl_system_items_kfv item2
644: WHERE comp.component_sequence_id = comp_oper.component_sequence_id
645: AND bom.bill_sequence_id = comp.bill_sequence_id
646: AND item1.inventory_item_id = bom.assembly_item_id
647: AND item1.organization_id = bom.organization_id

Line 690: mtl_system_items_kfv item

686: tmp.OriginalSystemReference,
687: NULL RowIdentifier
688: FROM bom_revisions_temp tmp,
689: mtl_parameters org,
690: mtl_system_items_kfv item
691: WHERE org.organization_code = tmp.OrganizationCode
692: AND item.concatenated_segments = tmp.AssemblyItemName
693: AND item.organization_id = org.organization_id
694: AND tmp.revision <> org.starting_revision

Line 729: mtl_system_items_kfv item

725: tmp.OriginalSystemReference,
726: NULL RowIdentifier
727: FROM bom_revisions_temp tmp,
728: mtl_parameters org,
729: mtl_system_items_kfv item
730: WHERE org.organization_code = tmp.OrganizationCode
731: AND item.concatenated_segments = tmp.AssemblyItemName
732: AND item.organization_id = org.organization_id
733: AND tmp.revision <> org.starting_revision