[Home] [Help]
68: p_auctioneer_id,
69: pbip.price,
70: null
71: from
72: pon_auction_item_prices_all paip,
73: pon_auction_headers_all paha
74: where pbip.bid_number = p_bid_number
75: and pbip.auction_header_id = paip.auction_header_id
76: and pbip.line_number = paip.line_number
119: l_commit_flag := FALSE;
120:
121: select nvl(max(line_number),0)
122: into l_max_line_number
123: from pon_auction_item_prices_all
124: where auction_header_id = p_auction_id;
125:
126: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
127:
135: END IF;
136:
137: WHILE (l_batch_start <= l_max_line_number) LOOP --{ main-batching-loop
138:
139: UPDATE pon_auction_item_prices_all paip
140: SET
141: (paip.award_status,
142: paip.awarded_quantity,
143: paip.award_mode,
227: nvl(al.award_status,'NO'),
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
252: and nvl(bh.bid_status,'NONE') = 'ACTIVE'
253: and nvl(bh.award_status,'NO') = 'NO';
254:
255:
256: x_line_number pon_auction_item_prices_all.line_number%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;
253: and nvl(bh.award_status,'NO') = 'NO';
254:
255:
256: x_line_number pon_auction_item_prices_all.line_number%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;
254:
255:
256: x_line_number pon_auction_item_prices_all.line_number%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;
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:
266: x_bid_number_list integerList;
453: p_outcome_status IN VARCHAR2,
454: p_has_scoring_teams_flag IN VARCHAR2,
455: p_scoring_lock_tpc_id IN NUMBER) IS
456:
457: x_line_number pon_auction_item_prices_all.line_number%type;
458: x_line_origination_code pon_auction_item_prices_all.line_origination_code%type;
459: x_error_code VARCHAR2(20);
460: x_awarded_quantity NUMBER;
461: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE; -- FPK: CPA
454: p_has_scoring_teams_flag IN VARCHAR2,
455: p_scoring_lock_tpc_id IN NUMBER) IS
456:
457: x_line_number pon_auction_item_prices_all.line_number%type;
458: x_line_origination_code pon_auction_item_prices_all.line_origination_code%type;
459: x_error_code VARCHAR2(20);
460: x_awarded_quantity NUMBER;
461: l_neg_has_lines PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE; -- FPK: CPA
462:
467:
468: -- select items without any bids that had backing requisitions
469: CURSOR items_with_reqs_no_bids(p_auction_header_id NUMBER) IS
470: SELECT line_number, line_origination_code
471: FROM PON_AUCTION_ITEM_PRICES_ALL
472: WHERE auction_header_id = p_auction_header_id
473: AND nvl(number_of_bids,0) = 0
474: AND line_origination_code = 'REQUISITION';
475:
475:
476:
477: CURSOR auction_items_all (p_auction_header_id NUMBER) IS
478: SELECT line_number, nvl(awarded_quantity, 0)
479: FROM PON_AUCTION_ITEM_PRICES_ALL
480: WHERE auction_header_id = p_auction_header_id;
481:
482: BEGIN
483:
534: rrkulkar-large-auction-support : commented out the call to complete_item_disposition
535: need to add batching here
536: */
537:
538: update pon_auction_item_prices_all
539: set AWARD_STATUS = 'COMPLETED',
540: LAST_UPDATE_DATE = sysdate,
541: AWARDED_QUANTITY = nvl(awarded_quantity,0)
542: where auction_header_id = p_auction_header_id;
703: p_line_number IN NUMBER,
704: p_award_quantity IN NUMBER) IS
705:
706: BEGIN
707: update pon_auction_item_prices_all
708: set AWARD_STATUS = 'COMPLETED',
709: LAST_UPDATE_DATE = sysdate,
710: AWARDED_QUANTITY = p_award_quantity
711: where auction_header_id = p_auction_header_id
716:
717: ----------------------------------------------------------------
718: -- award item disposition
719: -- mirrors complete_item_disposition
720: -- except that pon_auction_item_prices_all.award_status column is set to AWARDED (instead of COMPLETED)
721: ----------------------------------------------------------------
722:
723: PROCEDURE award_item_disposition (p_auction_header_id IN NUMBER,
724: p_line_number IN NUMBER,
724: p_line_number IN NUMBER,
725: p_award_quantity IN NUMBER) IS
726:
727: BEGIN
728: update pon_auction_item_prices_all
729: set AWARD_STATUS = 'AWARDED',
730: LAST_UPDATE_DATE = sysdate,
731: AWARDED_QUANTITY = p_award_quantity
732: where auction_header_id = p_auction_header_id
768: --
769: l_current_bid_number NUMBER;
770: l_bid_list_index NUMBER;
771: l_tmp_award_quantity NUMBER;
772: l_group_type pon_auction_item_prices_all.group_type%TYPE;
773: l_award_date DATE;
774: TYPE BID_LIST_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
775: l_bid_list BID_LIST_TYPE;
776: l_winning_bid NUMBER;
776: l_winning_bid NUMBER;
777: l_neg_contract_type pon_auction_headers_all.contract_type%TYPE;
778:
779: --
780: l_has_quantity_tiers pon_auction_item_prices_all.has_quantity_tiers%TYPE;
781: l_award_shipment_number NUMBER;
782: l_suffix VARCHAR2(2);
783:
784: --
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;
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;
926: END IF;
927: --
928: l_bid_list_index := 0;
929: SELECT ai.group_type INTO l_group_type
930: FROM pon_auction_item_prices_all ai
931: WHERE ai.auction_header_id = p_auction_header_id
932: AND ai.line_number = p_line_num;
933: --
934: -- Getting the suffix to display the error message correctly.
972: THEN --{
973: l_award_shipment_number := -1;
974:
975: select nvl((select pbs.shipment_number
976: from pon_bid_shipments pbs, pon_auction_item_prices_all paip
977: where pbs.bid_number = l_rec.bid_number
978: and pbs.line_number = p_line_num
979: AND l_rec.award_quantity >= pbs.quantity
980: AND l_rec.award_quantity <= pbs.max_quantity
1163: )
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,
1176: */
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:
1255: AND (l_group_type = 'GROUP_LINE') ) THEN
1256:
1257: -- get parent line number
1258: SELECT parent_line_number INTO l_parent_line_number
1259: FROM pon_auction_item_prices_all
1260: WHERE auction_header_id = p_auction_id
1261: AND line_number = p_award_lines(l_index).line_number;
1262:
1263: /* Key will be bid:group 1234:56 */
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
1344: AND paip.line_number = pbip.line_number;
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
1423: AND paip.auction_header_id = pbip.auction_header_id
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');
1604: )
1605: IS
1606: CURSOR c_auction_items (c_auction_id NUMBER) IS
1607: SELECT line_number, group_type
1608: FROM pon_auction_item_prices_all
1609: WHERE auction_header_id = c_auction_id;
1610: l_auction_items_rec c_auction_items%ROWTYPE;
1611: --
1612: CURSOR c_item_sublines (c_auction_id NUMBER, c_parent_line_number NUMBER) IS
1610: l_auction_items_rec c_auction_items%ROWTYPE;
1611: --
1612: CURSOR c_item_sublines (c_auction_id NUMBER, c_parent_line_number NUMBER) IS
1613: SELECT line_number, group_type
1614: FROM pon_auction_item_prices_all
1615: WHERE auction_header_id = c_auction_id
1616: AND parent_line_number = c_parent_line_number;
1617:
1618: l_item_sublines_rec c_item_sublines%ROWTYPE;
1616: AND parent_line_number = c_parent_line_number;
1617:
1618: l_item_sublines_rec c_item_sublines%ROWTYPE;
1619: --
1620: l_group_type pon_auction_item_prices_all.group_type%TYPE;
1621: --
1622: BEGIN
1623:
1624: OPEN c_auction_items(p_auction_id);
1638: p_line_number,
1639: p_auctioneer_id,
1640: p_mode);
1641:
1642: SELECT group_type INTO l_group_type FROM pon_auction_item_prices_all
1643: WHERE auction_header_id = p_auction_id
1644: AND line_number = p_line_number;
1645: IF ((p_mode = g_AWARD_LINE AND l_group_type = 'LOT')
1646: OR (p_mode = g_AWARD_LINE_H AND l_group_type = 'LOT')
1679: (
1680: p_auction_id IN NUMBER,
1681: p_line_number IN NUMBER,
1682: p_auctioneer_id IN NUMBER,
1683: p_mode IN pon_auction_item_prices_all.award_mode%type
1684: )
1685: IS
1686: CURSOR c_bid_items (c_auction_id NUMBER, c_line_number NUMBER) IS
1687: SELECT bi.Line_number,
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
1697: AND bh.bid_status = 'ACTIVE'
1698: AND bh.auction_header_id = bi.auction_header_id
1705: l_award_quantity NUMBER;
1706: l_line_type VARCHAR2(20);
1707: l_contract_type VARCHAR2(20);
1708: l_group_type VARCHAR2(20);
1709: l_item_award_mode pon_auction_item_prices_all.award_mode%type;
1710: --
1711: BEGIN
1712: l_award_status := null;
1713: l_award_quantity := null;
1749: -- set award mode = GROUP for group level award.
1750: IF(p_mode = g_AWARD_GROUP OR p_mode = g_AWARD_GROUP_H) AND l_group_type = 'GROUP' THEN
1751: l_item_award_mode := 'GROUP';
1752: END IF;
1753: UPDATE pon_auction_item_prices_all
1754: SET award_status = l_award_status,
1755: awarded_quantity = l_award_quantity,
1756: award_mode = l_item_award_mode,
1757: last_update_date = SYSDATE,
1774: --
1775: /*
1776: CURSOR c_auction_lines (c_auction_id NUMBER) is
1777: SELECT Line_number, award_status
1778: FROM pon_auction_item_prices_all
1779: WHERE auction_header_id = c_auction_id
1780: AND number_of_bids > 0
1781: AND group_type in ('LOT', 'LINE', 'GROUP_LINE');
1782:
1833: */
1834:
1835: SELECT count(Line_number), sum(decode(award_status, 'AWARDED', 1, 0))
1836: INTO l_total_lines, l_awarded_lines
1837: FROM pon_auction_item_prices_all
1838: WHERE auction_header_id = p_auction_id
1839: AND number_of_bids > 0
1840: AND group_type in ('LOT', 'LINE', 'GROUP_LINE');
1841:
1921: -- Insert empty notes for group lines
1922: -- Delete notes for a line
1923: DELETE FROM pon_acceptances
1924: WHERE auction_header_id = p_auction_header_id
1925: AND line_number IN (SELECT line_number FROM pon_auction_item_prices_all
1926: WHERE parent_line_number = p_line_number
1927: AND auction_header_id = p_auction_header_id);
1928: INSERT INTO pon_acceptances (
1929: acceptance_id,
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')
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
2163: DELETE FROM pon_acceptances
2164: WHERE auction_header_id = p_auction_header_id;
2165:
2166: -- reset the award mode at auction item level
2167: UPDATE pon_auction_item_prices_all
2168: SET award_mode = null
2169: WHERE auction_header_id = p_auction_header_id;
2170: ELSE
2171: -- Group Level awards need to be rejected first
2184: WHERE auction_header_id = p_auction_header_id
2185: AND bid_status = 'ACTIVE'
2186: )
2187: AND line_number IN (SELECT line_number
2188: FROM pon_auction_item_prices_all
2189: WHERE auction_header_id = p_auction_header_id
2190: AND (line_number = p_line_number
2191: OR parent_line_number = p_line_number));
2192:
2193: -- Delete All group line awards since it is a group-level awarding
2194: DELETE FROM pon_acceptances
2195: WHERE auction_header_id = p_auction_header_id
2196: AND line_number IN (SELECT line_number
2197: FROM pon_auction_item_prices_all
2198: WHERE auction_header_id = p_auction_header_id
2199: AND parent_line_number = p_line_number);
2200: END IF;
2201: END IF;
2315: por.bid_number,
2316: por.line_number,
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
2383: pas.batch_id,
2384: ai.group_type,
2385: pas.award_shipment_number
2386: FROM pon_auction_summary pas
2387: , pon_auction_item_prices_all ai
2388: , pon_auction_headers_all ah
2389: WHERE
2390: pas.award_quantity >0
2391: AND pas.batch_id = c_batch_id
2847: aii.awardreject_reason,
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
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
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
3135: WHERE ai.parent_line_number = c_parent_line_number
3136: AND ai.auction_header_id = bi.auction_header_id )
3137: AND aii.auction_header_id = bi.auction_header_id
3138: AND aii.line_number = bi.line_number;
3164: ----------------------------------------------------------------
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;
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
3220: IS
3221: l_total_lines NUMBER;
3222: l_awarded_lines NUMBER;
3223: l_parent_line_number NUMBER;
3224: l_award_status pon_auction_item_prices_all.award_status%TYPE;
3225: BEGIN
3226: --get total and awarded lines
3227: SELECT parent_line_number INTO l_parent_line_number FROM pon_auction_item_prices_all
3228: WHERE auction_header_id = p_auction_header_id AND line_number = p_line_number;
3223: l_parent_line_number NUMBER;
3224: l_award_status pon_auction_item_prices_all.award_status%TYPE;
3225: BEGIN
3226: --get total and awarded lines
3227: SELECT parent_line_number INTO l_parent_line_number FROM pon_auction_item_prices_all
3228: WHERE auction_header_id = p_auction_header_id AND line_number = p_line_number;
3229: --
3230: -- all the group lines have bids if a single group line has a bid
3231: -- hence all group lines are awardable and hence considered for the count
3229: --
3230: -- all the group lines have bids if a single group line has a bid
3231: -- hence all group lines are awardable and hence considered for the count
3232: SELECT COUNT(*) INTO l_total_lines
3233: FROM pon_auction_item_prices_all ai
3234: WHERE parent_line_number = l_parent_line_number
3235: and auction_header_id = p_auction_header_id;
3236: --
3237: select COUNT(*) INTO l_awarded_lines
3234: WHERE parent_line_number = l_parent_line_number
3235: and auction_header_id = p_auction_header_id;
3236: --
3237: select COUNT(*) INTO l_awarded_lines
3238: FROM pon_auction_item_prices_all
3239: WHERE parent_line_number = l_parent_line_number
3240: AND award_status = 'AWARDED'
3241: and auction_header_id = p_auction_header_id;
3242:
3247: ELSE
3248: l_award_status := null;
3249: END IF;
3250: --
3251: UPDATE pon_auction_item_prices_all
3252: SET award_status = l_award_status,
3253: awarded_quantity = null,
3254: award_mode = null,
3255: last_update_date = p_award_date,
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 (+)
3290: AND PAIP.line_number = PBIP.line_number (+)
3291: AND PBIP.bid_number = PBH.bid_number (+)
3396: IS
3397:
3398: l_new_scenario_id NUMBER;
3399: l_status VARCHAR2(10);
3400: l_order_type_lookup_code PON_AUCTION_ITEM_PRICES_ALL.order_type_lookup_code%TYPE;
3401: l_auction_qty NUMBER;
3402: l_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
3403: l_module VARCHAR2(200);
3404: l_priority VARCHAR2(30);
3483: INTO l_contract_type,
3484: l_order_type_lookup_code,
3485: l_auction_qty
3486: FROM pon_auction_headers_all pah,
3487: pon_auction_item_prices_all pai,
3488: pon_optimize_scenarios pos
3489: WHERE pah.auction_header_id = pai.auction_header_id
3490: AND pah.auction_header_id = pos.auction_header_id
3491: AND pai.line_number = p_line_number
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,
4286: pon_bid_headers pbh