View: PON_MI_RFQSUMMARY_V

Product:	PON - Sourcing
Description:	This view is used by the Accepted Quotations Detail report. It contains summarized data for all Accepted Quotations.
Implementation/DBA Data:	APPS.PON_MI_RFQSUMMARY_V

View Text

SELECT DECODE(AUCTION_OUTCOME
, 'SPOT'
, NVL((PRICE*QUANTITY)
, 0)
, 0) SPOT_AMT
, DECODE(AUCTION_OUTCOME
, 'LONG'
, NVL((PRICE*QUANTITY)
, 0)
, 0) LONG_AMT
, 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_RFQ_V

Columns