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

MATERIALIZED VIEW: APPS.FII_GL_MGMT_PRD_MV

Object Details
Object Name: FII_GL_MGMT_PRD_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_GL_MGMT_PRD_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_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
PRODUCT_CATEGORY_ID NUMBER (15)
Product Category Identifier
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
PRIM_ACTUAL_G NUMBER

Actual amounts in primary global currency
SEC_ACTUAL_G NUMBER

Actual amounts in secondary global currency
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
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
,      PRODUCT_CATEGORY_ID
,      FIN_CATEGORY_ID
,      PRIM_ACTUAL_G
,      SEC_ACTUAL_G
,      PRIM_BUDGET_G
,      SEC_BUDGET_G
,      PRIM_FORECAST_G
,      SEC_FORECAST_G
,      PRIM_ACTUAL_GCT
,      SEC_ACTUAL_GCT
,      PRIM_BUDGET_GCT
,      SEC_BUDGET_GCT
,      PRIM_FORECAST_GCT
,      SEC_FORECAST_GCT
,      CT
FROM APPS.FII_GL_MGMT_PRD_MV;

Dependencies

[top of page]

APPS.FII_GL_MGMT_PRD_MV references the following:

SchemaAPPS
TableFII_GL_BASE_MV
Materialized ViewFII_GL_BASE_MV
TableFII_GL_MGMT_PRD_MV

APPS.FII_GL_MGMT_PRD_MV is not referenced by any database object