VIEW: APPS.DDR_TIME_PLNG_DAY_V

Source

View Text - Preformatted

SELECT BDAY.MFG_ORG_CD,CLNDR.ORG_CD,BDAY.CLNDR_CD,CLNDR.CLNDR_DESC,BDAY.DAY_CD,BDAY.DAY_OF_YR,BDAY.WKEND_IND,BDAY.CLNDR_STRT_DT,BDAY.CLNDR_END_DT,PWK.PLNG_WK_ID,PWK.WK_CD,PWK.WK_NBR,PWK.WK_DESC,PWK.WK_STRT_DT,PWK.WK_END_DT,PWK.WK_TIMESPN,PPRD.PLNG_PRD_ID,PPRD.PRD_CD,PPRD.PRD_NBR,PPRD.PRD_DESC,PPRD.PRD_STRT_DT,PPRD.PRD_END_DT,PPRD.PRD_TIMESPN,PQTR.PLNG_QTR_ID,PQTR.QTR_CD,PQTR.QTR_NBR,PQTR.QTR_DESC,PQTR.QTR_STRT_DT,PQTR.QTR_END_DT,PQTR.QTR_TIMESPN,PYR.PLNG_YR_ID,PYR.YR_CD,PYR.YR_NBR,PYR.YR_DESC,PYR.YR_STRT_DT,PYR.YR_END_DT,PYR.YR_TIMESPN FROM DDR_R_BASE_DAY BDAY,DDR_R_PLNG_WK PWK,DDR_R_PLNG_PRD PPRD,DDR_R_PLNG_QTR PQTR,DDR_R_PLNG_YR PYR,DDR_R_CLNDR CLNDR WHERE BDAY.WK_ID = PWK.PLNG_WK_ID AND BDAY.CLNDR_TYP = 'PLNG' AND PWK.PLNG_PRD_ID = PPRD.PLNG_PRD_ID AND PPRD.PLNG_QTR_ID = PQTR.PLNG_QTR_ID AND PQTR.PLNG_YR_ID = PYR.PLNG_YR_ID AND PYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD AND PYR.CLNDR_CD = CLNDR.CLNDR_CD

View Text - HTML Formatted

SELECT BDAY.MFG_ORG_CD
, CLNDR.ORG_CD
, BDAY.CLNDR_CD
, CLNDR.CLNDR_DESC
, BDAY.DAY_CD
, BDAY.DAY_OF_YR
, BDAY.WKEND_IND
, BDAY.CLNDR_STRT_DT
, BDAY.CLNDR_END_DT
, PWK.PLNG_WK_ID
, PWK.WK_CD
, PWK.WK_NBR
, PWK.WK_DESC
, PWK.WK_STRT_DT
, PWK.WK_END_DT
, PWK.WK_TIMESPN
, PPRD.PLNG_PRD_ID
, PPRD.PRD_CD
, PPRD.PRD_NBR
, PPRD.PRD_DESC
, PPRD.PRD_STRT_DT
, PPRD.PRD_END_DT
, PPRD.PRD_TIMESPN
, PQTR.PLNG_QTR_ID
, PQTR.QTR_CD
, PQTR.QTR_NBR
, PQTR.QTR_DESC
, PQTR.QTR_STRT_DT
, PQTR.QTR_END_DT
, PQTR.QTR_TIMESPN
, PYR.PLNG_YR_ID
, PYR.YR_CD
, PYR.YR_NBR
, PYR.YR_DESC
, PYR.YR_STRT_DT
, PYR.YR_END_DT
, PYR.YR_TIMESPN
FROM DDR_R_BASE_DAY BDAY
, DDR_R_PLNG_WK PWK
, DDR_R_PLNG_PRD PPRD
, DDR_R_PLNG_QTR PQTR
, DDR_R_PLNG_YR PYR
, DDR_R_CLNDR CLNDR
WHERE BDAY.WK_ID = PWK.PLNG_WK_ID
AND BDAY.CLNDR_TYP = 'PLNG'
AND PWK.PLNG_PRD_ID = PPRD.PLNG_PRD_ID
AND PPRD.PLNG_QTR_ID = PQTR.PLNG_QTR_ID
AND PQTR.PLNG_YR_ID = PYR.PLNG_YR_ID
AND PYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD
AND PYR.CLNDR_CD = CLNDR.CLNDR_CD