[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_FA_EXP_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
Subobject Name: | |
Status: | VALID |
snapshot log for master table FII.FII_FA_EXP_F
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_DATE | DATE | |||
AMOUNT_B | NUMBER | |||
AMOUNT_T | NUMBER | |||
ASSET_CAT_FLEX_STRUCTURE_ID | NUMBER | (15) | ||
ASSET_CAT_ID | NUMBER | (15) | ||
ASSET_CAT_MAJOR_ID | NUMBER | (15) | ||
ASSET_CAT_MAJOR_VALUE | VARCHAR2 | (240) | ||
ASSET_CAT_MINOR_ID | NUMBER | (15) | ||
ASSET_CAT_MINOR_VALUE | VARCHAR2 | (240) | ||
ASSET_ID | NUMBER | (15) | ||
BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | ||
COMPANY_ID | NUMBER | (15) | ||
COST_CENTER_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
DEPRN_TYPE | VARCHAR2 | (30) | ||
DISTRIBUTION_CCID | NUMBER | (15) | ||
DISTRIBUTION_ID | NUMBER | (15) | ||
EXPENSE_CCID | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
NATURAL_ACCOUNT_ID | NUMBER | (15) | ||
PRIM_AMOUNT_G | NUMBER | |||
SEC_AMOUNT_G | NUMBER | |||
SOURCE_CODE | VARCHAR2 | (30) | ||
USER_DIM1_ID | NUMBER | (15) | ||
USER_DIM2_ID | NUMBER | (15) | ||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_DATE
, AMOUNT_B
, AMOUNT_T
, ASSET_CAT_FLEX_STRUCTURE_ID
, ASSET_CAT_ID
, ASSET_CAT_MAJOR_ID
, ASSET_CAT_MAJOR_VALUE
, ASSET_CAT_MINOR_ID
, ASSET_CAT_MINOR_VALUE
, ASSET_ID
, BOOK_TYPE_CODE
, CHART_OF_ACCOUNTS_ID
, COMPANY_ID
, COST_CENTER_ID
, CREATED_BY
, CREATION_DATE
, CURRENCY_CODE
, DEPRN_TYPE
, DISTRIBUTION_CCID
, DISTRIBUTION_ID
, EXPENSE_CCID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LEDGER_ID
, NATURAL_ACCOUNT_ID
, PRIM_AMOUNT_G
, SEC_AMOUNT_G
, SOURCE_CODE
, USER_DIM1_ID
, USER_DIM2_ID
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM FII.MLOG$_FII_FA_EXP_F;
FII.MLOG$_FII_FA_EXP_F does not reference any database object
FII.MLOG$_FII_FA_EXP_F is referenced by following:
|
|
|