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, 'CLNDR' CLNDR_CD, 'CLNDR' CLNDR_TYP, MFG_ORG.ORG_CD ORG_CD 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,DDR_R_ORG MFG_ORG 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 AND MFG_ORG.ORG_TYP='MFG'

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
, 'CLNDR' CLNDR_CD
, 'CLNDR' CLNDR_TYP
, MFG_ORG.ORG_CD ORG_CD
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
, DDR_R_ORG MFG_ORG
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
AND MFG_ORG.ORG_TYP='MFG'