[Home] [Help]
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
Name |
SPOT_AMT |
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 |