Product: | PON - Sourcing |
---|---|
Description: | This view is used by the Buyer's Activity Summary report. It contains summarized data for all Awarded Auctions, Committed Offers and Accepted Quotations. |
Implementation/DBA Data: | Not implemented in this database |
SELECT NVL((PRICE*QUANTITY)
, 0) AUCTION_TOTAL
, 0 QUOTES_TOTAL
, 0 OFFER_TOTAL
, BUYER_ID
, BUYER_NAME
, SELLER_ID
, SELLER_NAME
, BUYER_CONTACT_ID
, BUYER_CONTACT_NAME
, SELLER_CONTACT_ID
, SELLER_CONTACT_NAME
, CATEGORY_ID
, COMPLETED_DATE
, CURRENCY_CODE
FROM PON_MI_AUC_BUYERAUC_V UNION ALL SELECT 0 AUCTION_TOTAL
, NVL((PRICE*QUANTITY)
, 0) QUOTES_TOTAL
, 0 OFFER_TOTAL
, BUYER_ID
, BUYER_NAME
, SELLER_ID
, SELLER_NAME
, BUYER_CONTACT_ID
, BUYER_CONTACT_NAME
, SELLER_CONTACT_ID
, SELLER_CONTACT_NAME
, CATEGORY_ID
, COMPLETED_DATE
, CURRENCY_CODE
FROM PON_MI_AUC_RFQ_V UNION ALL SELECT 0 AUCTION_TOTAL
, 0 QUOTES_TOTAL
, NVL((PRICE*QUANTITY)
, 0) OFFER_TOTAL
, BUYER_ID
, BUYER_NAME
, SELLER_ID
, SELLER_NAME
, BUYER_CONTACT_ID
, BUYER_CONTACT_NAME
, SELLER_CONTACT_ID
, SELLER_CONTACT_NAME
, CATEGORY_ID
, COMPLETED_DATE
, CURRENCY_CODE
FROM PON_MI_AUC_OFFERTOBUY_V