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

TABLE: XTR.XTR_SPOT_RATES

Object Details
Object Name: XTR_SPOT_RATES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_SPOT_RATES
Subobject Name:
Status: VALID


XTR_SPOT_RATES contains the history of foreign exchange rates. Each row corresponds to a currency rate for a given date and time.
This table corresponds to the Review Historic Rates window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_SPOT_RATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRATE_DATE
ColumnCURRENCY
XTR_SPOT_RATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCURRENCY
Columns
Name Datatype Length Mandatory Comments
ARCHIVE_BY VARCHAR2 (30)
Not currently used
ARCHIVE_DATE DATE

Not currently used
BID_RATE_AGAINST_USD NUMBER

Bid rate against the US dollar
CURRENCY VARCHAR2 (15) Yes Currency code
HCE_RATE NUMBER

Conversion rate to the reporting currency
OFFER_RATE_AGAINST_USD NUMBER

Ask rate against the US dollar
RATE_DATE DATE
Yes Rate date
SEQ_NO NUMBER

Not currently used
SPREAD_AGAINST_USD NUMBER

Spread against US dollar
UNIQUE_PERIOD_ID VARCHAR2 (20) Yes Reference code to current rates in the XTR_MARKET_PRICES table
USD_BASE_CURR_BID_RATE NUMBER

Inverse of ask rate against the US dollar
USD_BASE_CURR_OFFER_RATE NUMBER

Inverse of bid rate against the US dollar
Query Text

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


SELECT ARCHIVE_BY
,      ARCHIVE_DATE
,      BID_RATE_AGAINST_USD
,      CURRENCY
,      HCE_RATE
,      OFFER_RATE_AGAINST_USD
,      RATE_DATE
,      SEQ_NO
,      SPREAD_AGAINST_USD
,      UNIQUE_PERIOD_ID
,      USD_BASE_CURR_BID_RATE
,      USD_BASE_CURR_OFFER_RATE
FROM XTR.XTR_SPOT_RATES;

Dependencies

[top of page]

XTR.XTR_SPOT_RATES does not reference any database object

XTR.XTR_SPOT_RATES is referenced by following:

SchemaXTR
ViewXTR_SPOT_RATES#