Product: | JTF - CRM Foundation |
---|---|
Description: | View for basic territory search |
Implementation/DBA Data: | APPS.JTF_TERR_SRCH_MAIN_V |
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