DBA Data[Home] [Help]

APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 1704: from MTL_UOM_CONVERSIONS MUC1, MTL_UOM_CONVERSIONS MUC2, MTL_UNITS_OF_MEASURE_VL MUOFVL

1700: l_asset_failure_tbl(i).include_for_reading_aggr := 'Y';
1701:
1702: select nvl(MUC1.CONVERSION_RATE,0) , nvl(MUC2.CONVERSION_RATE,0), MUOFVL.UOM_CODE
1703: into l_uom1_conv_rate, l_uom2_conv_rate, l_primary_uom
1704: from MTL_UOM_CONVERSIONS MUC1, MTL_UOM_CONVERSIONS MUC2, MTL_UNITS_OF_MEASURE_VL MUOFVL
1705: where MUC1.UOM_CODE = l_meter_uom1
1706: and MUC2.UOM_CODE = l_meter_uom2
1707: AND NVL(MUC1.DISABLE_DATE, SYSDATE + 1) > SYSDATE
1708: AND NVL(MUC2.DISABLE_DATE, SYSDATE + 1) > SYSDATE