APPS.INV_OPM_ITEM_MIGRATION dependencies on SY_UOMS_TYP

Line 102: l_um_type sy_uoms_typ.um_type%TYPE;

98: ) IS
99:
100: /* ------------- LOCAL VARIABLES ------------------- */
101: l_description VARCHAR2(240);
102: l_um_type sy_uoms_typ.um_type%TYPE;
103: l_uom sy_uoms_typ.std_um%TYPE;
104:
105: /* ------------------ CURSORS ---------------------- */
106: /* Cursor used to retrieve the Regulatory item info*/

Line 103: l_uom sy_uoms_typ.std_um%TYPE;

99:
100: /* ------------- LOCAL VARIABLES ------------------- */
101: l_description VARCHAR2(240);
102: l_um_type sy_uoms_typ.um_type%TYPE;
103: l_uom sy_uoms_typ.std_um%TYPE;
104:
105: /* ------------------ CURSORS ---------------------- */
106: /* Cursor used to retrieve the Regulatory item info*/
107: CURSOR c_get_reg_item IS

Line 132: FROM sy_uoms_typ

128:
129: /* Cursor used to retrieve the std uom for FM_YIELD_TYPE class */
130: CURSOR c_get_uom (v_um_type VARCHAR2) IS
131: SELECT std_um
132: FROM sy_uoms_typ
133: WHERE um_type = v_um_type;
134:
135: /* ----------------- EXCEPTIONS -------------------- */
136: INVALID_ITEM EXCEPTION;