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

MATERIALIZED VIEW: APPS.AMS_ACT_METRICS_MONTHLY_MV

Object Details
Object Name: AMS_ACT_METRICS_MONTHLY_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: AMS_ACT_METRICS_MONTHLY_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_day.month_id
START_DATE DATE

First date of time period
END_DATE DATE

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_MONTHLY_MV;

Dependencies

[top of page]

APPS.AMS_ACT_METRICS_MONTHLY_MV references the following:

SchemaAMS
TableAMS_ACT_METRIC_HST
SchemaAPPS
TableAMS_ACT_METRICS_MONTHLY_MV
SynonymAMS_ACT_METRIC_HST
SynonymOZF_TIME_DAY
SchemaOZF
TableOZF_TIME_DAY

APPS.AMS_ACT_METRICS_MONTHLY_MV is not referenced by any database object