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

MATERIALIZED VIEW: APPS.ENI_DBI_AR_BASE_MV

Object Details
Object Name: ENI_DBI_AR_BASE_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ENI_DBI_AR_BASE_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_OLTP_ITEM_STAR
FII_AR_REVENUE_B
FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
PERIOD_TYPE_ID NUMBER

Period type id
REPORT_DATE_JULIAN NUMBER

Report Date
ENT_QTR_ID NUMBER

Quarter id
ENT_PERIOD_ID NUMBER

Period id
WEEK_ID NUMBER

Week id
ENT_YEAR_ID NUMBER

Year id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
ORGANIZATION_ID NUMBER

Organization id
COUNT(*) NUMBER

REV_PRIM_ACTUAL_G NUMBER

Revenue of the item-org on report_date in Primary Currency
COUNT_REV_PRIM_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_ACTUAL_G NUMBER

Revenue of the item-org on report_date in Secondary Currency
COUNT_REV_SEC_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
GID NUMBER

group id
Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      REPORT_DATE_JULIAN
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      ENT_YEAR_ID
,      PRODUCT_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COUNT(*)
,      REV_PRIM_ACTUAL_G
,      COUNT_REV_PRIM_ACTUAL_G
,      REV_SEC_ACTUAL_G
,      COUNT_REV_SEC_ACTUAL_G
,      GID
FROM APPS.ENI_DBI_AR_BASE_MV;

Dependencies

[top of page]

APPS.ENI_DBI_AR_BASE_MV references the following:

SchemaAPPS
TableENI_DBI_AR_BASE_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_AR_REVENUE_B
TableFII_TIME_DAY
APPS.ENI_DBI_AR_BASE_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_PRC_UNION_MV