DBA Data[Home] [Help]

APPS.GMD_LABUOM_CALCULATE_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 82: l_item_no mtl_system_items_kfv.concatenated_segments%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;
84: var1 NUMBER;
85: l_factor_len NUMBER;
86: l_factorrev_len NUMBER;

Line 123: FROM mtl_system_items_kfv

119: AND tech_parm_name = v_parm_name;
120:
121: CURSOR get_item_no (Vitem_id mtl_system_items.inventory_item_id%type) IS
122: SELECT concatenated_segments
123: FROM mtl_system_items_kfv
124: WHERE inventory_item_id = Vitem_id;
125: CURSOR Cur_get_um_type (V_uom_code VARCHAR2) IS
126: SELECT uom_class
127: FROM mtl_units_of_measure