View: PON_MI_AUC_BUYERAUC_V

Product:	PON - Sourcing
Description:	This view is used by the Buyer's Activity Summary report. It contains data for all Awarded Auctions.
Implementation/DBA Data:	APPS.PON_MI_AUC_BUYERAUC_V

View Text

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'))

Columns