APPS.MST_AUDIT_REP_EXCP dependencies on MTL_UOM_CONVERSIONS

Line 1816: FROM mtl_uom_conversions muc1,

1812:
1813: IF (l_uom_class = l_dest_uom_class) THEN
1814: BEGIN
1815: SELECT muc1.conversion_rate/muc2.conversion_rate INTO p_conv_rate
1816: FROM mtl_uom_conversions muc1,
1817: mtl_uom_conversions muc2
1818: WHERE muc1.inventory_item_id = 0
1819: AND muc2.inventory_item_id = 0
1820: AND muc1.uom_class = muc2.uom_class

Line 1817: mtl_uom_conversions muc2

1813: IF (l_uom_class = l_dest_uom_class) THEN
1814: BEGIN
1815: SELECT muc1.conversion_rate/muc2.conversion_rate INTO p_conv_rate
1816: FROM mtl_uom_conversions muc1,
1817: mtl_uom_conversions muc2
1818: WHERE muc1.inventory_item_id = 0
1819: AND muc2.inventory_item_id = 0
1820: AND muc1.uom_class = muc2.uom_class
1821: AND muc1.uom_class = l_uom_class

Line 1835: FROM mtl_uom_conversions_view muc

1831:
1832: ELSE
1833: BEGIN
1834: SELECT muc.conversion_rate INTO p_conv_rate
1835: FROM mtl_uom_conversions_view muc
1836: WHERE muc.inventory_item_id = p_inventory_item_id
1837: AND muc.primary_uom_code = p_uom_code
1838: AND muc.uom_code = p_dest_uom_code
1839: AND rownum = 1;

Line 1845: FROM mtl_uom_conversions_view muc

1841: EXCEPTION when NO_DATA_FOUND then
1842: --The following alternative was taken from Anuj's snapshot file (jansanch)
1843: BEGIN
1844: SELECT muc.conversion_rate INTO p_conv_rate
1845: FROM mtl_uom_conversions_view muc
1846: WHERE muc.inventory_item_id = p_inventory_item_id
1847: AND muc.primary_uom_code = p_dest_uom_code
1848: AND muc.uom_code = p_uom_code
1849: AND rownum = 1;