select y.ROWID BYR_ROWID
, c.ROWID CAL_ROWID
, t.ROWID YR_TRANS_ROWID
, y.MFG_ORG_CD
, y.CLNDR_CD
, c.CLNDR_DESC
, c.ORG_CD
, y.BSNS_YR_ID
, y.YR_CD
, y.YR_DESC
, y.YR_NBR
, y.YR_STRT_DT
, y.YR_END_DT
, y.YR_TIMESPN
, t.LAST_YR_ID
from DDR_R_BSNS_YR y
, DDR_R_CLNDR c
, DDR_R_YR_TRANS t
where c.MFG_ORG_CD = y.MFG_ORG_CD
and c.CLNDR_CD = y.CLNDR_CD
and y.BSNS_YR_ID = t.YR_ID
and y.CLNDR_CD = t.CLNDR_CD
SELECT Y.ROWID BYR_ROWID
, C.ROWID CAL_ROWID
, T.ROWID YR_TRANS_ROWID
, Y.MFG_ORG_CD
, Y.CLNDR_CD
, C.CLNDR_DESC
, C.ORG_CD
, Y.BSNS_YR_ID
, Y.YR_CD
, Y.YR_DESC
, Y.YR_NBR
, Y.YR_STRT_DT
, Y.YR_END_DT
, Y.YR_TIMESPN
, T.LAST_YR_ID
FROM DDR_R_BSNS_YR Y
, DDR_R_CLNDR C
, DDR_R_YR_TRANS T
WHERE C.MFG_ORG_CD = Y.MFG_ORG_CD
AND C.CLNDR_CD = Y.CLNDR_CD
AND Y.BSNS_YR_ID = T.YR_ID
AND Y.CLNDR_CD = T.CLNDR_CD
|
|
|