eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_PKG dependencies on PON_BID_ITEM_PRICES

Line 31: from pon_bid_item_prices

27:
28: -- just set award_qty same as bid_qty
29: select nvl(max(line_number),0)
30: into l_max_line_number
31: from pon_bid_item_prices
32: where bid_number = p_bid_number;
33:
34: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
35:

Line 48: UPDATE PON_BID_ITEM_PRICES pbip

44:
45:
46: WHILE (l_batch_start <= l_max_line_number) LOOP --{ main-batching-loop
47:
48: UPDATE PON_BID_ITEM_PRICES pbip
49: SET
50: (pbip.award_status,
51: pbip.award_quantity,
52: pbip.award_date,

Line 159: pon_bid_item_prices pbip,

155: g_AWARD_QUOTE,
156: p_award_date,
157: p_auctioneer_id
158: from
159: pon_bid_item_prices pbip,
160: pon_auction_headers_all paha
161: where pbip.bid_number = p_bid_number
162: and pbip.auction_header_id = paip.auction_header_id
163: and pbip.line_number = paip.line_number

Line 232: pon_bid_item_prices bl,

228: bl.bid_number,
229: bl.order_number,
230: bl.award_quantity
231: from pon_auction_item_prices_all al,
232: pon_bid_item_prices bl,
233: pon_bid_headers bh
234: where al.auction_header_id = p_auction_header_id
235: and bl.auction_header_id = al.auction_header_id
236: and bl.line_number = al.line_number

Line 261: x_award_quantity pon_bid_item_prices.award_quantity%type;

257: x_old_line_number pon_auction_item_prices_all.line_number%type;
258: x_line_origination_code pon_auction_item_prices_all.line_origination_code%type;
259: x_bid_number pon_bid_headers.bid_number%type;
260: x_order_number pon_bid_headers.order_number%type;
261: x_award_quantity pon_bid_item_prices.award_quantity%type;
262: x_line_award_status pon_auction_item_prices_all.award_status%type;
263: x_stored_note_to_rejected pon_acceptances.reason%type;
264: x_error_code VARCHAR2(20);
265:

Line 883: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

879: -- Construct Matrix only in case of awarded bids
880: IF l_rec.award_outcome = g_AWARD_OUTCOME_WIN THEN
881: --Get Award Qty FROM Response Qty
882: SELECT decode (ai.order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, 'RATE', decode(ai.purchase_basis , 'TEMP LABOR' ,bi.quantity, 1) , bi.quantity) INTO l_tmp_award_quantity
883: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
884: WHERE bi.bid_number = l_rec.bid_number
885: AND bi.line_number = l_rec.line_number
886: AND ai.auction_header_id = bi.auction_header_id
887: AND ai.line_number = bi.line_number;

Line 890: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

886: AND ai.auction_header_id = bi.auction_header_id
887: AND ai.line_number = bi.line_number;
888: --
889: SELECT ai.group_type INTO l_group_type
890: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
891: WHERE bi.bid_number = l_rec.bid_number
892: AND bi.line_number = l_rec.line_number
893: AND ai.auction_header_id = bi.auction_header_id
894: AND ai.line_number = bi.line_number;

Line 944: from pon_bid_item_prices

940: l_rec := p_award_table(l_index);
941:
942: --R12.1 price tiers changes
943: select nvl(has_quantity_tiers,'N') into l_has_quantity_tiers
944: from pon_bid_item_prices
945: where bid_number = l_rec.bid_number
946: and line_number = p_line_num;
947:
948: IF (g_debug_mode = 'Y') THEN

Line 1012: , 'PON_BID_ITEM_PRICES'

1008: Values(
1009: p_batch_id
1010: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
1011: , 'PON_QUANTITY_TIER_VIOLATION' || l_suffix
1012: , 'PON_BID_ITEM_PRICES'
1013: , p_line_num
1014: , SYSDATE+7
1015: , fnd_global.user_id
1016: , sysdate

Line 1168: l_award_quantity pon_bid_item_prices.award_quantity%type;

1164: IS
1165: l_size NUMBER;
1166: l_index NUMBER;
1167: l_group_type pon_auction_item_prices_all.group_type%type;
1168: l_award_quantity pon_bid_item_prices.award_quantity%type;
1169: l_award_shipment_number NUMBER;
1170: --
1171: /* for updating group for each bid's group line,
1172: we maintain an associative array (hashmap equivalant)

Line 1181: l_bid_number pon_bid_item_prices.bid_number%type;

1177: type bid_line_asso is table of varchar2(30) index by varchar2(30);
1178: l_bid_group_map bid_line_asso;
1179: l_bid_line_key VARCHAR2(30);
1180: l_parent_line_number pon_auction_item_prices_all.parent_line_number%type;
1181: l_bid_number pon_bid_item_prices.bid_number%type;
1182: --
1183: BEGIN
1184:
1185: IF (g_debug_mode = 'Y') THEN

Line 1339: FROM pon_bid_item_prices pbip,

1335: SELECT decode(p_award_status, 'REJECTED', null,
1336: decode(nvl(p_award_quantity,0), 0,pbip.price,
1337: pbip.per_unit_price_component + pbip.fixed_amount_component /p_award_quantity))
1338: INTO l_award_price
1339: FROM pon_bid_item_prices pbip,
1340: pon_auction_item_prices_all paip
1341: WHERE pbip.bid_number = p_bid_number
1342: AND pbip.line_number = p_line_number
1343: AND paip.auction_header_id = pbip.auction_header_id

Line 1355: UPDATE PON_BID_ITEM_PRICES

1351:
1352: --
1353: -- as this procedure will be called only if price tiers are not applicable so reseting the award_Shipment_number
1354: --
1355: UPDATE PON_BID_ITEM_PRICES
1356: SET award_quantity = p_award_quantity,
1357: award_price = l_award_price,
1358: award_status = p_award_status,
1359: award_date = p_award_date,

Line 1368: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');

1364: Line_Number = p_line_number;
1365:
1366: IF (g_debug_mode = 'Y') THEN
1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1368: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
1369: END IF;
1370: END IF;
1371:
1372: END update_single_bid_item_prices;

Line 1384: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly

1380: * 5. p_award_date -- Award Datw
1381: * 6. p_auctioneer_id - Id of person who is saving award
1382: * 7. p_award_shipment_number - Quantity awarded falls in the tiers range corresponding to the shipment number
1383: * COMMENT : This procedure calculates the award price based on the per unit and fixed amount component and
1384: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly
1385: *==========================================================================================================================*/
1386: PROCEDURE upd_single_bid_item_prices_qt
1387: (
1388: p_bid_number IN NUMBER,

Line 1418: FROM pon_bid_item_prices pbip,

1414: SELECT DECODE(p_award_status, 'REJECTED', NULL,
1415: DECODE (NVL(p_award_quantity,0), 0, pbs.price,
1416: pbs.per_unit_price_component+pbip.fixed_amount_component/p_award_quantity))
1417: INTO l_award_price
1418: FROM pon_bid_item_prices pbip,
1419: pon_auction_item_prices_all paip,
1420: pon_bid_shipments pbs
1421: WHERE pbip.bid_number = p_bid_number
1422: AND pbip.line_number = p_line_number

Line 1435: UPDATE PON_BID_ITEM_PRICES

1431: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);
1432: END IF; --}
1433: END IF; --}
1434:
1435: UPDATE PON_BID_ITEM_PRICES
1436: SET award_quantity = p_award_quantity,
1437: award_status = p_award_status,
1438: award_date = p_award_date,
1439: last_update_date = p_award_date,

Line 1448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');

1444: Line_Number = p_line_number;
1445:
1446: IF (g_debug_mode = 'Y') THEN
1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
1449: END IF;
1450: END IF;
1451:
1452: END upd_single_bid_item_prices_qt;

Line 1534: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

1530:
1531: SELECT bi.Line_number,
1532: bi.award_status,
1533: nvl(bi.award_price , bi.price) * bi.award_quantity award_price
1534: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
1535: WHERE bi.bid_number = c_bid_number
1536: and bi.auction_header_id = ai.auction_header_id
1537: and bi.line_number = ai.line_number
1538: and ai.group_type in ('LOT', 'LINE', 'GROUP_LINE');

Line 1692: FROM pon_bid_item_prices bi,

1688: ai.order_type_lookup_code,
1689: bi.award_status,
1690: bi.award_quantity,
1691: ai.group_type
1692: FROM pon_bid_item_prices bi,
1693: pon_bid_headers bh,
1694: pon_auction_item_prices_all ai
1695: WHERE bi.auction_header_id = c_auction_id
1696: AND bi.line_number = c_line_number

Line 1949: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai

1945: p_award_date,
1946: null,
1947: p_award_date,
1948: p_auctioneer_id
1949: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai
1950: WHERE bi.auction_header_id = ai.auction_header_id
1951: AND ai.line_number = bi.line_number
1952: AND (bi.award_status = 'AWARDED'
1953: OR bi.award_status = 'REJECTED')

Line 1989: FROM pon_bid_item_prices bi, pon_bid_headers bh

1985: 'REJECTED', p_note_to_rejected,
1986: null),
1987: SYSDATE,
1988: p_auctioneer_id
1989: FROM pon_bid_item_prices bi, pon_bid_headers bh
1990: WHERE bi.auction_header_id = p_auction_header_id
1991: AND bi.line_number = p_line_number
1992: AND (bi.award_status = 'AWARDED'
1993: OR bi.award_status = 'REJECTED')

Line 2027: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai

2023: 'REJECTED', p_note_to_rejected,
2024: null),
2025: p_award_date,
2026: p_auctioneer_id
2027: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai
2028: WHERE bi.auction_header_id = p_auction_header_id
2029: AND (bi.award_status = 'AWARDED'
2030: OR bi.award_status = 'REJECTED')
2031: AND bi.bid_number = bh.bid_number

Line 2105: FROM pon_bid_item_prices bi, pon_bid_headers bh

2101: p_award_date,
2102: p_note_to_rejected,
2103: p_award_date,
2104: p_auctioneer_id
2105: FROM pon_bid_item_prices bi, pon_bid_headers bh
2106: WHERE bi.auction_header_id = p_auction_header_id
2107: AND bi.line_number = p_line_number
2108: AND nvl(bi.award_status, 'NO') <> 'AWARDED' -- can be REJECTED/ NO
2109: AND bi.bid_number = bh.bid_number

Line 2147: UPDATE pon_bid_item_prices

2143:
2144: IF (p_line_number IS NULL OR p_line_number <= 0 )THEN
2145: -- Header level awards
2146: --Update award status to REJECTED for all the bids
2147: UPDATE pon_bid_item_prices
2148: SET award_status = 'REJECTED',
2149: award_quantity = NULL,
2150: award_date = p_award_date,
2151: last_update_date = p_award_date,

Line 2173: UPDATE pon_bid_item_prices

2169: WHERE auction_header_id = p_auction_header_id;
2170: ELSE
2171: -- Group Level awards need to be rejected first
2172: --Update award status to REJECTED for all the bids
2173: UPDATE pon_bid_item_prices
2174: SET award_status = 'REJECTED',
2175: award_quantity = NULL,
2176: award_date = p_award_date,
2177: last_update_date = p_award_date,

Line 2232: UPDATE pon_bid_item_prices

2228: )
2229: IS
2230: BEGIN
2231: --Update award status to REJECTED for all the bids
2232: UPDATE pon_bid_item_prices
2233: SET award_status = 'REJECTED',
2234: award_quantity = NULL,
2235: award_date = p_award_date,
2236: last_update_date = SYSDATE,

Line 2321: pon_bid_item_prices pbip

2317: por.award_quantity,
2318: por.award_shipment_number
2319: FROM pon_optimize_results por, pon_auction_item_prices_all paip,
2320: pon_auction_headers_all pah,
2321: pon_bid_item_prices pbip
2322: WHERE pah.auction_header_id = l_auction_header_id
2323: AND pah.auction_header_id = paip.auction_header_id
2324: AND por.bid_number = pbip.bid_number
2325: AND por.line_number = pbip.line_number

Line 2852: pon_bid_item_prices bi,

2848: ai.group_type,
2849: aii.award_shipment_number
2850: FROM pon_award_items_interface aii,
2851: pon_auction_item_prices_all ai,
2852: pon_bid_item_prices bi,
2853: pon_auction_headers_all pah
2854: WHERE
2855: aii.batch_id = c_batch_id
2856: AND aii.auction_header_id = c_auction_header_id

Line 3114: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,

3110: --
3111: PROCEDURE award_bi_subline (
3112: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3113: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3114: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
3115: p_award_status IN pon_bid_item_prices.award_status%TYPE,
3116: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3117: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
3118: IS

Line 3115: p_award_status IN pon_bid_item_prices.award_status%TYPE,

3111: PROCEDURE award_bi_subline (
3112: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3113: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3114: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
3115: p_award_status IN pon_bid_item_prices.award_status%TYPE,
3116: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3117: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
3118: IS
3119: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,

Line 3116: p_award_date IN pon_bid_item_prices.award_date%TYPE,

3112: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3113: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3114: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
3115: p_award_status IN pon_bid_item_prices.award_status%TYPE,
3116: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3117: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
3118: IS
3119: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,
3120: c_bid_number pon_bid_headers.bid_number%TYPE,

Line 3117: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)

3113: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3114: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
3115: p_award_status IN pon_bid_item_prices.award_status%TYPE,
3116: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3117: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
3118: IS
3119: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,
3120: c_bid_number pon_bid_headers.bid_number%TYPE,
3121: c_parent_line_number pon_bid_item_prices.line_number%TYPE) IS

Line 3121: c_parent_line_number pon_bid_item_prices.line_number%TYPE) IS

3117: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
3118: IS
3119: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,
3120: c_bid_number pon_bid_headers.bid_number%TYPE,
3121: c_parent_line_number pon_bid_item_prices.line_number%TYPE) IS
3122: --Query retrives sublines for the given parent line
3123: SELECT
3124: bi.line_number,
3125: DECODE (p_award_status, 'AWARDED',decode (aii.group_type,

Line 3130: FROM pon_bid_item_prices bi, pon_auction_item_prices_all aii

3126: 'LOT_LINE', null, decode (aii.order_type_lookup_code,
3127: 'FIXED PRICE', 1,
3128: 'AMOUNT', 1,
3129: 'RATE', decode (aii.purchase_basis, 'TEMP LABOR', bi.quantity, 1), bi.quantity )), null) award_quantity
3130: FROM pon_bid_item_prices bi, pon_auction_item_prices_all aii
3131: WHERE
3132: bi.bid_number = c_bid_number
3133: AND bi.line_number IN (SELECT ai.line_number
3134: FROM pon_auction_item_prices_all ai

Line 3169: p_award_date IN pon_bid_item_prices.award_date%TYPE,

3165: PROCEDURE update_bi_group_award (
3166: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3167: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3168: p_parent_line_number IN pon_auction_item_prices_all.parent_line_number%TYPE,
3169: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3170: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE )
3171: IS
3172: l_total_lines NUMBER;
3173: l_awarded_lines NUMBER;

Line 3170: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE )

3166: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3167: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3168: p_parent_line_number IN pon_auction_item_prices_all.parent_line_number%TYPE,
3169: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3170: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE )
3171: IS
3172: l_total_lines NUMBER;
3173: l_awarded_lines NUMBER;
3174: l_rejected_lines NUMBER;

Line 3175: l_award_status pon_bid_item_prices.award_status%TYPE;

3171: IS
3172: l_total_lines NUMBER;
3173: l_awarded_lines NUMBER;
3174: l_rejected_lines NUMBER;
3175: l_award_status pon_bid_item_prices.award_status%TYPE;
3176: BEGIN
3177: --get total, awarded/ rejected lines
3178: --
3179: SELECT count (*) ,

Line 3185: FROM pon_auction_item_prices_all ai, pon_bid_item_prices bi

3181: sum(decode(bi.award_status,'REJECTED',1,0))
3182: INTO l_total_lines,
3183: l_awarded_lines,
3184: l_rejected_lines
3185: FROM pon_auction_item_prices_all ai, pon_bid_item_prices bi
3186: WHERE ai.parent_line_number = p_parent_line_number
3187: AND ai.auction_header_id = p_auction_header_id
3188: and ai.auction_header_id = bi.auction_header_id(+)
3189: and bi.bid_number = p_bid_number

Line 3217: p_line_number IN pon_bid_item_prices.line_number%TYPE,

3213: --
3214: --
3215: PROCEDURE update_ai_group_award (
3216: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3217: p_line_number IN pon_bid_item_prices.line_number%TYPE,
3218: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3219: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)
3220: IS
3221: l_total_lines NUMBER;

Line 3218: p_award_date IN pon_bid_item_prices.award_date%TYPE,

3214: --
3215: PROCEDURE update_ai_group_award (
3216: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3217: p_line_number IN pon_bid_item_prices.line_number%TYPE,
3218: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3219: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)
3220: IS
3221: l_total_lines NUMBER;
3222: l_awarded_lines NUMBER;

Line 3219: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)

3215: PROCEDURE update_ai_group_award (
3216: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
3217: p_line_number IN pon_bid_item_prices.line_number%TYPE,
3218: p_award_date IN pon_bid_item_prices.award_date%TYPE,
3219: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)
3220: IS
3221: l_total_lines NUMBER;
3222: l_awarded_lines NUMBER;
3223: l_parent_line_number NUMBER;

Line 3285: FROM pon_bid_item_prices PBIP,

3281: SELECT sum(nvl2(PAIP.current_price,
3282: PAIP.current_price * nvl(PAIP.awarded_quantity, 0),
3283: sum(decode(PBIP.award_status, 'AWARDED', nvl(PBIP.award_quantity, 0), 0) * nvl(PBIP.award_price, 0))))
3284: INTO p_current_total
3285: FROM pon_bid_item_prices PBIP,
3286: pon_bid_headers PBH,
3287: pon_auction_item_prices_all PAIP
3288: WHERE PAIP.auction_header_id = p_auction_header_id
3289: AND PAIP.auction_header_id = PBIP.auction_header_id (+)

Line 3299: FROM pon_bid_item_prices PBIP,

3295: PAIP.line_number, PAIP.current_price, PAIP.awarded_quantity;
3296:
3297: SELECT sum(decode(PBIP.award_status, 'AWARDED', nvl(PBIP.award_quantity, 0), 0) * nvl(PBIP.award_price, 0))
3298: INTO p_award_total
3299: FROM pon_bid_item_prices PBIP,
3300: pon_bid_headers PBH
3301: WHERE PBH.auction_header_id = p_auction_header_id
3302: AND PBIP.bid_number = PBH.bid_number (+)
3303: AND PBH.bid_status (+) = 'ACTIVE'

Line 4281: pon_bid_item_prices bi,

4277: l_current_total_spend_col,
4278: l_fixed_incentive_col,
4279: l_current_rebate_col
4280: FROM
4281: pon_bid_item_prices bi,
4282: pon_auction_item_prices_all ai,
4283: pon_optimize_scenarios pos,
4284: pon_optimize_results por,
4285: pon_bid_shipments pbs,