DBA Data[Home] [Help]

APPS.GMF_MTL_GET_UOM dependencies on SY_UOMS_MST

Line 7: /** add sy_uoms_mst in the from clause **/

3: /** MC BUG# 1554483 **/
4: /* don't select unit_of_measure in select since because of uom changes
5: uomname is now um_code and selecting in the select would change um_code
6: to unit_of_measure which is wrong**/
7: /** add sy_uoms_mst in the from clause **/
8: PROCEDURE MTL_GET_UOM (
9: uomcode in out nocopy varchar2,
10: uomname in out nocopy varchar2,
11: descr out nocopy varchar2,

Line 21: from sy_uoms_mst a, mtl_units_of_measure b

17: into
18: --uomname,
19: uomcode,
20: descr
21: from sy_uoms_mst a, mtl_units_of_measure b
22: where a.um_code = uomname
23: and a.unit_of_measure = b.unit_of_measure;
24: EXCEPTION
25: when no_data_found then