[Home] [Help] [Dependency Information]
Object Name: | FEM_DL_TRANS_CURR |
---|---|
Object Type: | TABLE |
Owner: | FEM |
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_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_DL_TRANS_CURR_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
OBJECT_ID LEDGER_ID CAL_PERIOD_ID DATASET_CODE SOURCE_SYSTEM_CODE TABLE_NAME TRANSLATED_CURRENCY |
FEM_DL_TRANS_CURR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
CAL_PERIOD_ID DATASET_CODE SOURCE_SYSTEM_CODE TABLE_NAME TRANSLATED_CURRENCY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Concurrent request identifier. | ||
OBJECT_ID | NUMBER | Business rule identifier. | ||
LEDGER_ID | NUMBER | Ledger identifier. | ||
CAL_PERIOD_ID | NUMBER | Calendar period identifier. | ||
DATASET_CODE | NUMBER | Dataset identifier. | ||
SOURCE_SYSTEM_CODE | NUMBER | Source system identifier. | ||
TABLE_NAME | VARCHAR2 | (30) | Table where the dimension combination is located. | |
TRANSLATED_CURRENCY | VARCHAR2 | (15) | Translated currency code. | |
CREATION_DATE | DATE | Standard Who column. | ||
CREATED_BY | NUMBER | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
OBJECT_VERSION_NUMBER | NUMBER | Framework required column for stale data detection. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, OBJECT_ID
, LEDGER_ID
, CAL_PERIOD_ID
, DATASET_CODE
, SOURCE_SYSTEM_CODE
, TABLE_NAME
, TRANSLATED_CURRENCY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM FEM.FEM_DL_TRANS_CURR;
FEM.FEM_DL_TRANS_CURR does not reference any database object
FEM.FEM_DL_TRANS_CURR is referenced by following:
|
|
|