VIEW: JTF.JTF_CHANGED_TERR_ALL#

Source

View Text - Preformatted

select TERR_ID TERR_ID, TRIGGER_MODE TRIGGER_MODE, ACTION ACTION, PARENT_TERRITORY_ID PARENT_TERRITORY_ID, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE, OLD_RANK OLD_RANK, OLD_UPDATE_FLAG OLD_UPDATE_FLAG, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE, NEW_RANK NEW_RANK, NEW_UPDATE_FLAG NEW_UPDATE_FLAG, OLD_LAST_UPDATED_BY OLD_LAST_UPDATED_BY, OLD_LAST_UPDATE_DATE OLD_LAST_UPDATE_DATE, OLD_CREATED_BY OLD_CREATED_BY, OLD_CREATION_DATE OLD_CREATION_DATE, OLD_LAST_UPDATE_LOGIN OLD_LAST_UPDATE_LOGIN, OLD_TERR_QUAL_ID OLD_TERR_QUAL_ID, OLD_INCLUDE_FLAG OLD_INCLUDE_FLAG, OLD_COMPARISON_OPERATOR OLD_COMPARISON_OPERATOR, OLD_ID_USED_FLAG OLD_ID_USED_FLAG, OLD_LOW_VALUE_CHAR_ID OLD_LOW_VALUE_CHAR_ID, OLD_LOW_VALUE_CHAR OLD_LOW_VALUE_CHAR, OLD_HIGH_VALUE_CHAR OLD_HIGH_VALUE_CHAR, OLD_LOW_VALUE_NUMBER OLD_LOW_VALUE_NUMBER, OLD_HIGH_VALUE_NUMBER OLD_HIGH_VALUE_NUMBER, OLD_VALUE_SET OLD_VALUE_SET, OLD_INTEREST_TYPE_ID OLD_INTEREST_TYPE_ID, OLD_PRIMARY_INTEREST_CODE_ID OLD_PRIMARY_INTEREST_CODE_ID, OLD_SECONDARY_INTEREST_CODE_ID OLD_SECONDARY_INTEREST_CODE_ID, OLD_CURRENCY_CODE OLD_CURRENCY_CODE, NEW_LAST_UPDATED_BY NEW_LAST_UPDATED_BY, NEW_LAST_UPDATE_DATE NEW_LAST_UPDATE_DATE, NEW_CREATED_BY NEW_CREATED_BY, NEW_CREATION_DATE NEW_CREATION_DATE, NEW_LAST_UPDATE_LOGIN NEW_LAST_UPDATE_LOGIN, NEW_TERR_QUAL_ID NEW_TERR_QUAL_ID, NEW_INCLUDE_FLAG NEW_INCLUDE_FLAG, NEW_COMPARISON_OPERATOR NEW_COMPARISON_OPERATOR, NEW_ID_USED_FLAG NEW_ID_USED_FLAG, NEW_LOW_VALUE_CHAR_ID NEW_LOW_VALUE_CHAR_ID, NEW_LOW_VALUE_CHAR NEW_LOW_VALUE_CHAR, NEW_HIGH_VALUE_CHAR NEW_HIGH_VALUE_CHAR, NEW_LOW_VALUE_NUMBER NEW_LOW_VALUE_NUMBER, NEW_HIGH_VALUE_NUMBER NEW_HIGH_VALUE_NUMBER, NEW_VALUE_SET NEW_VALUE_SET, NEW_INTEREST_TYPE_ID NEW_INTEREST_TYPE_ID, NEW_PRIMARY_INTEREST_CODE_ID NEW_PRIMARY_INTEREST_CODE_ID, NEW_SECONDARY_INTEREST_CODE_ID NEW_SECONDARY_INTEREST_CODE_ID, NEW_CURRENCY_CODE NEW_CURRENCY_CODE, TERR_VALUE_ID TERR_VALUE_ID, OLD_RESOURCE_ID OLD_RESOURCE_ID, OLD_GROUP_ID OLD_GROUP_ID, OLD_RESOURCE_TYPE OLD_RESOURCE_TYPE, OLD_ROLE OLD_ROLE, OLD_PRIMARY_CONTACT_FLAG OLD_PRIMARY_CONTACT_FLAG, OLD_FULL_ACCESS_FLAG OLD_FULL_ACCESS_FLAG, NEW_RESOURCE_ID NEW_RESOURCE_ID, NEW_GROUP_ID NEW_GROUP_ID, NEW_RESOURCE_TYPE NEW_RESOURCE_TYPE, NEW_ROLE NEW_ROLE, NEW_PRIMARY_CONTACT_FLAG NEW_PRIMARY_CONTACT_FLAG, NEW_FULL_ACCESS_FLAG NEW_FULL_ACCESS_FLAG, TRANSFER_ONLY_FLAG TRANSFER_ONLY_FLAG, REQUEST_ID REQUEST_ID, TERR_RSC_ID TERR_RSC_ID, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, TERR_QTYPE_USG_ID TERR_QTYPE_USG_ID, OLD_QUAL_TYPE_USG_ID OLD_QUAL_TYPE_USG_ID, NEW_QUAL_TYPE_USG_ID NEW_QUAL_TYPE_USG_ID, TERR_RSC_ACCESS_ID TERR_RSC_ACCESS_ID, OLD_ACCESS_TYPE OLD_ACCESS_TYPE, NEW_ACCESS_TYPE NEW_ACCESS_TYPE, OLD_NUM_WINNERS OLD_NUM_WINNERS, NEW_NUM_WINNERS NEW_NUM_WINNERS, OLD_PARENT_TERRITORY_ID OLD_PARENT_TERRITORY_ID, NEW_PARENT_TERRITORY_ID NEW_PARENT_TERRITORY_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JTF"."JTF_CHANGED_TERR_ALL"

View Text - HTML Formatted

SELECT TERR_ID TERR_ID
, TRIGGER_MODE TRIGGER_MODE
, ACTION ACTION
, PARENT_TERRITORY_ID PARENT_TERRITORY_ID
, OLD_START_DATE_ACTIVE OLD_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE OLD_END_DATE_ACTIVE
, OLD_RANK OLD_RANK
, OLD_UPDATE_FLAG OLD_UPDATE_FLAG
, NEW_START_DATE_ACTIVE NEW_START_DATE_ACTIVE
, NEW_END_DATE_ACTIVE NEW_END_DATE_ACTIVE
, NEW_RANK NEW_RANK
, NEW_UPDATE_FLAG NEW_UPDATE_FLAG
, OLD_LAST_UPDATED_BY OLD_LAST_UPDATED_BY
, OLD_LAST_UPDATE_DATE OLD_LAST_UPDATE_DATE
, OLD_CREATED_BY OLD_CREATED_BY
, OLD_CREATION_DATE OLD_CREATION_DATE
, OLD_LAST_UPDATE_LOGIN OLD_LAST_UPDATE_LOGIN
, OLD_TERR_QUAL_ID OLD_TERR_QUAL_ID
, OLD_INCLUDE_FLAG OLD_INCLUDE_FLAG
, OLD_COMPARISON_OPERATOR OLD_COMPARISON_OPERATOR
, OLD_ID_USED_FLAG OLD_ID_USED_FLAG
, OLD_LOW_VALUE_CHAR_ID OLD_LOW_VALUE_CHAR_ID
, OLD_LOW_VALUE_CHAR OLD_LOW_VALUE_CHAR
, OLD_HIGH_VALUE_CHAR OLD_HIGH_VALUE_CHAR
, OLD_LOW_VALUE_NUMBER OLD_LOW_VALUE_NUMBER
, OLD_HIGH_VALUE_NUMBER OLD_HIGH_VALUE_NUMBER
, OLD_VALUE_SET OLD_VALUE_SET
, OLD_INTEREST_TYPE_ID OLD_INTEREST_TYPE_ID
, OLD_PRIMARY_INTEREST_CODE_ID OLD_PRIMARY_INTEREST_CODE_ID
, OLD_SECONDARY_INTEREST_CODE_ID OLD_SECONDARY_INTEREST_CODE_ID
, OLD_CURRENCY_CODE OLD_CURRENCY_CODE
, NEW_LAST_UPDATED_BY NEW_LAST_UPDATED_BY
, NEW_LAST_UPDATE_DATE NEW_LAST_UPDATE_DATE
, NEW_CREATED_BY NEW_CREATED_BY
, NEW_CREATION_DATE NEW_CREATION_DATE
, NEW_LAST_UPDATE_LOGIN NEW_LAST_UPDATE_LOGIN
, NEW_TERR_QUAL_ID NEW_TERR_QUAL_ID
, NEW_INCLUDE_FLAG NEW_INCLUDE_FLAG
, NEW_COMPARISON_OPERATOR NEW_COMPARISON_OPERATOR
, NEW_ID_USED_FLAG NEW_ID_USED_FLAG
, NEW_LOW_VALUE_CHAR_ID NEW_LOW_VALUE_CHAR_ID
, NEW_LOW_VALUE_CHAR NEW_LOW_VALUE_CHAR
, NEW_HIGH_VALUE_CHAR NEW_HIGH_VALUE_CHAR
, NEW_LOW_VALUE_NUMBER NEW_LOW_VALUE_NUMBER
, NEW_HIGH_VALUE_NUMBER NEW_HIGH_VALUE_NUMBER
, NEW_VALUE_SET NEW_VALUE_SET
, NEW_INTEREST_TYPE_ID NEW_INTEREST_TYPE_ID
, NEW_PRIMARY_INTEREST_CODE_ID NEW_PRIMARY_INTEREST_CODE_ID
, NEW_SECONDARY_INTEREST_CODE_ID NEW_SECONDARY_INTEREST_CODE_ID
, NEW_CURRENCY_CODE NEW_CURRENCY_CODE
, TERR_VALUE_ID TERR_VALUE_ID
, OLD_RESOURCE_ID OLD_RESOURCE_ID
, OLD_GROUP_ID OLD_GROUP_ID
, OLD_RESOURCE_TYPE OLD_RESOURCE_TYPE
, OLD_ROLE OLD_ROLE
, OLD_PRIMARY_CONTACT_FLAG OLD_PRIMARY_CONTACT_FLAG
, OLD_FULL_ACCESS_FLAG OLD_FULL_ACCESS_FLAG
, NEW_RESOURCE_ID NEW_RESOURCE_ID
, NEW_GROUP_ID NEW_GROUP_ID
, NEW_RESOURCE_TYPE NEW_RESOURCE_TYPE
, NEW_ROLE NEW_ROLE
, NEW_PRIMARY_CONTACT_FLAG NEW_PRIMARY_CONTACT_FLAG
, NEW_FULL_ACCESS_FLAG NEW_FULL_ACCESS_FLAG
, TRANSFER_ONLY_FLAG TRANSFER_ONLY_FLAG
, REQUEST_ID REQUEST_ID
, TERR_RSC_ID TERR_RSC_ID
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, TERR_QTYPE_USG_ID TERR_QTYPE_USG_ID
, OLD_QUAL_TYPE_USG_ID OLD_QUAL_TYPE_USG_ID
, NEW_QUAL_TYPE_USG_ID NEW_QUAL_TYPE_USG_ID
, TERR_RSC_ACCESS_ID TERR_RSC_ACCESS_ID
, OLD_ACCESS_TYPE OLD_ACCESS_TYPE
, NEW_ACCESS_TYPE NEW_ACCESS_TYPE
, OLD_NUM_WINNERS OLD_NUM_WINNERS
, NEW_NUM_WINNERS NEW_NUM_WINNERS
, OLD_PARENT_TERRITORY_ID OLD_PARENT_TERRITORY_ID
, NEW_PARENT_TERRITORY_ID NEW_PARENT_TERRITORY_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JTF"."JTF_CHANGED_TERR_ALL"