VIEW: APPS.DDR_TIME_ADVR_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,AWK.ADVR_WK_ID,AWK.WK_CD,AWK.WK_NBR,AWK.WK_DESC,AWK.WK_STRT_DT,AWK.WK_END_DT,AWK.WK_TIMESPN,APRD.ADVR_PRD_ID,APRD.PRD_CD,APRD.PRD_NBR,APRD.PRD_DESC,APRD.PRD_STRT_DT,APRD.PRD_END_DT,APRD.PRD_TIMESPN,AQTR.ADVR_QTR_ID,AQTR.QTR_CD,AQTR.QTR_NBR,AQTR.QTR_DESC,AQTR.QTR_STRT_DT,AQTR.QTR_END_DT,AQTR.QTR_TIMESPN,AYR.ADVR_YR_ID,AYR.YR_CD,AYR.YR_NBR,AYR.YR_DESC,AYR.YR_STRT_DT,AYR.YR_END_DT,AYR.YR_TIMESPN FROM DDR_R_BASE_DAY BDAY,DDR_R_ADVR_WK AWK,DDR_R_ADVR_PRD APRD,DDR_R_ADVR_QTR AQTR,DDR_R_ADVR_YR AYR,DDR_R_CLNDR CLNDR WHERE BDAY.WK_ID = AWK.ADVR_WK_ID AND BDAY.CLNDR_TYP = 'ADVR' AND AWK.ADVR_PRD_ID = APRD.ADVR_PRD_ID AND APRD.ADVR_QTR_ID = AQTR.ADVR_QTR_ID AND AQTR.ADVR_YR_ID = AYR.ADVR_YR_ID AND AYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD AND AYR.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
, AWK.ADVR_WK_ID
, AWK.WK_CD
, AWK.WK_NBR
, AWK.WK_DESC
, AWK.WK_STRT_DT
, AWK.WK_END_DT
, AWK.WK_TIMESPN
, APRD.ADVR_PRD_ID
, APRD.PRD_CD
, APRD.PRD_NBR
, APRD.PRD_DESC
, APRD.PRD_STRT_DT
, APRD.PRD_END_DT
, APRD.PRD_TIMESPN
, AQTR.ADVR_QTR_ID
, AQTR.QTR_CD
, AQTR.QTR_NBR
, AQTR.QTR_DESC
, AQTR.QTR_STRT_DT
, AQTR.QTR_END_DT
, AQTR.QTR_TIMESPN
, AYR.ADVR_YR_ID
, AYR.YR_CD
, AYR.YR_NBR
, AYR.YR_DESC
, AYR.YR_STRT_DT
, AYR.YR_END_DT
, AYR.YR_TIMESPN
FROM DDR_R_BASE_DAY BDAY
, DDR_R_ADVR_WK AWK
, DDR_R_ADVR_PRD APRD
, DDR_R_ADVR_QTR AQTR
, DDR_R_ADVR_YR AYR
, DDR_R_CLNDR CLNDR
WHERE BDAY.WK_ID = AWK.ADVR_WK_ID
AND BDAY.CLNDR_TYP = 'ADVR'
AND AWK.ADVR_PRD_ID = APRD.ADVR_PRD_ID
AND APRD.ADVR_QTR_ID = AQTR.ADVR_QTR_ID
AND AQTR.ADVR_YR_ID = AYR.ADVR_YR_ID
AND AYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD
AND AYR.CLNDR_CD = CLNDR.CLNDR_CD