DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_API_PKG dependencies on MTL_UOM_CONVERSIONS

Line 1498: mtl_uom_conversions muc

1494: --Getting conversion rate for KG with respect base unit of measure
1495: SELECT muc.conversion_rate
1496: INTO v_conv_rate
1497: FROM mtl_units_of_measure_tl mum1,
1498: mtl_uom_conversions muc
1499: WHERE mum1.uom_code = v_uom
1500: AND muc.unit_of_measure = mum1.unit_of_measure AND mum1.language=USERENV('LANG') AND muc.INVENTORY_ITEM_ID=0;
1501:
1502: --Getting conversion rate for User defined UOM with respect to base unit of measure

Line 1506: mtl_uom_conversions muc

1502: --Getting conversion rate for User defined UOM with respect to base unit of measure
1503: SELECT muc.conversion_rate
1504: INTO v_emission_conv_rate
1505: FROM mtl_units_of_measure_tl mum1,
1506: mtl_uom_conversions muc
1507: WHERE mum1.uom_code = v_emission_uom
1508: AND muc.unit_of_measure = mum1.unit_of_measure and mum1.language=USERENV('LANG') AND muc.INVENTORY_ITEM_ID=0;
1509: -- Final rate of conversion
1510: v_final_conv_rate := (v_conv_rate/v_emission_conv_rate);