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_PARAMETERS

Line 113: mtl_parameters org

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

Line 156: mtl_parameters org

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

Line 233: mtl_parameters org

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
237: AND org.organization_id = bom.organization_id

Line 314: mtl_parameters org

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
318: AND org.organization_id = bom.organization_id

Line 366: mtl_parameters org,

362: WHERE EXISTS (SELECT 1
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

Line 425: mtl_parameters org,

421: WHERE NOT EXISTS (SELECT 1
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

Line 482: mtl_parameters org,

478: WHERE NOT EXISTS (SELECT 1
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

Line 535: mtl_parameters org,

531: WHERE EXISTS (SELECT 1
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

Line 589: mtl_parameters org,

585: WHERE NOT EXISTS (SELECT 1
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

Line 641: mtl_parameters org,

637: WHERE EXISTS (SELECT 1
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

Line 689: mtl_parameters org,

685: tmp.Attribute15 ,
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

Line 728: mtl_parameters org,

724: tmp.Attribute15 ,
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