APPS.OPI_DBI_REP_UOM_PKG dependencies on OPI_DBI_UOM_CLASS_STD_CONV

Line 50: FROM opi_dbi_uom_class_std_conv

46:
47: cursor inter_conversions is
48: SELECT decode(from_base_uom_code, l_from_base_code, 1, 2) flag,
49: conv_rate
50: FROM opi_dbi_uom_class_std_conv
51: WHERE (from_base_uom_code = l_from_base_code
52: AND to_base_uom_code = l_to_base_code)
53: OR (from_base_uom_code = l_to_base_code
54: AND to_base_uom_code = l_from_base_code);

Line 110: 2. use opi_dbi_uom_class_std_conv table to get rate between from_base_uom and to_base_uom.

106: if (l_to_quantity = -99999) then
107:
108: /* standard interclass case or item specific interclass undefined
109: 1. use inv_conv api to get rate between from_uom and from_base_uom.
110: 2. use opi_dbi_uom_class_std_conv table to get rate between from_base_uom and to_base_uom.
111: 3. use inv_conv api to get rate between to_base_uom and to_uom. */
112:
113: l_from_intra_rate := inv_convert.inv_um_convert(l_eff_item_id, p_precision, 1,
114: p_from_code, l_from_base_code, null, null);