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 1949: --, mtl_units_of_measure mum

1945: INTO primary_uom_code_tbl(i)
1946: , eng_item_flag_tbl(i)
1947: , primary_uom_desc_tbl(i)
1948: FROM mtl_system_items_b msi
1949: --, mtl_units_of_measure mum
1950: , mtl_units_of_measure_tl mum
1951: WHERE msi.inventory_item_id = component_item_id_tbl(i)
1952: AND msi.organization_id = nvl(common_organization_id_tbl(i),
1953: organization_id_tbl(i))

Line 1950: , mtl_units_of_measure_tl mum

1946: , eng_item_flag_tbl(i)
1947: , primary_uom_desc_tbl(i)
1948: FROM mtl_system_items_b msi
1949: --, mtl_units_of_measure mum
1950: , mtl_units_of_measure_tl mum
1951: WHERE msi.inventory_item_id = component_item_id_tbl(i)
1952: AND msi.organization_id = nvl(common_organization_id_tbl(i),
1953: organization_id_tbl(i))
1954: AND msi.primary_uom_code = mum.uom_code

Line 2366: , mtl_units_of_measure_tl mum

2362: (SELECT msi.primary_uom_code
2363: , msi.eng_item_flag
2364: , mum.unit_of_measure
2365: FROM mtl_system_items_b msi
2366: , mtl_units_of_measure_tl mum
2367: WHERE msi.inventory_item_id = bet.component_item_id
2368: AND msi.organization_id = bet.common_organization_id
2369: AND msi.primary_uom_code = mum.uom_code
2370: AND mum.language = userenv('LANG'))

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

3809: /*
3810: UPDATE BOM_EXPLOSIONS_ALL
3811: SET access_flag = l_access_flag,
3812: (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,
3813: msi.eng_item_flag, (select description from mtl_units_of_measure where uom_code = msi.primary_uom_code) FROM
3814: mtl_system_items_b msi WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id)
3815: WHERE group_id = grp_id
3816: AND sort_order = '0000001';
3817: */

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

3818:
3819: UPDATE BOM_EXPLOSIONS_ALL
3820: SET access_flag = l_access_flag,
3821: (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,
3822: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom
3823: WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id AND muom.uom_code = msi.primary_uom_code)
3824: WHERE group_id = grp_id
3825: AND sort_order = '0000001';
3826: