[Home] [Help] [Dependency Information]
Object Name: | FII_FA_EXP_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.FII_FA_EXP_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_FII_FA_EXP_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("CURRENCY_CODE")
SYS_OP_MAP_NONNULL("COMPANY_ID") SYS_OP_MAP_NONNULL("COST_CENTER_ID") SYS_OP_MAP_NONNULL("NATURAL_ACCOUNT_ID") SYS_OP_MAP_NONNULL("USER_DIM1_ID") SYS_OP_MAP_NONNULL("USER_DIM2_ID") SYS_OP_MAP_NONNULL("ASSET_CAT_ID") SYS_OP_MAP_NONNULL("ASSET_CAT_MAJOR_ID") SYS_OP_MAP_NONNULL("ASSET_CAT_MINOR_ID") SYS_OP_MAP_NONNULL("LEDGER_ID") SYS_OP_MAP_NONNULL("ENT_YEAR_ID") SYS_OP_MAP_NONNULL("ENT_QTR_ID") SYS_OP_MAP_NONNULL("ENT_PERIOD_ID") SYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN") SYS_OP_MAP_NONNULL("GID") |
FII_FA_EXP_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
COMPANY_ID LEDGER_ID COST_CENTER_ID NATURAL_ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENT_YEAR_ID | NUMBER | |||
ENT_QTR_ID | NUMBER | |||
ENT_PERIOD_ID | NUMBER | |||
REPORT_DATE_JULIAN | NUMBER | |||
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
TOT_AMOUNT_T | NUMBER | |||
TOT_AMOUNT_TC | NUMBER | |||
TOT_AMOUNT_B | NUMBER | |||
TOT_AMOUNT_BC | NUMBER | |||
TOT_PRIM_AMOUNT_G | NUMBER | |||
TOT_PRIM_AMOUNT_GC | NUMBER | |||
TOT_SEC_AMOUNT_G | NUMBER | |||
TOT_SEC_AMOUNT_GC | NUMBER | |||
COMPANY_ID | NUMBER | (15) | ||
COST_CENTER_ID | NUMBER | (15) | ||
NATURAL_ACCOUNT_ID | NUMBER | (15) | ||
USER_DIM1_ID | NUMBER | (15) | ||
USER_DIM2_ID | NUMBER | (15) | ||
ASSET_CAT_ID | NUMBER | (15) | ||
ASSET_CAT_MAJOR_ID | NUMBER | (15) | ||
ASSET_CAT_MINOR_ID | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
GID | NUMBER | |||
CNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, REPORT_DATE_JULIAN
, TIME_ID
, PERIOD_TYPE_ID
, CURRENCY_CODE
, TOT_AMOUNT_T
, TOT_AMOUNT_TC
, TOT_AMOUNT_B
, TOT_AMOUNT_BC
, TOT_PRIM_AMOUNT_G
, TOT_PRIM_AMOUNT_GC
, TOT_SEC_AMOUNT_G
, TOT_SEC_AMOUNT_GC
, COMPANY_ID
, COST_CENTER_ID
, NATURAL_ACCOUNT_ID
, USER_DIM1_ID
, USER_DIM2_ID
, ASSET_CAT_ID
, ASSET_CAT_MAJOR_ID
, ASSET_CAT_MINOR_ID
, LEDGER_ID
, GID
, CNT
FROM APPS.FII_FA_EXP_MV;
APPS.FII_FA_EXP_MV does not reference any database object
APPS.FII_FA_EXP_MV is referenced by following:
|
|
|