eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PON.PON_AUCTION_CURRENCY_RATES

Object Details

Object Name:	PON_AUCTION_CURRENCY_RATES
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_AUCTION_CURRENCY_RATES
Subobject Name:
Status:	VALID

PON_AUCTION_CURRENCY_RATES stores transaction-specific currency rates for multi currency auctions, RFQs, and RFIs if the negotiation owner defines the currency rates. If the negotiation uses company-wide currency rates, then no records are created in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_AUCTION_CURRENCY_RATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID
PON_AUCTION_CURRENCY_RATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID	NUMBER			Auction Header Identifier
AUCTION_CURRENCY_CODE	VARCHAR2	(15)	Yes	Code for currency in which the auction will be conducted
BID_CURRENCY_CODE	VARCHAR2	(15)		Additional Code for currency in which the bidding can be done in addition to the auction currency
RATE	NUMBER			Currency conversion rate between the auction currency and the bid currency
NUMBER_PRICE_DECIMALS	NUMBER			Price precision to round the amount converted from the auction currency to the bid currency
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
RATE_TYPE	VARCHAR2	(25)		Currency conversion rate type(User, Corporate)
RATE_DATE	DATE			No longer used
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LIST_ID	NUMBER			Not used.
DERIVE_TYPE	VARCHAR2	(8)		Distinguishes the currency as EMU if it is EMU derived otherwise, NULL
SEQUENCE_NUMBER	NUMBER			To maintain the order of currencies
RATE_DSP	NUMBER			The rate entered by user from bid to auction currency
LAST_AMENDMENT_UPDATE	NUMBER			Holds the amendment number the rate was last modified.
MODIFIED_FLAG	VARCHAR2	(1)		Flag to indicate whether this currency has been modified in multi-round or amendment.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUCTION_HEADER_ID
,      AUCTION_CURRENCY_CODE
,      BID_CURRENCY_CODE
,      RATE
,      NUMBER_PRICE_DECIMALS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      RATE_TYPE
,      RATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LIST_ID
,      DERIVE_TYPE
,      SEQUENCE_NUMBER
,      RATE_DSP
,      LAST_AMENDMENT_UPDATE
,      MODIFIED_FLAG
FROM PON.PON_AUCTION_CURRENCY_RATES;

Dependencies

[top of page]

PON.PON_AUCTION_CURRENCY_RATES does not reference any database object

PON.PON_AUCTION_CURRENCY_RATES is referenced by following:

PON: PON_AUCTION_CURRENCY_RATES#