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

MATERIALIZED VIEW: APPS.ENI_DBI_GL_BASE_SUM_MV

Object Details
Object Name: ENI_DBI_GL_BASE_SUM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ENI_DBI_GL_BASE_SUM_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_MV
     FII_COM_CC_MAPPINGS
     FII_FIN_CAT_TYPE_ASSGNS
     FII_GL_JE_SUMMARY_B
ENI_DENORM_HIERARCHIES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

time_id references time_id in FII_TIME_RPT_STRUCT_V view
LINE_OF_BUSINESS_ID NUMBER

line_of_business_id references id in FII_LOB_V view
PRODUCT_CATEGORY_ID NUMBER

Product Category ID. product_category_id references parent_id in ENI_DENORM_HIERARCHIES
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 MView fast refreshable
GID NUMBER

GROUPING SET value of various combination of time_id, product_category_id, line_of_business_id
MARKER NUMBER

marker identifies the row summarized based on time_id, product_category_id or line_of_business_id
Query Text

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


SELECT TIME_ID
,      LINE_OF_BUSINESS_ID
,      PRODUCT_CATEGORY_ID
,      PRIM_ACTUAL_G
,      CNT_PRIM_ACTUAL_G
,      SEC_ACTUAL_G
,      CNT_SEC_ACTUAL_G
,      COUNT(*)
,      GID
,      MARKER
FROM APPS.ENI_DBI_GL_BASE_SUM_MV;

Dependencies

[top of page]

APPS.ENI_DBI_GL_BASE_SUM_MV references the following:

SchemaAPPS
TableENI_DBI_GL_BASE_MV
Materialized ViewENI_DBI_GL_BASE_MV
TableENI_DBI_GL_BASE_SUM_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
APPS.ENI_DBI_GL_BASE_SUM_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_GL_BASE_SUM_C_MV