[Home] [Help]
View: PON_MI_OFFERSUMMARY_V
Product: | PON - Sourcing |
Description: | This view is used by the Committed Offers Detail report. It contains summarized data for all Committed Offers. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 0 SELLER_AMT
, NVL((PRICE*QUANTITY)
, 0) BUYER_AMT
, 'BUYER' OFFER_TYPE
, AUCTION_NUMBER
, AUCTION_TITLE
, COMMITMENT_NUMBER
, BUYER_ID
, BUYER_NAME
, SELLER_ID
, SELLER_NAME
, CATEGORY_ID
, COMPLETED_DATE
, CURRENCY_CODE
FROM PON_MI_AUC_OFFERTOBUY_V
Columns
Name |
SELLER_AMT |
BUYER_AMT |
OFFER_TYPE |
AUCTION_NUMBER |
AUCTION_TITLE |
COMMITMENT_NUMBER |
BUYER_ID |
BUYER_NAME |
SELLER_ID |
SELLER_NAME |
CATEGORY_ID |
COMPLETED_DATE |
CURRENCY_CODE |