APPS.GMI_MSCA_PUB dependencies on SY_UOMS_MST

Line 21: v_um_code SY_UOMS_MST.UM_CODE%TYPE;

17: END print_debug;
18:
19:
20: FUNCTION get_opm_uom_code(x_apps_unit_meas_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
21: v_um_code SY_UOMS_MST.UM_CODE%TYPE;
22: BEGIN
23:
24: Select um_code
25: Into v_um_code

Line 26: From sy_uoms_mst

22: BEGIN
23:
24: Select um_code
25: Into v_um_code
26: From sy_uoms_mst
27: Where unit_of_measure = x_apps_unit_meas_lookup_code;
28:
29: RETURN(v_um_code);
30:

Line 309: FROM sy_uoms_mst u

305:
306: print_debug('in uom_lov item_no='||p_item_no||'...');
307: OPEN x_uom_cursor FOR
308: SELECT u.uom_code
309: FROM sy_uoms_mst u
310: , ic_item_cnv i
311: WHERE i.um_type = u.um_type
312: AND u.uom_code like p_uom
313: AND i.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)