SELECT CHRB.ID CHR_ID , CHRB.CONTRACT_NUMBER CONTRACT_NUMBER , CHRB.SCS_CODE SCS_CODE , CHRB.STS_CODE STATUS_CODE , 'R'||TO_CHAR(SYSDATE , 'DD-MON-YYYY HH:MI:SS') CONTRACT_NUMBER_MODIFIER , CHRB.END_DATE+1 START_DATE FROM OKC_K_HEADERS_B CHRB , OKC_K_HEADERS_TL CHRT WHERE CHRB.SCS_CODE = 'TDE_RIGHT' AND CHRB.ID = CHRT.ID AND CHRT.LANGUAGE = USERENV('LANG') AND CHRB.STS_CODE IN ('ACTIVE' , 'EXPIRED' , 'SIGNED') AND CHRB.END_DATE IS NOT NULL AND CHRB.DATE_TERMINATED IS NULL AND CHRB.TEMPLATE_YN ='N'