DBA Data[Home] [Help]

APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on MTL_UOM_CONVERSIONS

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

1684: l_asset_failure_tbl(i).include_for_reading_aggr := 'Y';
1685:
1686: select nvl(MUC1.CONVERSION_RATE,0) , nvl(MUC2.CONVERSION_RATE,0), MUOFVL.UOM_CODE
1687: into l_uom1_conv_rate, l_uom2_conv_rate, l_primary_uom
1688: from MTL_UOM_CONVERSIONS MUC1, MTL_UOM_CONVERSIONS MUC2, MTL_UNITS_OF_MEASURE_VL MUOFVL
1689: where MUC1.UOM_CODE = l_meter_uom1
1690: and MUC2.UOM_CODE = l_meter_uom2
1691: AND NVL(MUC1.DISABLE_DATE, SYSDATE + 1) > SYSDATE
1692: AND NVL(MUC2.DISABLE_DATE, SYSDATE + 1) > SYSDATE