APPS.INV_OPM_ITEM_MIGRATION dependencies on SY_UOMS_TYP

Line 87: l_um_type sy_uoms_typ.um_type%TYPE;

83: ) IS
84:
85: /* ------------- LOCAL VARIABLES ------------------- */
86: l_description VARCHAR2(240);
87: l_um_type sy_uoms_typ.um_type%TYPE;
88: l_uom sy_uoms_typ.std_um%TYPE;
89:
90: /* ------------------ CURSORS ---------------------- */
91: /* Cursor used to retrieve the Regulatory item info*/

Line 88: l_uom sy_uoms_typ.std_um%TYPE;

84:
85: /* ------------- LOCAL VARIABLES ------------------- */
86: l_description VARCHAR2(240);
87: l_um_type sy_uoms_typ.um_type%TYPE;
88: l_uom sy_uoms_typ.std_um%TYPE;
89:
90: /* ------------------ CURSORS ---------------------- */
91: /* Cursor used to retrieve the Regulatory item info*/
92: CURSOR c_get_reg_item IS

Line 117: FROM sy_uoms_typ

113:
114: /* Cursor used to retrieve the std uom for FM_YIELD_TYPE class */
115: CURSOR c_get_uom (v_um_type VARCHAR2) IS
116: SELECT std_um
117: FROM sy_uoms_typ
118: WHERE um_type = v_um_type;
119:
120: /* ----------------- EXCEPTIONS -------------------- */
121: INVALID_ITEM EXCEPTION;