APPS.PO_UOM_SV2 dependencies on MTL_UNITS_OF_MEASURE

Line 45: FROM mtl_units_of_measure

41: progress := '005';
42:
43: SELECT uom_code
44: INTO primary_code
45: FROM mtl_units_of_measure
46: WHERE unit_of_measure = x_primary_uom;
47:
48: progress := '006';
49:

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,

Line 178: mtl_units_of_measure uoms,

174: msi.unit_of_issue,
175: msi.rounding_factor
176: from po_requisitions_interface pri,
177: mtl_system_items msi,
178: mtl_units_of_measure uoms,
179: mtl_units_of_measure uomd
180: where msi.inventory_item_id = pri.item_id
181: AND msi.organization_id = pri.source_organization_id
182: AND uoms.unit_of_measure = msi.unit_of_issue

Line 179: mtl_units_of_measure uomd

175: msi.rounding_factor
176: from po_requisitions_interface pri,
177: mtl_system_items msi,
178: mtl_units_of_measure uoms,
179: mtl_units_of_measure uomd
180: where msi.inventory_item_id = pri.item_id
181: AND msi.organization_id = pri.source_organization_id
182: AND uoms.unit_of_measure = msi.unit_of_issue
183: AND uomd.unit_of_measure = pri.unit_of_measure