View: JTF_TERR_SRCH_TYPE_V

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

View Text

SELECT DISTINCT JTTYPE.TERR_TYPE_ID
, JTTYPE.NAME
, JTTYPE.START_DATE_ACTIVE
, JTTYPE.END_DATE_ACTIVE
, JTS.MEANING
, JTTQV.QUALIFIER_NAME
FROM JTF_TERR_TYPE_QUALIFIERS_V JTTQV
, JTF_TERR_TYPE_USGS JTTU
, JTF_TERR_TYPES JTTYPE
, JTF_SOURCES JTS
WHERE JTTQV.TERR_TYPE_ID (+) = JTTYPE.TERR_TYPE_ID
AND JTTU.TERR_TYPE_ID = JTTYPE.TERR_TYPE_ID
AND JTTU.SOURCE_ID = JTS.SOURCE_ID

Columns