DBA Data[Home] [Help]

APPS.GMD_LABUOM_CALCULATE_PKG dependencies on MTL_SYSTEM_ITEMS

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 83: l_inventory_item_id mtl_system_items.inventory_item_id%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;
87: /* Cursor Definitions

Line 90: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS

86: l_factorrev_len NUMBER;
87: /* Cursor Definitions
88: ==================*/
89: CURSOR get_uom_type(Vum_code mtl_units_of_measure.uom_code%TYPE,
90: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
91: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
92: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom
93: WHERE uom.uom_code = Vum_code
94: AND uomc.uom_code = uom.uom_code

Line 103: CURSOR get_inv_uom(v_item_id mtl_system_items.inventory_item_id%type) IS

99: WHERE a.uom_code = b.uom_code
100: AND b.uom_code = Vum_code
101: ORDER by 1;
102:
103: CURSOR get_inv_uom(v_item_id mtl_system_items.inventory_item_id%type) IS
104: SELECT primary_uom_code
105: FROM mtl_system_items
106: WHERE inventory_item_id = v_item_id;
107:

Line 105: FROM mtl_system_items

101: ORDER by 1;
102:
103: CURSOR get_inv_uom(v_item_id mtl_system_items.inventory_item_id%type) IS
104: SELECT primary_uom_code
105: FROM mtl_system_items
106: WHERE inventory_item_id = v_item_id;
107:
108: CURSOR get_lab_conv_factor(v_lab_type NUMBER,
109: v_lot_number mtl_lot_numbers.lot_number%type,

Line 110: v_item_id mtl_system_items.inventory_item_id%type,

106: WHERE inventory_item_id = v_item_id;
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

Line 121: CURSOR get_item_no (Vitem_id mtl_system_items.inventory_item_id%type) IS

117: AND lot_number = v_lot_number
118: AND formula_id = v_formula_id
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

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