[Home] [Help] [Dependency Information]
Object Name: | FII_FA_EXP_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | FII_FA_EXP_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
FII_FA_EXP_F
FII_TIME_DAY
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 is not referenced by any database object
|
|
|