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

MATERIALIZED VIEW: APPS.ENI_DBI_PRC_SUM1_MV

Object Details
Object Name: ENI_DBI_PRC_SUM1_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ENI_DBI_PRC_SUM1_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:

ENI_DBI_PRC_UNION_MV
     ENI_DBI_AR_BASE_MV
          ENI_OLTP_ITEM_STAR
          FII_AR_REVENUE_B
          FII_TIME_DAY
     ENI_DBI_COGS_BASE_MV
          FII_TIME_DAY
          OPI_DBI_COGS_F
     ENI_DBI_GL_BASE_MV
          FII_COM_CC_MAPPINGS
          FII_FIN_CAT_TYPE_ASSGNS
          FII_GL_JE_SUMMARY_B
     ENI_DBI_ORG_MV
          MTL_PARAMETERS
     ENI_OLTP_ITEM_STAR

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
ORGANIZATION_ID NUMBER

Organization id
ITEM_ORG_ID VARCHAR2 (81)
Item-org id
REV_AMOUNT NUMBER

Revenue for organization item in Primary Currency
CNT_REV_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_AMOUNT NUMBER

Revenue for organization item in Secondary Currency
CNT_REV_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
EXP_AMOUNT NUMBER

Other Expenses for oganization item in Primary Currency
CNT_EXP_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
EXP_SEC_AMOUNT NUMBER

Other Expenses for organization item in Secondary Currency
CNT_EXP_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COGS_AMOUNT NUMBER

Cost Of Goods Sold for organization in Primary Currency
CNT_COGS_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COGS_SEC_AMOUNT NUMBER

Cost Of Goods Sold for organization item in Secondary Currency
CNT_COGS_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COUNT(*) NUMBER

Dummy column to make materialized view fast refreshable
Query Text

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


SELECT TIME_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_CATEGORY_ID
,      ORGANIZATION_ID
,      ITEM_ORG_ID
,      REV_AMOUNT
,      CNT_REV_AMOUNT
,      REV_SEC_AMOUNT
,      CNT_REV_SEC_AMOUNT
,      EXP_AMOUNT
,      CNT_EXP_AMOUNT
,      EXP_SEC_AMOUNT
,      CNT_EXP_SEC_AMOUNT
,      COGS_AMOUNT
,      CNT_COGS_AMOUNT
,      COGS_SEC_AMOUNT
,      CNT_COGS_SEC_AMOUNT
,      COUNT(*)
FROM APPS.ENI_DBI_PRC_SUM1_MV;

Dependencies

[top of page]

APPS.ENI_DBI_PRC_SUM1_MV references the following:

SchemaAPPS
TableENI_DBI_PRC_SUM1_MV
TableENI_DBI_PRC_UNION_MV
Materialized ViewENI_DBI_PRC_UNION_MV
APPS.ENI_DBI_PRC_SUM1_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_PRC_SUM2_MV