APPS.GR_EXPLOSIONS dependencies on MTL_UNITS_OF_MEASURE_TL

Line 60: L_SYSTEM_UOM mtl_units_of_measure_tl.uom_code%TYPE;/*sy_uoms_typ.std_um%TYPE GK changes*/

56: L_KEY_EXISTS VARCHAR2(1);
57:
58: L_API_NAME CONSTANT VARCHAR2(30) := 'Explode MSDS/Prodn Formula';
59:
60: L_SYSTEM_UOM mtl_units_of_measure_tl.uom_code%TYPE;/*sy_uoms_typ.std_um%TYPE GK changes*/
61: L_SYSTEM_UOM_TYPE mtl_uom_classes_vl.uom_class%TYPE;/*sy_uoms_typ.um_type%TYPE;GK Changes*/
62: L_ITEM_CODE gr_item_general.item_code%TYPE;
63: L_ORGN_CODE sy_orgn_mst.orgn_code%TYPE;
64: --L_DEFAULT_ORGN sy_orgn_mst.orgn_code%TYPE;

Line 68: L_MASS_UOM mtl_units_of_measure_tl.uom_code%TYPE;/*sy_uoms_typ.std_um%TYPE;GK Changes*/

64: --L_DEFAULT_ORGN sy_orgn_mst.orgn_code%TYPE;
65: /*
66: ** M Thomas 05-Feb-2002 BUG 1323951 Added the following Declaration of Variables
67: */
68: L_MASS_UOM mtl_units_of_measure_tl.uom_code%TYPE;/*sy_uoms_typ.std_um%TYPE;GK Changes*/
69: L_MASS_UOM_TYPE mtl_uom_classes_vl.uom_class%TYPE;/*sy_uoms_typ.um_type%TYPE;GK CHanges*/
70: /*
71: ** M Thomas 05-Feb-2002 BUG 1323951 End of the Declaration of Variables
72: */

Line 212: FROM mtl_uom_classes_vl uc, mtl_units_of_measure_tl ut

208: */
209: CURSOR c_get_system_uom (p_uom_type VARCHAR2)
210: IS
211: SELECT ut.uom_code
212: FROM mtl_uom_classes_vl uc, mtl_units_of_measure_tl ut
213: WHERE ut.uom_class = l_system_uom_type
214: AND ut.uom_class = uc.uom_class;
215: SystemUOM c_get_system_uom%ROWTYPE;
216: