[Home] [Help]
View: JTF_TERR_SRCH_ADV_ESCL_V
View Text
SELECT DISTINCT JTOVIEW.TERR_ID
, JTOVIEW.NAME
, JTOVIEW.ESCALATION_TERR_NAME
, JTOVIEW.TERR_TYPE_NAME
, JTOVIEW.TERR_USAGE
, JTOVIEW.START_DATE_ACTIVE
, JTOVIEW.END_DATE_ACTIVE
, JTRV.RESOURCE_NAME
, JTRV.RESOURCE_TYPE
, JTQV.QUALIFIER_NAME
, JTQV.QUAL_USG_ID
FROM JTF_TERR_QUALIFIERS_V JTQV
, JTF_TERR_RESOURCES_V JTRV
, JTF_TERR_OVERVIEW_V JTOVIEW
WHERE JTOVIEW.ESCALATION_TERRITORY_FLAG = 'Y'
AND JTQV.TERR_ID (+) = JTOVIEW.TERR_ID
AND JTRV.TERR_ID (+) = JTOVIEW.TERR_ID
Columns
Name |
TERR_ID |
NAME |
ESCALATION_TERR_NAME |
TERR_TYPE_NAME |
TERR_USAGE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
RESOURCE_NAME |
RESOURCE_TYPE |
QUALIFIER_NAME |
QUAL_USG_ID |