eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.DDR_R_CLNDR_PRD_DRTN_DN_MV

Object Details

Object Name:	DDR_R_CLNDR_PRD_DRTN_DN_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	DDR_R_CLNDR_PRD_DRTN_DN_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	TEXTMATCH
Refresh Mode:	DEMAND
Refresh Method:	FORCE
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


DDR_R_CLNDR_MNTH
DDR_R_CLNDR_QTR
DDR_R_CLNDR_WK
DDR_R_CLNDR_YR
DDR_R_DAY
DDR_R_MNTH_TODATE_TRANS
DDR_R_QTR_TODATE_TRANS
DDR_R_WK_TODATE_TRANS

[View Source Query]

Columns

Name	Datatype	Length
PRD_CD	VARCHAR2	(30)
PRD_ID	NUMBER
PRD_TYP	NUMBER
PRD_DRTN	NUMBER
PRD_DRTN_YTD	NUMBER
CNT_PRD_DRTN_YTD	NUMBER
CNT_TOTAL	NUMBER
PRD_ROWID	ROWID	(10)

Query Text

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


SELECT PRD_CD
,      PRD_ID
,      PRD_TYP
,      PRD_DRTN
,      PRD_DRTN_YTD
,      CNT_PRD_DRTN_YTD
,      CNT_TOTAL
,      PRD_ROWID
FROM APPS.DDR_R_CLNDR_PRD_DRTN_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_CLNDR_PRD_DRTN_DN_MV references the following:

APPS: DDR_R_CLNDR_PRD_DRTN_DN_MV
DDR: DDR_R_CLNDR_MNTH; DDR_R_CLNDR_QTR; DDR_R_CLNDR_WK; DDR_R_CLNDR_YR; DDR_R_DAY; DDR_R_MNTH_TODATE_TRANS; DDR_R_QTR_TODATE_TRANS; DDR_R_WK_TODATE_TRANS

APPS.DDR_R_CLNDR_PRD_DRTN_DN_MV is not referenced by any database object