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 230: mtl_system_items_kfv item1,

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

Line 231: mtl_system_items_kfv item2,

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

Line 311: mtl_system_items_kfv item1,

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

Line 312: mtl_system_items_kfv item2,

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

Line 366: mtl_system_items_kfv item1,

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

Line 367: mtl_system_items_kfv item2,

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

Line 368: mtl_system_items_kfv item3

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

Line 425: mtl_system_items_kfv item1,

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

Line 426: mtl_system_items_kfv item2,

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

Line 427: mtl_system_items_kfv item3

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

Line 482: mtl_system_items_kfv item1,

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

Line 483: mtl_system_items_kfv item2

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

Line 535: mtl_system_items_kfv item1,

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

Line 536: mtl_system_items_kfv item2

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

Line 589: mtl_system_items_kfv item1,

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

Line 590: mtl_system_items_kfv item2

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

Line 641: mtl_system_items_kfv item1,

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

Line 642: mtl_system_items_kfv item2

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

Line 689: mtl_system_items_kfv item

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

Line 728: mtl_system_items_kfv item

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