1320:
1321: SELECT 'Y'
1322: INTO l_uom_in_same_class
1323: FROM mtl_system_items msi ,
1324: mtl_item_uoms_view mv1,
1325: mtl_item_uoms_view mv2
1326: WHERE msi.organization_id = p_organization_id
1327: AND msi.inventory_item_id = p_item_id
1328: AND msi.inventory_item_id = mv1.inventory_item_id
1321: SELECT 'Y'
1322: INTO l_uom_in_same_class
1323: FROM mtl_system_items msi ,
1324: mtl_item_uoms_view mv1,
1325: mtl_item_uoms_view mv2
1326: WHERE msi.organization_id = p_organization_id
1327: AND msi.inventory_item_id = p_item_id
1328: AND msi.inventory_item_id = mv1.inventory_item_id
1329: AND msi.organization_id = mv1.organization_id