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

MATERIALIZED VIEW: APPS.AMS_ACT_METRICS_WEEKLY_MV

Object Details
Object Name: AMS_ACT_METRICS_WEEKLY_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: AMS_ACT_METRICS_WEEKLY_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: NONE
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

AMS_ACT_METRIC_HST

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER
Yes From ozf_time_week.week_id
START_DATE DATE
Yes First date of time period
END_DATE DATE
Yes Last date of time period
OBJECT_TYPE VARCHAR2 (30)
Marketing object type code
OBJECT_ID NUMBER

Marketing object-s unique id
METRIC_VALUE NUMBER

Value at the last day of the Period
METRIC_ID NUMBER
Yes Metric being tracked
Query Text

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


SELECT TIME_ID
,      START_DATE
,      END_DATE
,      OBJECT_TYPE
,      OBJECT_ID
,      METRIC_VALUE
,      METRIC_ID
FROM APPS.AMS_ACT_METRICS_WEEKLY_MV;

Dependencies

[top of page]

APPS.AMS_ACT_METRICS_WEEKLY_MV references the following:

SchemaAMS
TableAMS_ACT_METRIC_HST
SchemaAPPS
TableAMS_ACT_METRICS_WEEKLY_MV
SynonymAMS_ACT_METRIC_HST
SynonymOZF_TIME_WEEK
SchemaOZF
TableOZF_TIME_WEEK

APPS.AMS_ACT_METRICS_WEEKLY_MV is not referenced by any database object