View: JTF_TERR_SRCH_MAIN_V

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

View Text

SELECT DISTINCT JTOVIEW.TERR_ID
, JTOVIEW.NAME
, JTOVIEW.TEMPLATE_FLAG
, JTOVIEW.TEMPLATE_TERR_NAME
, JTOVIEW.ESCALATION_TERRITORY_FLAG
, JTOVIEW.ESCALATION_TERR_NAME
, JTOVIEW.TERR_TYPE_NAME
, JTOVIEW.PARENT_TERR_NAME
, JTOVIEW.START_DATE_ACTIVE
, JTOVIEW.END_DATE_ACTIVE
, 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 JTOVIEW.TEMPLATE_FLAG <> 'Y'
AND JTRV.TERR_ID (+) = JTOVIEW.TERR_ID

Columns