eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: JTF.JTF_TERR_VALUES_ALL#

Source

View Text - Preformatted


select TERR_VALUE_ID TERR_VALUE_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TERR_QUAL_ID TERR_QUAL_ID, INCLUDE_FLAG INCLUDE_FLAG, COMPARISON_OPERATOR COMPARISON_OPERATOR, ID_USED_FLAG ID_USED_FLAG, LOW_VALUE_CHAR_ID LOW_VALUE_CHAR_ID, LOW_VALUE_CHAR LOW_VALUE_CHAR, HIGH_VALUE_CHAR HIGH_VALUE_CHAR, LOW_VALUE_NUMBER LOW_VALUE_NUMBER, HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER, VALUE_SET VALUE_SET, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, CURRENCY_CODE CURRENCY_CODE, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CNR_GROUP_ID CNR_GROUP_ID, VALUE1_ID VALUE1_ID, VALUE2_ID VALUE2_ID, VALUE3_ID VALUE3_ID, FIRST_CHAR FIRST_CHAR, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VALUE4_ID VALUE4_ID, SELF_SERVICE_TERR_VALUE_ID SELF_SERVICE_TERR_VALUE_ID from "JTF"."JTF_TERR_VALUES_ALL"

View Text - HTML Formatted

SELECT TERR_VALUE_ID TERR_VALUE_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TERR_QUAL_ID TERR_QUAL_ID
, INCLUDE_FLAG INCLUDE_FLAG
, COMPARISON_OPERATOR COMPARISON_OPERATOR
, ID_USED_FLAG ID_USED_FLAG
, LOW_VALUE_CHAR_ID LOW_VALUE_CHAR_ID
, LOW_VALUE_CHAR LOW_VALUE_CHAR
, HIGH_VALUE_CHAR HIGH_VALUE_CHAR
, LOW_VALUE_NUMBER LOW_VALUE_NUMBER
, HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER
, VALUE_SET VALUE_SET
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, CURRENCY_CODE CURRENCY_CODE
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CNR_GROUP_ID CNR_GROUP_ID
, VALUE1_ID VALUE1_ID
, VALUE2_ID VALUE2_ID
, VALUE3_ID VALUE3_ID
, FIRST_CHAR FIRST_CHAR
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VALUE4_ID VALUE4_ID
, SELF_SERVICE_TERR_VALUE_ID SELF_SERVICE_TERR_VALUE_ID
FROM "JTF"."JTF_TERR_VALUES_ALL"