113: inventory_item_id,
114: primary_uom_code,
115: transaction_uom_code,
116: ( case when primary_uom_code = transaction_uom_code then 1
117: else opi_dbi_wms_utility_pkg.get_uom_rate(
118: inventory_item_id,
119: primary_uom_code,
120: transaction_uom_code
121: )
166: inventory_item_id,
167: primary_uom_code,
168: transaction_uom_code,
169: ( case when primary_uom_code = transaction_uom_code then 1
170: else opi_dbi_wms_utility_pkg.get_uom_rate(
171: inventory_item_id,
172: primary_uom_code,
173: transaction_uom_code
174: )
203: );
204:
205: end if;
206:
207: if (opi_dbi_wms_utility_pkg.g_missing_uom) then
208: opi_dbi_wms_utility_pkg.g_missing_uom := false;
209: errbuf := 'there are missing uom conversions';
210: raise_application_error (-20000, 'error in rates table collection: ' || errbuf);
211: end if;
204:
205: end if;
206:
207: if (opi_dbi_wms_utility_pkg.g_missing_uom) then
208: opi_dbi_wms_utility_pkg.g_missing_uom := false;
209: errbuf := 'there are missing uom conversions';
210: raise_application_error (-20000, 'error in rates table collection: ' || errbuf);
211: end if;
212: