DBA Data[Home] [Help]

APPS.OZF_REFRESH_SALES_PVT dependencies on INV_CONVERT

Line 180: common_quantity = inv_convert.inv_um_convert(inventory_item_id,

176: common_currency_code,
177: transaction_date,
178: l_curr_conv_type,
179: amount) ,
180: common_quantity = inv_convert.inv_um_convert(inventory_item_id,
181: NULL,
182: quantity,
183: uom_code,
184: common_uom_code,

Line 187: error_flag = DECODE(sign(inv_convert.inv_um_convert( inventory_item_id,

183: uom_code,
184: common_uom_code,
185: NULL,
186: NULL) ,
187: error_flag = DECODE(sign(inv_convert.inv_um_convert( inventory_item_id,
188: NULL,
189: quantity,
190: uom_code,
191: common_uom_code,

Line 276: inv_convert.inv_um_convert(ln.inventory_item_id,

272: ln.order_quantity_uom, --UOM ,
273: ln.unit_selling_price* NVL(ln.shipped_quantity,ln.ordered_quantity), --AMOUNT ,
274: hdr.transactional_curr_code, --CURRENCY_CODE ,
275: ln.inventory_item_id, --INVENTORY_ITEM_ID ,
276: inv_convert.inv_um_convert(ln.inventory_item_id,
277: NULL,
278: NVL(ln.shipped_quantity,ln.ordered_quantity),
279: ln.order_quantity_uom,
280: get_primary_uom(to_number(ln.inventory_item_id)),

Line 284: inv_convert.inv_um_convert(ln.inventory_item_id,

280: get_primary_uom(to_number(ln.inventory_item_id)),
281: NULL,
282: NULL),--PRIMARY_QUANTITY ,
283: get_primary_uom(to_number(ln.inventory_item_id)), --PRIMARY_UOM ,
284: inv_convert.inv_um_convert(ln.inventory_item_id,
285: NULL,
286: NVL(ln.shipped_quantity,ln.ordered_quantity),
287: ln.order_quantity_uom,
288: get_primary_uom(to_number(ln.inventory_item_id)),

Line 291: inv_convert.inv_um_convert(ln.inventory_item_id,

287: ln.order_quantity_uom,
288: get_primary_uom(to_number(ln.inventory_item_id)),
289: NULL,
290: NULL), --AVAILABLE_PRIMARY_QUANTITY ,
291: inv_convert.inv_um_convert(ln.inventory_item_id,
292: NULL,
293: NVL(ln.shipped_quantity,ln.ordered_quantity),
294: ln.order_quantity_uom,
295: l_common_uom,

Line 306: DECODE(sign(inv_convert.inv_um_convert(ln.inventory_item_id,

302: NVL(ln.actual_shipment_date,ln.request_date),
303: l_curr_conv_type,
304: ln.unit_selling_price*( NVL(ln.shipped_quantity,ln.ordered_quantity))
305: ) , --COMMON_AMOUNT ,
306: DECODE(sign(inv_convert.inv_um_convert(ln.inventory_item_id,
307: NULL,
308: NVL(ln.shipped_quantity,ln.ordered_quantity),
309: ln.order_quantity_uom,
310: l_common_uom,