VIEW: APPS.JTF_TERR_OVERVIEW_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)