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 232: mtl_parameters org

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

Line 313: mtl_parameters org

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

Line 365: mtl_parameters org,

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

Line 424: mtl_parameters org,

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

Line 481: mtl_parameters org,

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

Line 534: mtl_parameters org,

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

Line 588: mtl_parameters org,

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

Line 640: mtl_parameters org,

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

Line 688: mtl_parameters org,

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

Line 727: mtl_parameters org,

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