[Home] [Help] [Dependency Information]
Object Name: | ASO_BI_CURRENCY_RATES |
---|---|
Object Type: | TABLE |
Owner: | ASO |
Subobject Name: | |
Status: | VALID |
Contains primary,secondary and functional Rate Conversion Information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASO_BI_CURRENCY_RATES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TXN_CURRENCY
EXCHANGE_DATE ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TXN_CURRENCY | VARCHAR2 | (15) | Transactional Currency | |
EXCHANGE_DATE | DATE | Date of Currency Conversion | ||
PRIM_CONVERSION_RATE | NUMBER | Primary Conversion Rate | ||
SEC_CONVERSION_RATE | NUMBER | Secondary Conversion Rate | ||
FUNC_CONVERSION_RATE | NUMBER | Functional Conversion Rate | ||
FUNC_CURRENCY_CODE | VARCHAR2 | (15) | Functional Currency Code | |
ORG_ID | NUMBER | Organization ID |
Cut, paste (and edit) the following text to query this object:
SELECT TXN_CURRENCY
, EXCHANGE_DATE
, PRIM_CONVERSION_RATE
, SEC_CONVERSION_RATE
, FUNC_CONVERSION_RATE
, FUNC_CURRENCY_CODE
, ORG_ID
FROM ASO.ASO_BI_CURRENCY_RATES;
ASO.ASO_BI_CURRENCY_RATES does not reference any database object
ASO.ASO_BI_CURRENCY_RATES is referenced by following:
|
|
|