SELECT TERR_ID , NAME , DESCRIPTION , START_DATE_ACTIVE , END_DATE_ACTIVE FROM JTF_TERR_ALL WHERE TERR_ID IN ( SELECT TERR_ID FROM JTF_TERR_RSC_ALL JTR , JTF_TERR_RSC_ACCESS_ALL JTRA WHERE JTR.TERR_RSC_ID = JTRA.TERR_RSC_ID AND JTRA.TRANS_ACCESS_CODE = 'ESC_OWNER' )