Product: | PON - Sourcing |
---|---|
Description: | This view is used by the Buyer's Activity Summary report. It contains data for all Committed Offers. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AI.PRICE PRICE
, AI.QUANTITY QUANTITY
, AI.ITEM_DESCRIPTION ITEM_DESCRIPTION
, AH1.AUCTION_HEADER_ID AUCTION_NUMBER
, AH1.AUCTION_TITLE AUCTION_TITLE
, OC.COMMITMENT_ID COMMITMENT_NUMBER
, OC.AUC_TRADING_PARTNER_ID BUYER_ID
, AH1.TRADING_PARTNER_NAME BUYER_NAME
, OC.BID_TRADING_PARTNER_ID SELLER_ID
, AH2.TRADING_PARTNER_NAME SELLER_NAME
, AH1.TRADING_PARTNER_CONTACT_ID BUYER_CONTACT_ID
, AH1.TRADING_PARTNER_CONTACT_NAME BUYER_NAME
, AH2.TRADING_PARTNER_CONTACT_ID SELLER_CONTACT_ID
, AH2.TRADING_PARTNER_CONTACT_NAME SELLER_CONTACT_NAME
, AI.CATEGORY_ID CATEGORY_ID
, AH1.CURRENCY_CODE CURRENCY_CODE
, OC.AUTHORIZATION_DATE COMPLETED_DATE
FROM PON_AUCTION_HEADERS_ALL AH1
, PON_AUCTION_HEADERS_ALL AH2
, PON_AUCTION_ITEM_PRICES_ALL AI
, PON_OFFER_COMMITMENTS OC
, PON_AUC_DOCTYPES AD
WHERE AH1.AUCTION_HEADER_ID = OC.INITIAL_OFFER_ID
AND AH2.AUCTION_HEADER_ID = OC.COMMIT_OFFER_ID
AND AH2.AUCTION_HEADER_ID = AI.AUCTION_HEADER_ID
AND AH1.DOCTYPE_ID = AD.DOCTYPE_ID
AND AH1.OFFER_TYPE = 'INITIAL_OFFER'
AND AH2.OFFER_TYPE = 'COMMIT_OFFER'
AND AD.INTERNAL_NAME = 'OFFER_TO_BUY'
AND OC.COMMITMENT_STATUS = 'APPROVED'