MATERIALIZED VIEW: APPS.DDR_R_BASE_DAY_DN_MV

Source

select   d.ROWID DAY_ROWID
,        bd.ROWID BDAY_ROWID
,        w.ROWID BWK_ROWID
,        m.ROWID BMNTH_ROWID
,        q.ROWID BQTR_ROWID
,        y.ROWID BYR_ROWID
,        c.ROWID CAL_ROWID
,        t.ROWID DAY_TRANS_ROWID
,        y.MFG_ORG_CD
,        y.CLNDR_CD
,        c.ORG_CD
,        c.CLNDR_DESC
,        bd.DAY_CD
,        bd.BASE_DAY_ID
,        d.CLNDR_DT
,        d.CLNDR_DT_DESC
,        bd.DAY_OF_YR
,        bd.WKEND_IND
,        t.LAST_YR_THIS_DAY_CD
,        t.LAST_DAY_THIS_YR_CD
,        w.BSNS_WK_ID
,        w.WK_DESC
,        w.WK_CD
,        w.WK_NBR
,        w.WK_STRT_DT
,        w.WK_END_DT
,        w.WK_TIMESPN
,        m.BSNS_MNTH_ID
,        m.MNTH_DESC
,        m.MNTH_CD
,        m.MNTH_STRT_DT
,        m.MNTH_END_DT
,        m.MNTH_NBR
,        m.MNTH_TIMESPN
,        q.BSNS_QTR_ID
,        q.QTR_DESC
,        q.QTR_CD
,        q.QTR_NBR
,        q.QTR_STRT_DT
,        q.QTR_END_DT
,        q.QTR_TIMESPN
,        y.BSNS_YR_ID
,        y.YR_DESC
,        y.YR_NBR
,        y.YR_CD
,        y.YR_STRT_DT
,        y.YR_END_DT
,        y.YR_TIMESPN
from     DDR_R_DAY       d
,        DDR_R_BASE_DAY  bd
,        DDR_R_BSNS_WK   w
,        DDR_R_BSNS_MNTH m
,        DDR_R_BSNS_QTR  q
,        DDR_R_BSNS_YR   y
,        DDR_R_CLNDR     c
,        DDR_R_DAY_TRANS t
where   bd.DAY_CD = d.DAY_CD
and     bd.WK_ID = w.BSNS_WK_ID
and     bd.CLNDR_TYP = 'BSNS'
and     w.BSNS_MNTH_ID = m.BSNS_MNTH_ID
and     m.BSNS_QTR_ID = q.BSNS_QTR_ID
and     q.BSNS_YR_ID = y.BSNS_YR_ID
and     c.MFG_ORG_CD = y.MFG_ORG_CD
and     c.CLNDR_CD = y.CLNDR_CD
and     bd.DAY_CD = t.DAY_CD
and     bd.CLNDR_CD = t.CLNDR_CD