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

TABLE: APPS.ENI_DBI_GL_BASE_SUM_MV

Object Details
Object Name: ENI_DBI_GL_BASE_SUM_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableENI.ENI_DBI_GL_BASE_SUM_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENI_DBI_GL_BASE_SUM_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnMARKER
ColumnGID
ColumnTIME_ID
ColumnPRODUCT_CATEGORY_ID
ColumnLINE_OF_BUSINESS_ID
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 does not reference any database object

APPS.ENI_DBI_GL_BASE_SUM_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_GL_BASE_SUM_C_MV
Materialized ViewENI_DBI_GL_BASE_SUM_MV