VIEW: APPS.DDR_TIME_ADVR_PRD_V

Source

View Text - Preformatted

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