VIEW: APPS.DDR_R_BSNS_MNTH_DN_MV#

Source

View Text - Preformatted

select   m.ROWID BMNTH_ROWID
,        q.ROWID BQTR_ROWID
,        y.ROWID BYR_ROWID
,        c.ROWID CAL_ROWID
,        t.ROWID MNTH_TRANS_ROWID
,        y.MFG_ORG_CD
,        y.CLNDR_CD
,        c.ORG_CD
,        c.CLNDR_DESC
,        m.BSNS_MNTH_ID
,        m.MNTH_DESC
,        m.MNTH_CD
,        m.MNTH_STRT_DT
,        m.MNTH_END_DT
,        m.MNTH_NBR
,        m.MNTH_TIMESPN
,        t.LAST_YR_THIS_MNTH_ID
,        t.LAST_MNTH_THIS_YR_ID
,        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_MNTH   m
,        DDR_R_BSNS_QTR    q
,        DDR_R_BSNS_YR     y
,        DDR_R_CLNDR       c
,        DDR_R_MNTH_TRANS  t
where   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     m.BSNS_MNTH_ID = t.MNTH_ID
and     m.CLNDR_CD = t.CLNDR_CD

View Text - HTML Formatted

SELECT M.ROWID BMNTH_ROWID
, Q.ROWID BQTR_ROWID
, Y.ROWID BYR_ROWID
, C.ROWID CAL_ROWID
, T.ROWID MNTH_TRANS_ROWID
, Y.MFG_ORG_CD
, Y.CLNDR_CD
, C.ORG_CD
, C.CLNDR_DESC
, M.BSNS_MNTH_ID
, M.MNTH_DESC
, M.MNTH_CD
, M.MNTH_STRT_DT
, M.MNTH_END_DT
, M.MNTH_NBR
, M.MNTH_TIMESPN
, T.LAST_YR_THIS_MNTH_ID
, T.LAST_MNTH_THIS_YR_ID
, 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_MNTH M
, DDR_R_BSNS_QTR Q
, DDR_R_BSNS_YR Y
, DDR_R_CLNDR C
, DDR_R_MNTH_TRANS T WHERE 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 M.BSNS_MNTH_ID = T.MNTH_ID AND M.CLNDR_CD = T.CLNDR_CD