DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on INV_CONVERT

Line 1751: select SUM(inv_convert.inv_um_convert( bs.product_id,

1747: l_product_attr_value IN VARCHAR2,
1748: l_qualifier_grouping_no IN NUMBER,
1749: l_period_number IN NUMBER )
1750: IS
1751: select SUM(inv_convert.inv_um_convert( bs.product_id,
1752: null,
1753: bs.qty,
1754: bs.order_uom,
1755: p_fcst_uom,

Line 8205: l_conv_item_cost := inv_convert.inv_um_convert( i.product_id,

8201: THEN
8202:
8203: IF l_temp_item_cost IS NOT NULL
8204: THEN
8205: l_conv_item_cost := inv_convert.inv_um_convert( i.product_id,
8206: null,
8207: 1,
8208: i.primary_uom_code,
8209: p_fcst_uom,

Line 9246: inv_convert.inv_um_convert( p.product_id,

9242: SELECT o.offer_type,
9243: p.product_id,
9244: line.order_quantity_uom,
9245: NVL(line.shipped_quantity, line.ordered_quantity) ordered_quantity,
9246: inv_convert.inv_um_convert( p.product_id,
9247: null,
9248: DECODE(line.line_category_code
9249: ,'ORDER', line.shipped_quantity
9250: ,-NVL(line.shipped_quantity,line.ordered_quantity)

Line 9756: SELECT inv_convert.inv_um_convert( null,

9752:
9753: CURSOR c_fcst_to_voloffr_uom_conv(l_fcst_qty IN NUMBER,
9754: l_fcst_uom IN VARCHAR2,
9755: l_voloffr_uom IN VARCHAR2) IS
9756: SELECT inv_convert.inv_um_convert( null,
9757: null,
9758: l_fcst_qty,
9759: l_fcst_uom,
9760: l_voloffr_uom, null, null) converted_qty

Line 10003: inv_convert.inv_um_convert(

9999: DECODE(disc.list_line_type_code,
10000: 'DIS',disc.benefit_qty
10001: ,prod.pricing_attr_value_from) offer_product_qty,
10002: fcst.forecast_uom_code,
10003: inv_convert.inv_um_convert(
10004: null,
10005: null,
10006: DECODE(disc.list_line_type_code,
10007: 'DIS',disc.benefit_qty