[Home] [Help] [Dependency Information]
Object Name: | ISC_CURR_BOOK_SUM2 |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_CURR_BOOK_SUM2_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
FROM_CURRENCY
TO_CURRENCY1 TO_CURRENCY3 CONVERSION_DATE CONVERSION_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_CURRENCY | VARCHAR2 | (40) | ||
TO_CURRENCY1 | VARCHAR2 | (40) | ||
TO_CURRENCY3 | VARCHAR2 | (40) | ||
CONVERSION_DATE | DATE | |||
CONVERSION_TYPE | VARCHAR2 | (40) | ||
RATE1 | NUMBER | |||
RATE2 | NUMBER | |||
RATE3 | NUMBER | |||
RATE4 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_CURRENCY
, TO_CURRENCY1
, TO_CURRENCY3
, CONVERSION_DATE
, CONVERSION_TYPE
, RATE1
, RATE2
, RATE3
, RATE4
FROM ISC.ISC_CURR_BOOK_SUM2;
ISC.ISC_CURR_BOOK_SUM2 does not reference any database object
ISC.ISC_CURR_BOOK_SUM2 is referenced by following:
|
|
|