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

MATERIALIZED VIEW: APPS.ENI_DBI_GL_BASE_SUM_C_MV

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

ENI_DBI_GL_BASE_SUM_MV
     ENI_DBI_GL_BASE_MV
          FII_COM_CC_MAPPINGS
          FII_FIN_CAT_TYPE_ASSGNS
          FII_GL_JE_SUMMARY_B
     ENI_DENORM_HIERARCHIES
ENI_DENORM_HIERARCHIES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
PARENT_PROD_CAT_ID NUMBER

Parent Product Category Id
CHILD_PROD_CAT_ID NUMBER

Child Product Category ID. References id in ENI_ITEM_VBH_NODES_V
TIME_ID NUMBER

time_id references time_id in FII_TIME_RPT_STRUCT_V view
PRIM_ACTUAL_G NUMBER

Other Expense Amount in the Global Currency
CNT_PRIM_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
SEC_ACTUAL_G NUMBER

Other Expense Amount in the Secondary Currency
CNT_SEC_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
COUNT(*) NUMBER

Dummy column to make the MView fast refreshable
MARKER NUMBER

marker identifies the top level product_category summarization and child level summarizations
Query Text

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


SELECT PARENT_PROD_CAT_ID
,      CHILD_PROD_CAT_ID
,      TIME_ID
,      PRIM_ACTUAL_G
,      CNT_PRIM_ACTUAL_G
,      SEC_ACTUAL_G
,      CNT_SEC_ACTUAL_G
,      COUNT(*)
,      MARKER
FROM APPS.ENI_DBI_GL_BASE_SUM_C_MV;

Dependencies

[top of page]

APPS.ENI_DBI_GL_BASE_SUM_C_MV references the following:

SchemaAPPS
TableENI_DBI_GL_BASE_SUM_C_MV
TableENI_DBI_GL_BASE_SUM_MV
Materialized ViewENI_DBI_GL_BASE_SUM_MV
SchemaENI
TableENI_DENORM_HIERARCHIES

APPS.ENI_DBI_GL_BASE_SUM_C_MV is not referenced by any database object