View: JTY_ESCALATION_TERRITORIES_V

Product:	JTF - CRM Foundation
Description:	Escalation Territories
Implementation/DBA Data:	APPS.JTY_ESCALATION_TERRITORIES_V

View Text

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

Columns