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