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