View: PON_MI_AUCTIONSUMMARY_V

Product:	PON - Sourcing
Description:	This view is used for the Awarded Bids Detail report. It contains data for both Standard Purchase Orders and Blanket Purchase Agreements.
Implementation/DBA Data:	APPS.PON_MI_AUCTIONSUMMARY_V

View Text

SELECT 0 SELLER_AMT
, DECODE(AUCTION_OUTCOME
, 'SPOT'
, NVL((PRICE*QUANTITY)
, 0)
, 0) BUYER_SPOT_AMT
, DECODE(AUCTION_OUTCOME
, 'LONG'
, NVL((PRICE*QUANTITY)
, 0)
, 0) BUYER_LONG_AMT
, NVL((PRICE*QUANTITY)
, 0) BUYER_AMT
, 'BUYER' AUCTION_TYPE
, AUCTION_NUMBER
, AUCTION_TITLE
, AUCTION_DISPLAY_NUMBER
, BID_NUMBER
, AUCTION_OUTCOME
, BUYER_ID
, BUYER_NAME
, SELLER_ID
, SELLER_NAME
, CATEGORY_ID
, COMPLETED_DATE
, CURRENCY_CODE
FROM PON_MI_AUC_BUYERAUC_V

Columns