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

MATERIALIZED VIEW: APPS.DDR_R_PRD_DRTN_DN_MV

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

DDR_R_BASE_DAY
DDR_R_BASE_DAY
DDR_R_BSNS_MNTH
DDR_R_BSNS_MNTH
DDR_R_BSNS_QTR
DDR_R_BSNS_QTR
DDR_R_BSNS_WK
DDR_R_BSNS_WK
DDR_R_BSNS_YR
DDR_R_BSNS_YR
DDR_R_MNTH_TODATE_TRANS
DDR_R_MNTH_TODATE_TRANS
DDR_R_QTR_TODATE_TRANS
DDR_R_QTR_TODATE_TRANS
DDR_R_WK_TODATE_TRANS
DDR_R_WK_TODATE_TRANS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30)
CLNDR_CD VARCHAR2 (30)
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 MFG_ORG_CD
,      CLNDR_CD
,      PRD_CD
,      PRD_ID
,      PRD_TYP
,      PRD_DRTN
,      PRD_DRTN_YTD
,      CNT_PRD_DRTN_YTD
,      CNT_TOTAL
,      PRD_ROWID
FROM APPS.DDR_R_PRD_DRTN_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_PRD_DRTN_DN_MV references the following:

SchemaAPPS
SynonymDDR_R_BASE_DAY
SynonymDDR_R_BSNS_MNTH
SynonymDDR_R_BSNS_QTR
SynonymDDR_R_BSNS_WK
SynonymDDR_R_BSNS_YR
SynonymDDR_R_MNTH_TODATE_TRANS
TableDDR_R_PRD_DRTN_DN_MV
SynonymDDR_R_QTR_TODATE_TRANS
SynonymDDR_R_WK_TODATE_TRANS
SchemaDDR
TableDDR_R_BASE_DAY
TableDDR_R_BSNS_MNTH
TableDDR_R_BSNS_QTR
TableDDR_R_BSNS_WK
TableDDR_R_BSNS_YR
TableDDR_R_MNTH_TODATE_TRANS
TableDDR_R_QTR_TODATE_TRANS
TableDDR_R_WK_TODATE_TRANS

APPS.DDR_R_PRD_DRTN_DN_MV is not referenced by any database object