APPS.GMD_LABUOM_CALCULATE_PKG dependencies on MTL_UOM_CONVERSIONS

Line 73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%TYPE;

69: l_new_uom_code mtl_units_of_measure.uom_code%TYPE;
70: l_cur_um_type mtl_uom_classes.uom_class%TYPE;
71: l_new_um_type mtl_uom_classes.uom_class%TYPE;
72: l_inv_um_type mtl_uom_classes.uom_class%TYPE;
73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%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;

Line 74: l_cur_conv_factor mtl_uom_conversions.conversion_rate%TYPE;

70: l_cur_um_type mtl_uom_classes.uom_class%TYPE;
71: l_new_um_type mtl_uom_classes.uom_class%TYPE;
72: l_inv_um_type mtl_uom_classes.uom_class%TYPE;
73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%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;

Line 75: l_new_uom_factor mtl_uom_conversions.conversion_rate%TYPE;

71: l_new_um_type mtl_uom_classes.uom_class%TYPE;
72: l_inv_um_type mtl_uom_classes.uom_class%TYPE;
73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%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;

Line 76: l_new_conv_factor mtl_uom_conversions.conversion_rate%TYPE;

72: l_inv_um_type mtl_uom_classes.uom_class%TYPE;
73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%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;

Line 77: l_inv_uom_factor mtl_uom_conversions.conversion_rate%TYPE;

73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%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;

Line 92: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom

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
95: AND uomc.inventory_item_id = Vinventory_item_id
96: UNION

Line 98: FROM mtl_uom_conversions a, mtl_units_of_measure b

94: AND uomc.uom_code = uom.uom_code
95: AND uomc.inventory_item_id = Vinventory_item_id
96: UNION
97: SELECT 2, b.uom_class, a.conversion_rate
98: FROM mtl_uom_conversions a, mtl_units_of_measure b
99: WHERE a.uom_code = b.uom_code
100: AND b.uom_code = Vum_code
101: ORDER by 1;
102: