[Home] [Help] [Dependency Information]
Object Name: | QPR_CURRENCY_RATES |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table contains the currency conversion rates.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_CURRENCY_RATES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CURR_CONV_ID |
QPR_CURRENCY_RATES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INSTANCE_ID
FROM_CURRENCY TO_CURRENCY CONVERSION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURR_CONV_ID | NUMBER | Yes | Unique identifier for currency conversion values. | |
INSTANCE_ID | NUMBER | Yes | Unique identifier of the application instance from which the data was sourced. | |
FROM_CURRENCY | VARCHAR2 | (15) | Yes | Identifies the currency code from which the conversion takes place. |
TO_CURRENCY | VARCHAR2 | (15) | Yes | Identifies the currency code to which the conversion takes place. |
CONVERSION_DATE | DATE | Yes | Date from which the conversion rate is effective. | |
CONVERSION_RATE | NUMBER | Yes | The value for conversion from one currency code to other. | |
CONVERSION_CLASS | VARCHAR2 | (30) | Yes | Indicates the conversion type from which the daily rates have been sourced. |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applicaitons Consurrent Program Login ID | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the consurrent program | ||
REQUEST_ID | NUMBER | Identifies the concurrent request instance that spawned the concurrent program |
Cut, paste (and edit) the following text to query this object:
SELECT CURR_CONV_ID
, INSTANCE_ID
, FROM_CURRENCY
, TO_CURRENCY
, CONVERSION_DATE
, CONVERSION_RATE
, CONVERSION_CLASS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM QPR.QPR_CURRENCY_RATES;
QPR.QPR_CURRENCY_RATES does not reference any database object
QPR.QPR_CURRENCY_RATES is referenced by following:
|
|
|