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
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
|
|
|