VIEW: APPS.DDR_TIME_CLNDR_DAY_V

Source

View Text - Preformatted

SELECT CDAY.DAY_CD,CDAY.CLNDR_DT,CDAY.CLNDR_DT_DESC,CDAY.JULIAN_DAY,CDAY.WKDAY_ID,CDAY.WK_DAY,CDAY.DAY_OF_YR,CWK.CLNDR_WK_ID,CWK.WK_CD,CWK.WK_NBR,CWK.WK_DESC,CWK.WK_STRT_DT,CWK.WK_END_DT,CWK.WK_TIMESPN,CMO.CLNDR_MNTH_ID,CMO.MNTH_CD,CMO.MNTH_NBR,CMO.MNTH_DESC,CMO.MNTH_STRT_DT,CMO.MNTH_END_DT,CMO.MNTH_TIMESPN,CQTR.CLNDR_QTR_ID,CQTR.QTR_CD,CQTR.QTR_NBR,CQTR.QTR_DESC,CQTR.QTR_STRT_DT,CQTR.QTR_END_DT,CQTR.QTR_TIMESPN,CYR.CLNDR_YR_ID,CYR.YR_CD,CYR.YR_NBR,CYR.YR_DESC,CYR.YR_STRT_DT,CYR.YR_END_DT,CYR.YR_TIMESPN FROM DDR_R_DAY CDAY,DDR_R_CLNDR_WK CWK,DDR_R_CLNDR_MNTH CMO,DDR_R_CLNDR_QTR CQTR,DDR_R_CLNDR_YR CYR WHERE CDAY.CLNDR_WK_ID = CWK.CLNDR_WK_ID(+) AND CDAY.CLNDR_MNTH_ID = CMO.CLNDR_MNTH_ID AND CMO.CLNDR_QTR_ID = CQTR.CLNDR_QTR_ID AND CQTR.CLNDR_YR_ID = CYR.CLNDR_YR_ID

View Text - HTML Formatted

SELECT CDAY.DAY_CD
, CDAY.CLNDR_DT
, CDAY.CLNDR_DT_DESC
, CDAY.JULIAN_DAY
, CDAY.WKDAY_ID
, CDAY.WK_DAY
, CDAY.DAY_OF_YR
, CWK.CLNDR_WK_ID
, CWK.WK_CD
, CWK.WK_NBR
, CWK.WK_DESC
, CWK.WK_STRT_DT
, CWK.WK_END_DT
, CWK.WK_TIMESPN
, CMO.CLNDR_MNTH_ID
, CMO.MNTH_CD
, CMO.MNTH_NBR
, CMO.MNTH_DESC
, CMO.MNTH_STRT_DT
, CMO.MNTH_END_DT
, CMO.MNTH_TIMESPN
, CQTR.CLNDR_QTR_ID
, CQTR.QTR_CD
, CQTR.QTR_NBR
, CQTR.QTR_DESC
, CQTR.QTR_STRT_DT
, CQTR.QTR_END_DT
, CQTR.QTR_TIMESPN
, CYR.CLNDR_YR_ID
, CYR.YR_CD
, CYR.YR_NBR
, CYR.YR_DESC
, CYR.YR_STRT_DT
, CYR.YR_END_DT
, CYR.YR_TIMESPN
FROM DDR_R_DAY CDAY
, DDR_R_CLNDR_WK CWK
, DDR_R_CLNDR_MNTH CMO
, DDR_R_CLNDR_QTR CQTR
, DDR_R_CLNDR_YR CYR
WHERE CDAY.CLNDR_WK_ID = CWK.CLNDR_WK_ID(+)
AND CDAY.CLNDR_MNTH_ID = CMO.CLNDR_MNTH_ID
AND CMO.CLNDR_QTR_ID = CQTR.CLNDR_QTR_ID
AND CQTR.CLNDR_YR_ID = CYR.CLNDR_YR_ID