APPS.GMD_LABUOM_CALCULATE_PKG dependencies on LM_ITEM_DAT

Line 78: l_lab_conv_factor lm_item_dat.num_data%TYPE;

74: l_cur_conv_factor mtl_uom_conversions.conversion_rate%TYPE;
75: l_new_uom_factor mtl_uom_conversions.conversion_rate%TYPE;
76: l_new_conv_factor mtl_uom_conversions.conversion_rate%TYPE;
77: l_inv_uom_factor mtl_uom_conversions.conversion_rate%TYPE;
78: l_lab_conv_factor lm_item_dat.num_data%TYPE;
79: l_parm_name lm_item_dat.tech_parm_name%TYPE;
80: l_factor NUMBER;
81: l_new_qty NUMBER;
82: l_item_no mtl_system_items_kfv.concatenated_segments%type;

Line 79: l_parm_name lm_item_dat.tech_parm_name%TYPE;

75: l_new_uom_factor mtl_uom_conversions.conversion_rate%TYPE;
76: l_new_conv_factor mtl_uom_conversions.conversion_rate%TYPE;
77: l_inv_uom_factor mtl_uom_conversions.conversion_rate%TYPE;
78: l_lab_conv_factor lm_item_dat.num_data%TYPE;
79: l_parm_name lm_item_dat.tech_parm_name%TYPE;
80: l_factor NUMBER;
81: l_new_qty NUMBER;
82: l_item_no mtl_system_items_kfv.concatenated_segments%type;
83: l_inventory_item_id mtl_system_items.inventory_item_id%type;

Line 111: v_formula_id lm_item_dat.formula_id%TYPE,

107:
108: CURSOR get_lab_conv_factor(v_lab_type NUMBER,
109: v_lot_number mtl_lot_numbers.lot_number%type,
110: v_item_id mtl_system_items.inventory_item_id%type,
111: v_formula_id lm_item_dat.formula_id%TYPE,
112: v_parm_name lm_item_dat.tech_parm_name%TYPE) IS
113: SELECT num_data
114: FROM gmd_technical_data_vl
115: WHERE organization_id = v_lab_type

Line 112: v_parm_name lm_item_dat.tech_parm_name%TYPE) IS

108: CURSOR get_lab_conv_factor(v_lab_type NUMBER,
109: v_lot_number mtl_lot_numbers.lot_number%type,
110: v_item_id mtl_system_items.inventory_item_id%type,
111: v_formula_id lm_item_dat.formula_id%TYPE,
112: v_parm_name lm_item_dat.tech_parm_name%TYPE) IS
113: SELECT num_data
114: FROM gmd_technical_data_vl
115: WHERE organization_id = v_lab_type
116: AND inventory_item_id = v_item_id