View: JTF_TERR_OVERVIEW_V

Product:	JTF - CRM Foundation
Description:	This view shows the header information for a territory.
Implementation/DBA Data:	APPS.JTF_TERR_OVERVIEW_V

View Text

SELECT JTR.ROWID ROW_ID
, JTR.TERR_ID TERR_ID
, JTR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JTR.LAST_UPDATED_BY LAST_UPDATED_BY
, JTR.CREATION_DATE CREATION_DATE
, JTR.CREATED_BY CREATED_BY
, JTR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JTR.REQUEST_ID REQUEST_ID
, JTR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, JTR.PROGRAM_ID PROGRAM_ID
, JTR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, JTR.APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, JTR.NAME NAME
, JTR.ENABLED_FLAG ENABLED_FLAG
, JTR.START_DATE_ACTIVE START_DATE_ACTIVE
, JTR.END_DATE_ACTIVE END_DATE_ACTIVE
, JTR.PLANNED_FLAG PLANNED_FLAG
, JTR.PARENT_TERRITORY_ID PARENT_TERRITORY_ID
, JTR.TERRITORY_TYPE_ID TERRITORY_TYPE_ID
, JTR.TEMPLATE_TERRITORY_ID TEMPLATE_TERRITORY_ID
, JTR.TEMPLATE_FLAG TEMPLATE_FLAG
, JTR.ESCALATION_TERRITORY_ID ESCALATION_TERRITORY_ID
, JTR.ESCALATION_TERRITORY_FLAG ESCALATION_TERRITORY_FLAG
, JTR.OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG
, JTR.RANK RANK
, JTR.DESCRIPTION DESCRIPTION
, JTR.UPDATE_FLAG UPDATE_FLAG
, JTR.AUTO_ASSIGN_RESOURCES_FLAG AUTO_ASSIGN_RESOURCES_FLAG
, JTR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, JTR.ATTRIBUTE1 ATTRIBUTE1
, JTR.ATTRIBUTE2 ATTRIBUTE2
, JTR.ATTRIBUTE3 ATTRIBUTE3
, JTR.ATTRIBUTE4 ATTRIBUTE4
, JTR.ATTRIBUTE5 ATTRIBUTE5
, JTR.ATTRIBUTE6 ATTRIBUTE6
, JTR.ATTRIBUTE7 ATTRIBUTE7
, JTR.ATTRIBUTE8 ATTRIBUTE8
, JTR.ATTRIBUTE9 ATTRIBUTE9
, JTR.ATTRIBUTE10 ATTRIBUTE10
, JTR.ATTRIBUTE11 ATTRIBUTE11
, JTR.ATTRIBUTE12 ATTRIBUTE12
, JTR.ATTRIBUTE13 ATTRIBUTE13
, JTR.ATTRIBUTE14 ATTRIBUTE14
, JTR.ATTRIBUTE15 ATTRIBUTE15
, JTR.ORG_ID ORG_ID
, FND_ACCESS_CONTROL_UTIL.GET_ORG_NAME(JTR.ORG_ID) ORGANIZATION_NAME
, JTT.NAME TERR_TYPE_NAME
, JTR_PAR.NAME PARENT_TERR_NAME
, JTR_ESC.NAME ESCALATION_TERR_NAME
, JTR_TEM.NAME TEMPLATE_TERR_NAME
, JTU.TERR_USG_ID TERR_USG_ID
, JTU.SOURCE_ID SOURCE_ID
, JSE.MEANING TERR_USAGE
, JTR.NUM_WINNERS NUM_WINNERS
, JTR.NUM_QUAL NUM_QUAL
FROM JTF_TERR JTR
, JTF_TERR JTR_PAR
, JTF_TERR JTR_ESC
, JTF_TERR JTR_TEM
, JTF_TERR_TYPES JTT
, JTF_TERR_USGS JTU
, JTF_SOURCES_ALL JSE
WHERE JTR.PARENT_TERRITORY_ID = JTR_PAR.TERR_ID
AND JTR.ESCALATION_TERRITORY_ID = JTR_ESC.TERR_ID (+)
AND JTR.TEMPLATE_TERRITORY_ID = JTR_TEM.TERR_ID (+)
AND JTR.TERRITORY_TYPE_ID = JTT.TERR_TYPE_ID (+)
AND JTU.TERR_ID (+) = JTR.TERR_ID
AND JTU.SOURCE_ID = JSE.SOURCE_ID (+)

Columns