VIEW: APPS.JTY_ESCALATION_TERRITORIES_V

Source

View Text - Preformatted

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' )

View Text - HTML Formatted

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' )