MATERIALIZED VIEW: APPS.DDR_R_BSNS_WK_DN_MV

Source

select   w.ROWID BWK_ROWID
,        m.ROWID BMNTH_ROWID
,        q.ROWID BQTR_ROWID
,        y.ROWID BYR_ROWID
,        c.ROWID CAL_ROWID
,        t.ROWID WK_TRANS_ROWID
,        y.MFG_ORG_CD
,        y.CLNDR_CD
,        c.ORG_CD
,        c.CLNDR_DESC
,        w.BSNS_WK_ID
,        w.WK_DESC
,        w.WK_NBR
,        w.WK_CD
,        w.WK_STRT_DT
,        w.WK_END_DT
,        w.WK_TIMESPN
,        t.LAST_YR_THIS_WK_ID
,        t.LAST_WK_THIS_YR_ID
,        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_NBR
,        q.QTR_CD
,        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_BSNS_WK   w
,        DDR_R_BSNS_MNTH m
,        DDR_R_BSNS_QTR  q
,        DDR_R_BSNS_YR   y
,        DDR_R_CLNDR     c
,        DDR_R_WK_TRANS  t
where   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     w.BSNS_WK_ID = t.WK_ID
and     w.CLNDR_CD = t.CLNDR_CD