DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on MTL_ITEM_UOMS_VIEW

Line 1324: mtl_item_uoms_view mv1,

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

Line 1325: mtl_item_uoms_view mv2

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