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_TRANSFORM_BIDDING_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 99: pon_auction_item_prices_all paip

95: INTO v_has_est_qty_on_all_bid_lines
96: FROM dual
97: WHERE EXISTS (SELECT null
98: FROM pon_bid_item_prices pbip,
99: pon_auction_item_prices_all paip
100: WHERE pbip.auction_header_id = p_auction_header_id AND
101: pbip.bid_number = p_bid_number AND
102: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
103: pbip.auction_header_id = paip.auction_header_id AND

Line 117: pon_auction_item_prices_all paip

113: INTO v_has_est_qty_on_all_bid_lines
114: FROM dual
115: WHERE EXISTS ((SELECT null
116: FROM pon_bid_item_prices pbip,
117: pon_auction_item_prices_all paip
118: WHERE pbip.auction_header_id = p_auction_header_id AND
119: pbip.bid_number = p_bid_number AND
120: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
121: pbip.auction_header_id = paip.auction_header_id AND

Line 201: pon_auction_item_prices_all paip

197: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
198: nvl(pbip.price,0)) bid_total
199: INTO v_bid_total
200: FROM pon_bid_item_prices pbip,
201: pon_auction_item_prices_all paip
202: WHERE pbip.auction_header_id = p_auction_header_id AND
203: pbip.bid_number = p_bid_number AND
204: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
205: pbip.auction_header_id = paip.auction_header_id AND

Line 217: pon_auction_item_prices_all paip

213: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
214: paip.quantity, p_tpid, p_site),0)) bid_total
215: INTO v_bid_total
216: FROM pon_bid_item_prices pbip,
217: pon_auction_item_prices_all paip
218: WHERE pbip.auction_header_id = p_auction_header_id AND
219: pbip.bid_number = p_bid_number AND
220: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
221: pbip.auction_header_id = paip.auction_header_id AND

Line 519: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,

515: -- ------------------------------------------------------------------------
516:
517: FUNCTION calculate_quote_amount
518: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
519: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
521: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
522: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
523: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 528: v_group_type pon_auction_item_prices_all.group_type%TYPE;

524: p_site IN pon_bid_headers.vendor_site_id%TYPE)
525: RETURN NUMBER
526: IS
527: v_quote_amount NUMBER;
528: v_group_type pon_auction_item_prices_all.group_type%TYPE;
529: BEGIN
530: SELECT group_type
531: INTO v_group_type
532: FROM pon_auction_item_prices_all

Line 532: FROM pon_auction_item_prices_all

528: v_group_type pon_auction_item_prices_all.group_type%TYPE;
529: BEGIN
530: SELECT group_type
531: INTO v_group_type
532: FROM pon_auction_item_prices_all
533: WHERE auction_header_id = p_auction_header_id
534: AND line_number = p_line_number;
535:
536: -- Transformed View: no need to reverse-transform prices

Line 545: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

541:
542: SELECT DECODE (al.group_type, 'GROUP', bl.group_amount,
543: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity)) * bl.price)
544: INTO v_quote_amount
545: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
546: WHERE bl.bid_number = p_bid_number
547: AND bl.line_number = p_line_number
548: AND bl.auction_header_id = al.auction_header_id
549: AND bl.line_number = al.line_number;

Line 565: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

561: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))
562: * nvl(PON_TRANSFORM_BIDDING_PKG.untransform_one_price(p_auction_header_id,
563: bl.line_number, bl.price, al.quantity, p_tpid, p_site), 0)
564: INTO v_quote_amount
565: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
566: WHERE bl.bid_number = p_bid_number
567: AND bl.line_number = p_line_number
568: AND al.auction_header_id = bl.auction_header_id
569: AND al.line_number = bl.line_number;

Line 876: pon_auction_item_prices_all paip

872: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
873: nvl(pbip.price,0)) bid_total
874: INTO v_bid_total
875: FROM pon_bid_item_prices pbip,
876: pon_auction_item_prices_all paip
877: WHERE pbip.auction_header_id = p_auction_header_id AND
878: pbip.bid_number = p_bid_number AND
879: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
880: pbip.auction_header_id = paip.auction_header_id AND

Line 898: pon_auction_item_prices_all paip

894: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
895: paip.quantity, p_tpid, p_site),0)) bid_total
896: INTO v_bid_total
897: FROM pon_bid_item_prices pbip,
898: pon_auction_item_prices_all paip
899: WHERE pbip.auction_header_id = p_auction_header_id AND
900: pbip.bid_number = p_bid_number AND
901: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
902: pbip.auction_header_id = paip.auction_header_id AND

Line 993: FROM pon_auction_item_prices_all

989: FROM pon_bid_item_prices
990: WHERE auction_header_id = p_auction_header_id
991: AND bid_number = p_bid_number
992: AND auction_line_number IN (SELECT line_number
993: FROM pon_auction_item_prices_all
994: WHERE auction_header_id = p_auction_header_id
995: AND Nvl(award_status, 'NO') <> 'COMPLETED');
996:
997: RETURN v_unawarded_bid_total;