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

MATERIALIZED VIEW: APPS.IBW_VST_CMP_DLYUNIQVSTR_MV

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

IBW_SITE_VISITS

[View Source Query]

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

PARTY_VISITOR_ID VARCHAR2 (256) Yes
D_GID NUMBER

D_TOTAL_CNT NUMBER

Query Text

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


SELECT SITE_ID
,      CUSTOMER_ID
,      CAMPAIGN_SOURCE_CODE_ID
,      TRANSACTION_DATE
,      PARTY_VISITOR_ID
,      D_GID
,      D_TOTAL_CNT
FROM APPS.IBW_VST_CMP_DLYUNIQVSTR_MV;

Dependencies

[top of page]

APPS.IBW_VST_CMP_DLYUNIQVSTR_MV references the following:

SchemaAPPS
TableIBW_VST_CMP_DLYUNIQVSTR_MV
SchemaIBW
TableIBW_SITE_VISITS
APPS.IBW_VST_CMP_DLYUNIQVSTR_MV is referenced by following:

SchemaAPPS
Materialized ViewIBW_CMPANALYSIS_MV
Materialized ViewIBW_VISIT_CUST_MV