VIEW: JTF.JTF_TERR_ALL#

Source

View Text - Preformatted

select TERR_ID TERR_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME, NAME NAME, ENABLED_FLAG ENABLED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, PLANNED_FLAG PLANNED_FLAG, PARENT_TERRITORY_ID PARENT_TERRITORY_ID, TERRITORY_TYPE_ID TERRITORY_TYPE_ID, TEMPLATE_TERRITORY_ID TEMPLATE_TERRITORY_ID, TEMPLATE_FLAG TEMPLATE_FLAG, ESCALATION_TERRITORY_ID ESCALATION_TERRITORY_ID, ESCALATION_TERRITORY_FLAG ESCALATION_TERRITORY_FLAG, OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG, RANK RANK, DESCRIPTION DESCRIPTION, UPDATE_FLAG UPDATE_FLAG, AUTO_ASSIGN_RESOURCES_FLAG AUTO_ASSIGN_RESOURCES_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID, UPGRADE_STATUS_FLAG UPGRADE_STATUS_FLAG, NUM_WINNERS NUM_WINNERS, NUM_QUAL NUM_QUAL, TAP_PROGRAM_ID TAP_PROGRAM_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CATCH_ALL_FLAG CATCH_ALL_FLAG, NAMED_ACCOUNT_FLAG NAMED_ACCOUNT_FLAG, TERR_GROUP_FLAG TERR_GROUP_FLAG, TERR_GROUP_ID TERR_GROUP_ID, TERR_GROUP_ACCOUNT_ID TERR_GROUP_ACCOUNT_ID, GEO_TERR_FLAG GEO_TERR_FLAG, GEO_TERRITORY_ID GEO_TERRITORY_ID, RELATIVE_RANK RELATIVE_RANK, ABSOLUTE_RANK ABSOLUTE_RANK, ENABLE_SELF_SERVICE ENABLE_SELF_SERVICE, TERR_UPDATE_DATE TERR_UPDATE_DATE, ZD_EDITION_NAME ZD_EDITION_NAME from "JTF"."JTF_TERR_ALL"

View Text - HTML Formatted

SELECT TERR_ID TERR_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, NAME NAME
, ENABLED_FLAG ENABLED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, PLANNED_FLAG PLANNED_FLAG
, PARENT_TERRITORY_ID PARENT_TERRITORY_ID
, TERRITORY_TYPE_ID TERRITORY_TYPE_ID
, TEMPLATE_TERRITORY_ID TEMPLATE_TERRITORY_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, ESCALATION_TERRITORY_ID ESCALATION_TERRITORY_ID
, ESCALATION_TERRITORY_FLAG ESCALATION_TERRITORY_FLAG
, OVERLAP_ALLOWED_FLAG OVERLAP_ALLOWED_FLAG
, RANK RANK
, DESCRIPTION DESCRIPTION
, UPDATE_FLAG UPDATE_FLAG
, AUTO_ASSIGN_RESOURCES_FLAG AUTO_ASSIGN_RESOURCES_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID
, UPGRADE_STATUS_FLAG UPGRADE_STATUS_FLAG
, NUM_WINNERS NUM_WINNERS
, NUM_QUAL NUM_QUAL
, TAP_PROGRAM_ID TAP_PROGRAM_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CATCH_ALL_FLAG CATCH_ALL_FLAG
, NAMED_ACCOUNT_FLAG NAMED_ACCOUNT_FLAG
, TERR_GROUP_FLAG TERR_GROUP_FLAG
, TERR_GROUP_ID TERR_GROUP_ID
, TERR_GROUP_ACCOUNT_ID TERR_GROUP_ACCOUNT_ID
, GEO_TERR_FLAG GEO_TERR_FLAG
, GEO_TERRITORY_ID GEO_TERRITORY_ID
, RELATIVE_RANK RELATIVE_RANK
, ABSOLUTE_RANK ABSOLUTE_RANK
, ENABLE_SELF_SERVICE ENABLE_SELF_SERVICE
, TERR_UPDATE_DATE TERR_UPDATE_DATE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "JTF"."JTF_TERR_ALL"