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_EXPLODER_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 1868: --, mtl_units_of_measure mum

1864: INTO primary_uom_code_tbl(i)
1865: , eng_item_flag_tbl(i)
1866: , primary_uom_desc_tbl(i)
1867: FROM mtl_system_items_b msi
1868: --, mtl_units_of_measure mum
1869: , mtl_units_of_measure_tl mum
1870: WHERE msi.inventory_item_id = component_item_id_tbl(i)
1871: AND msi.organization_id = nvl(common_organization_id_tbl(i),
1872: organization_id_tbl(i))

Line 1869: , mtl_units_of_measure_tl mum

1865: , eng_item_flag_tbl(i)
1866: , primary_uom_desc_tbl(i)
1867: FROM mtl_system_items_b msi
1868: --, mtl_units_of_measure mum
1869: , mtl_units_of_measure_tl mum
1870: WHERE msi.inventory_item_id = component_item_id_tbl(i)
1871: AND msi.organization_id = nvl(common_organization_id_tbl(i),
1872: organization_id_tbl(i))
1873: AND msi.primary_uom_code = mum.uom_code

Line 2285: , mtl_units_of_measure_tl mum

2281: (SELECT msi.primary_uom_code
2282: , msi.eng_item_flag
2283: , mum.unit_of_measure
2284: FROM mtl_system_items_b msi
2285: , mtl_units_of_measure_tl mum
2286: WHERE msi.inventory_item_id = bet.component_item_id
2287: AND msi.organization_id = bet.common_organization_id
2288: AND msi.primary_uom_code = mum.uom_code
2289: AND mum.language = userenv('LANG'))

Line 3698: msi.eng_item_flag, (select description from mtl_units_of_measure where uom_code = msi.primary_uom_code) FROM

3694: /*
3695: UPDATE BOM_EXPLOSIONS_ALL
3696: SET access_flag = l_access_flag,
3697: (bom_item_type, parent_bom_item_type, primary_uom_code, eng_item_flag, primary_unit_of_measure) = (SELECT msi.bom_item_type, msi.bom_item_type, msi.primary_uom_code,
3698: msi.eng_item_flag, (select description from mtl_units_of_measure where uom_code = msi.primary_uom_code) FROM
3699: mtl_system_items_b msi WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id)
3700: WHERE group_id = grp_id
3701: AND sort_order = '0000001';
3702: */

Line 3707: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom

3703:
3704: UPDATE BOM_EXPLOSIONS_ALL
3705: SET access_flag = l_access_flag,
3706: (bom_item_type, parent_bom_item_type, primary_uom_code, eng_item_flag, primary_unit_of_measure) = (SELECT msi.bom_item_type, msi.bom_item_type, msi.primary_uom_code,
3707: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom
3708: WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id AND muom.uom_code = msi.primary_uom_code)
3709: WHERE group_id = grp_id
3710: AND sort_order = '0000001';
3711: