DBA Data[Home] [Help]

APPS.PO_UOM_SV2 dependencies on MTL_UNITS_OF_MEASURE_VL

Line 52: In the SELECT statement, changed mtl_units_of_measure to mtl_units_of_measure_vl

48: progress := '006';
49:
50: /*
51: Bug 2810994
52: In the SELECT statement, changed mtl_units_of_measure to mtl_units_of_measure_vl
53: and unit_of_measure to unit_of_measure_tl to handle translated values
54: */
55: /* 4718263 changed where condtion of the below SQL: in place of unit_of_measure_tl unit_of_measure should be used.
56: from the Form we always pass unit_of_measure value not the translated value. */

Line 59: FROM mtl_units_of_measure_vl

55: /* 4718263 changed where condtion of the below SQL: in place of unit_of_measure_tl unit_of_measure should be used.
56: from the Form we always pass unit_of_measure value not the translated value. */
57: SELECT uom_code
58: INTO current_code
59: FROM mtl_units_of_measure_vl
60: WHERE unit_of_measure = x_current_uom;
61:
62: progress := '010';
63: inv_convert.inv_um_conversion(primary_code,