[Home] [Help] [Dependency Information]
Object Name: | PON_MI_RFQSUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PON.PON_MI_RFQSUMMARY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPOT_AMT | NUMBER | Price*Quantity if auction_outcome equals "SPOT"; otherwise zero | ||
LONG_AMT | NUMBER | Price*Quantity if auction_outcome equals "LONG"; otherwise zero | ||
AUCTION_NUMBER | NUMBER | Yes | System-generated unique auction number | |
AUCTION_TITLE | VARCHAR2 | (80) | Auction title | |
AUCTION_DISPLAY_NUMBER | VARCHAR2 | (81) | Auction number concatenated with auction round number | |
BID_NUMBER | NUMBER | Yes | System-generated bid number | |
AUCTION_OUTCOME | VARCHAR2 | (4) | Contract type: BLANKET, LONG, or SPOT | |
BUYER_ID | NUMBER | Buyer's trading partner id | ||
BUYER_NAME | VARCHAR2 | (255) | Buyer's trading partner name | |
SELLER_ID | NUMBER | Seller's trading partner id | ||
SELLER_NAME | VARCHAR2 | (255) | Seller's trading partner id | |
CATEGORY_ID | NUMBER | Bid item's unique category id | ||
COMPLETED_DATE | DATE | Awarded Date | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PON_MI_RFQSUMMARY_V;
APPS.PON_MI_RFQSUMMARY_V is not referenced by any database object
|
|
|