APPS.PO_GML_DB_COMMON dependencies on MTL_UNITS_OF_MEASURE

Line 71: from mtl_units_of_measure uom

67: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
68: 2, uom.unit_of_measure, 3, uom.unit_of_measure,
69: 4, uom.unit_of_measure, uom.uom_code) um_code
70: into v_um_code
71: from mtl_units_of_measure uom
72: WHERE unit_of_measure = x_apps_unit_meas_lookup_code;
73:
74: */
75: /* Bug #3514053 */

Line 108: v_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE;

104: #
105: ## #######################################################################*/
106: FUNCTION get_apps_uom_code(x_opm_um_code IN VARCHAR2) RETURN VARCHAR2 IS
107: v_progress VARCHAR2(3) := '010';
108: v_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE;
109: v_delete_mark NUMBER;
110: uom_deleted EXCEPTION ;
111: BEGIN
112: /*

Line 115: FROM mtl_units_of_measure uom

111: BEGIN
112: /*
113: SELECT uom.unit_of_measure,decode(sign(sysdate-uom.disable_date),1,1,0)
114: INTO v_unit_of_measure,v_delete_mark
115: FROM mtl_units_of_measure uom
116: WHERE decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
117: 2, uom.unit_of_measure, 3, uom.unit_of_measure,
118: 4, uom.unit_of_measure, uom.uom_code) = x_opm_um_code;
119: