VIEW: APPS.PON_MI_AUC_BUYERAUC_V

Source

View Text - Preformatted

SELECT bi.price price, bi.award_quantity quantity, bi.line_number line_number, bi.item_description item_description, ah.auction_header_id auction_number, ah.auction_title auction_title, (case when ah.auction_header_id_orig_round is null then to_char(ah.auction_header_id) else ah.auction_header_id_orig_round || '-' || auction_round_number end) auction_display_number, bh.bid_number bid_number, bi.auc_trading_partner_id buyer_id, ah.trading_partner_name buyer_name, bi.bid_trading_partner_id seller_id, bh.trading_partner_name seller_name, ah.trading_partner_contact_id buyer_contact_id, ah.trading_partner_contact_name buyer_contact_name, bh.trading_partner_contact_id seller_contact_id, bh.trading_partner_contact_name seller_contact_name, bi.category_id category_id, ah.currency_code currency_code, decode(ah.contract_type,'BLANKET', 'LONG','SPOT') auction_outcome, bi.award_date completed_date from pon_auction_headers ah, pon_bid_headers bh, pon_bid_item_prices bi, pon_auc_doctypes ad WHERE ah.auction_header_id = bh.auction_header_id and bh.auction_header_id = bi.auction_header_id and bh.bid_number = bi.bid_number and ah.doctype_id = ad.doctype_id(+) and bi.award_status = 'AWARDED' and (((ad.internal_name is null) and (ah.auction_type = 'REVERSE')) or (ad.internal_name= 'BUYER_AUCTION'))

View Text - HTML Formatted

SELECT BI.PRICE PRICE
, BI.AWARD_QUANTITY QUANTITY
, BI.LINE_NUMBER LINE_NUMBER
, BI.ITEM_DESCRIPTION ITEM_DESCRIPTION
, AH.AUCTION_HEADER_ID AUCTION_NUMBER
, AH.AUCTION_TITLE AUCTION_TITLE
, (CASE WHEN AH.AUCTION_HEADER_ID_ORIG_ROUND IS NULL THEN TO_CHAR(AH.AUCTION_HEADER_ID) ELSE AH.AUCTION_HEADER_ID_ORIG_ROUND || '-' || AUCTION_ROUND_NUMBER END) AUCTION_DISPLAY_NUMBER
, BH.BID_NUMBER BID_NUMBER
, BI.AUC_TRADING_PARTNER_ID BUYER_ID
, AH.TRADING_PARTNER_NAME BUYER_NAME
, BI.BID_TRADING_PARTNER_ID SELLER_ID
, BH.TRADING_PARTNER_NAME SELLER_NAME
, AH.TRADING_PARTNER_CONTACT_ID BUYER_CONTACT_ID
, AH.TRADING_PARTNER_CONTACT_NAME BUYER_CONTACT_NAME
, BH.TRADING_PARTNER_CONTACT_ID SELLER_CONTACT_ID
, BH.TRADING_PARTNER_CONTACT_NAME SELLER_CONTACT_NAME
, BI.CATEGORY_ID CATEGORY_ID
, AH.CURRENCY_CODE CURRENCY_CODE
, DECODE(AH.CONTRACT_TYPE
, 'BLANKET'
, 'LONG'
, 'SPOT') AUCTION_OUTCOME
, BI.AWARD_DATE COMPLETED_DATE
FROM PON_AUCTION_HEADERS AH
, PON_BID_HEADERS BH
, PON_BID_ITEM_PRICES BI
, PON_AUC_DOCTYPES AD
WHERE AH.AUCTION_HEADER_ID = BH.AUCTION_HEADER_ID
AND BH.AUCTION_HEADER_ID = BI.AUCTION_HEADER_ID
AND BH.BID_NUMBER = BI.BID_NUMBER
AND AH.DOCTYPE_ID = AD.DOCTYPE_ID(+)
AND BI.AWARD_STATUS = 'AWARDED'
AND (((AD.INTERNAL_NAME IS NULL)
AND (AH.AUCTION_TYPE = 'REVERSE')) OR (AD.INTERNAL_NAME= 'BUYER_AUCTION'))