View: JTF_TERR_SRCH_ESCL_V

Product:	JTF - CRM Foundation
Description:	View for basic escalation territory search
Implementation/DBA Data:	APPS.JTF_TERR_SRCH_ESCL_V

View Text

SELECT DISTINCT JTOVIEW.TERR_ID
, JTOVIEW.NAME
, JTOVIEW.ESCALATION_TERR_NAME
, JTOVIEW.TERR_TYPE_NAME
, JTOVIEW.TERR_USAGE
, JTRV.RESOURCE_NAME
, JTRV.RESOURCE_TYPE
FROM JTF_TERR_RESOURCES_V JTRV
, JTF_TERR_OVERVIEW_V JTOVIEW
WHERE JTOVIEW.ESCALATION_TERRITORY_FLAG = 'Y'
AND JTRV.TERR_ID (+) = JTOVIEW.TERR_ID

Columns