DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.FII_GL_MGMT_SUM_MV

Object Details
Object Name: FII_GL_MGMT_SUM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_GL_MGMT_SUM_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

FII_CC_MGR_HIERARCHIES
FII_GL_MGMT_CCC_MV
     FII_FIN_ITEM_HIERARCHIES
     FII_GL_BASE_MV
          FII_BUDGET_BASE
          FII_COM_CC_MAPPINGS
          FII_FIN_CAT_MAPPINGS
          FII_FIN_CAT_TYPE_ASSGNS
          FII_GL_JE_SUMMARY_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time Identifier
PERIOD_TYPE_ID NUMBER

Period Type Identifier
MANAGER_ID NUMBER (15)
Manager Identifier
PERSON_ID NUMBER (15)
Person Identifier
ACTUAL_B NUMBER

Actual amounts in base currency
PRIM_ACTUAL_G NUMBER

Actual amounts in primary global currency
SEC_ACTUAL_G NUMBER

Actual amounts in secondary global currency
LINE_OF_BUSINESS_ID NUMBER (15)
Line of Business Identifier
PARENT_FIN_CATEGORY_ID NUMBER (15)
Parent Financial Category Identifier
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
GID NUMBER

Group Identifier
PRIM_BUDGET_G NUMBER

Budget amounts in primary global currency
SEC_BUDGET_G NUMBER

Budget amounts in secondary global currency
PRIM_FORECAST_G NUMBER

Forecast amounts in primary global currency
SEC_FORECAST_G NUMBER

Forecast amounts in secondary global currency
ACTUAL_BCT NUMBER

Internal aggregation for fast refreshable materialized view
PRIM_ACTUAL_GCT NUMBER

Internal aggregation for fast refreshable materialized view
SEC_ACTUAL_GCT NUMBER

Internal aggregation for fast refreshable materialized view
PRIM_BUDGET_GCT NUMBER

Internal aggregation for fast refreshable materialized view
SEC_BUDGET_GCT NUMBER

Internal aggregation for fast refreshable materialized view
PRIM_FORECAST_GCT NUMBER

Internal aggregation for fast refreshable materialized view
SEC_FORECAST_GCT NUMBER

Internal aggregation for fast refreshable materialized view
CT NUMBER

Internal aggregation for fast refreshable materialized view
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      MANAGER_ID
,      PERSON_ID
,      ACTUAL_B
,      PRIM_ACTUAL_G
,      SEC_ACTUAL_G
,      LINE_OF_BUSINESS_ID
,      PARENT_FIN_CATEGORY_ID
,      FIN_CATEGORY_ID
,      GID
,      PRIM_BUDGET_G
,      SEC_BUDGET_G
,      PRIM_FORECAST_G
,      SEC_FORECAST_G
,      ACTUAL_BCT
,      PRIM_ACTUAL_GCT
,      SEC_ACTUAL_GCT
,      PRIM_BUDGET_GCT
,      SEC_BUDGET_GCT
,      PRIM_FORECAST_GCT
,      SEC_FORECAST_GCT
,      CT
FROM APPS.FII_GL_MGMT_SUM_MV;

Dependencies

[top of page]

APPS.FII_GL_MGMT_SUM_MV references the following:

SchemaAPPS
TableFII_GL_MGMT_CCC_MV
Materialized ViewFII_GL_MGMT_CCC_MV
TableFII_GL_MGMT_SUM_MV
SchemaFII
TableFII_CC_MGR_HIERARCHIES

APPS.FII_GL_MGMT_SUM_MV is not referenced by any database object