[Home] [Help]
View: JTF_TERR_SRCH_TEMP_V
Product: | JTF - CRM Foundation |
Description: | View for template territory search |
Implementation/DBA Data: |
APPS.JTF_TERR_SRCH_TEMP_V
|
View Text
SELECT DISTINCT JTOVIEW.TERR_ID
, JTOVIEW.NAME
, JTOVIEW.TERR_TYPE_NAME
, JTOVIEW.PARENT_TERR_NAME
, JTOVIEW.START_DATE_ACTIVE
, JTOVIEW.END_DATE_ACTIVE
, JTOVIEW.TERR_USAGE
, JTQV.QUALIFIER_NAME
FROM JTF_TERR_QUALIFIERS_V JTQV
, JTF_TERR_OVERVIEW_V JTOVIEW
WHERE JTOVIEW.TEMPLATE_FLAG = 'Y'
AND JTQV.TERR_ID (+) = JTOVIEW.TERR_ID
Columns
Name |
TERR_ID |
NAME |
TERR_TYPE_NAME |
PARENT_TERR_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
TERR_USAGE |
QUALIFIER_NAME |