VIEW: APPS.JTF_TERR_SRCH_ADV_GEN_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )