VIEW: APPS.DDR_TIME_ADVR_WK_V

Source

View Text - Preformatted

SELECT AWK.MFG_ORG_CD,CLNDR.ORG_CD,AWK.CLNDR_CD,CLNDR.CLNDR_DESC,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_ADVR_WK AWK,DDR_R_ADVR_PRD APRD,DDR_R_ADVR_QTR AQTR,DDR_R_ADVR_YR AYR,DDR_R_CLNDR CLNDR WHERE 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 AWK.MFG_ORG_CD
, CLNDR.ORG_CD
, AWK.CLNDR_CD
, CLNDR.CLNDR_DESC
, 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_ADVR_WK AWK
, DDR_R_ADVR_PRD APRD
, DDR_R_ADVR_QTR AQTR
, DDR_R_ADVR_YR AYR
, DDR_R_CLNDR CLNDR
WHERE 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