APPS.GMICUOM dependencies on LM_ITEM_DAT

Line 287: l_lab_conv_factor lm_item_dat.num_data%TYPE;

283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
287: l_lab_conv_factor lm_item_dat.num_data%TYPE;
288: l_parm_name lm_item_dat.tech_parm_name%TYPE;
289: l_factor NUMBER;
290: l_new_qty NUMBER;
291: l_item_no ic_item_mst.item_no%type;

Line 288: l_parm_name lm_item_dat.tech_parm_name%TYPE;

284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
287: l_lab_conv_factor lm_item_dat.num_data%TYPE;
288: l_parm_name lm_item_dat.tech_parm_name%TYPE;
289: l_factor NUMBER;
290: l_new_qty NUMBER;
291: l_item_no ic_item_mst.item_no%type;
292: l_inventory_item_id mtl_system_items.inventory_item_id%type;

Line 723: l_lab_conv_factor lm_item_dat.num_data%TYPE;

719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
723: l_lab_conv_factor lm_item_dat.num_data%TYPE;
724: l_parm_name lm_item_dat.tech_parm_name%TYPE;
725: l_factor NUMBER;
726: l_new_qty NUMBER;
727: l_item_no ic_item_mst.item_no%type;

Line 724: l_parm_name lm_item_dat.tech_parm_name%TYPE;

720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
723: l_lab_conv_factor lm_item_dat.num_data%TYPE;
724: l_parm_name lm_item_dat.tech_parm_name%TYPE;
725: l_factor NUMBER;
726: l_new_qty NUMBER;
727: l_item_no ic_item_mst.item_no%type;
728: l_inventory_item_id mtl_system_items.inventory_item_id%type;

Line 766: v_parm_name lm_item_dat.tech_parm_name%TYPE) IS

762:
763: CURSOR get_lab_conv_factor(v_lab_type lab_type,
764: v_item_id itm_surg_type,
765: v_formula_id form_surg_type,
766: v_parm_name lm_item_dat.tech_parm_name%TYPE) IS
767: SELECT num_data
768: FROM lm_item_dat
769: WHERE orgn_code = v_lab_type
770: AND item_id = v_item_id

Line 768: FROM lm_item_dat

764: v_item_id itm_surg_type,
765: v_formula_id form_surg_type,
766: v_parm_name lm_item_dat.tech_parm_name%TYPE) IS
767: SELECT num_data
768: FROM lm_item_dat
769: WHERE orgn_code = v_lab_type
770: AND item_id = v_item_id
771: AND formula_id = v_formula_id
772: AND tech_parm_name = v_parm_name