Product: | JTF - CRM Foundation |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JTF_TERR_SRCH_ADV_GEN_V |
SELECT JT7.TERR_ID
, JT7.NAME TERRITORY_NAME
, JT7.DESCRIPTION
, JT7.RANK
, JT8.NAME PARENT_TERRITORY_NAME
, JT7.START_DATE_ACTIVE
, JT7.END_DATE_ACTIVE
, JT7.ESCALATION_TERRITORY_FLAG
, JT9.NAME ESCALATION_TERR_NAME
, JT7.TEMPLATE_FLAG
, JT10.NAME TEMPLATE_TERR_NAME
, JTY.NAME TERRITORY_TYPE_NAME
, JS.MEANING
FROM JTF_TERR JT7
, JTF_TERR JT8
, JTF_TERR JT9
, JTF_TERR JT10
, JTF_TERR_TYPES JTY
, JTF_TERR_USGS JTU
, JTF_SOURCES_ALL JS
WHERE ( JT7.ESCALATION_TERRITORY_ID = JT9.TERR_ID (+) )
AND ( JT7.TEMPLATE_TERRITORY_ID = JT10.TERR_ID (+) )
AND ( JT7.PARENT_TERRITORY_ID = JT8.TERR_ID )
AND ( JT7.TERR_ID = JTU.TERR_ID (+) )
AND ( JT7.TERRITORY_TYPE_ID = JTY.TERR_TYPE_ID (+) )
AND ( JTU.SOURCE_ID = JS.SOURCE_ID )