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

MATERIALIZED VIEW: APPS.IBW_PAGE_SA_TIME_MV

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

FII_TIME_DAY
IBW_PAGE_SA_MV
     IBW_PAGES_B
     IBW_PAGE_PRODUCT_MV
          IBW_PAGE_VIEWS
     IBW_SITE_VISITS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SITE_ID NUMBER (15)
TRANSACTION_DATE DATE

PAGE_INSTANCE_ID NUMBER (15)
SITE_AREA_ID NUMBER (15)
VISITANT_ID VARCHAR2 (256)
VISIT_ID NUMBER

PAGE_VIEWS NUMBER

PAGE_VIEW_DURATION NUMBER

D_PAGE_VIEWS NUMBER

D_PAGE_VIEW_DURATION_CNT NUMBER

GROUPING_SETS_ID NUMBER

TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

ENT_YEAR_ID NUMBER

ENT_QTR_ID NUMBER

ENT_PERIOD_ID NUMBER

REPORT_DATE_JULIAN NUMBER

WEEK_ID NUMBER

D_GID NUMBER

D_TOT NUMBER

Query Text

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


SELECT SITE_ID
,      TRANSACTION_DATE
,      PAGE_INSTANCE_ID
,      SITE_AREA_ID
,      VISITANT_ID
,      VISIT_ID
,      PAGE_VIEWS
,      PAGE_VIEW_DURATION
,      D_PAGE_VIEWS
,      D_PAGE_VIEW_DURATION_CNT
,      GROUPING_SETS_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      REPORT_DATE_JULIAN
,      WEEK_ID
,      D_GID
,      D_TOT
FROM APPS.IBW_PAGE_SA_TIME_MV;

Dependencies

[top of page]

APPS.IBW_PAGE_SA_TIME_MV references the following:

SchemaAPPS
TableIBW_PAGE_SA_MV
Materialized ViewIBW_PAGE_SA_MV
TableIBW_PAGE_SA_TIME_MV
SchemaFII
TableFII_TIME_DAY

APPS.IBW_PAGE_SA_TIME_MV is not referenced by any database object