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

MATERIALIZED VIEW: APPS.FII_GL_MGMT_CCC_MV

Object Details
Object Name: FII_GL_MGMT_CCC_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_GL_MGMT_CCC_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_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
COST_CENTER_ORG_ID NUMBER (15)
Cost Center Organization 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
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
,      COST_CENTER_ORG_ID
,      ACTUAL_B
,      PRIM_ACTUAL_G
,      SEC_ACTUAL_G
,      LINE_OF_BUSINESS_ID
,      PARENT_FIN_CATEGORY_ID
,      FIN_CATEGORY_ID
,      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_CCC_MV;

Dependencies

[top of page]

APPS.FII_GL_MGMT_CCC_MV references the following:

SchemaAPPS
TableFII_GL_BASE_MV
Materialized ViewFII_GL_BASE_MV
TableFII_GL_MGMT_CCC_MV
SchemaFII
TableFII_FIN_ITEM_HIERARCHIES
APPS.FII_GL_MGMT_CCC_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_GL_MGMT_SUM_MV