DBA Data[Home] [Help]

APPS.MST_AUDIT_REP_EXCP dependencies on MTL_UOM_CONVERSIONS_VIEW

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;