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.

[Home] [Help]

VIEW: JTF.JTF_QUAL_USGS_ALL#

Source

View Text - Preformatted


select QUAL_USG_ID QUAL_USG_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, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME, SEEDED_QUAL_ID SEEDED_QUAL_ID, QUAL_TYPE_USG_ID QUAL_TYPE_USG_ID, ENABLED_FLAG ENABLED_FLAG, QUAL_COL1 QUAL_COL1, QUAL_COL1_ALIAS QUAL_COL1_ALIAS, QUAL_COL1_DATATYPE QUAL_COL1_DATATYPE, QUAL_COL1_TABLE QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS QUAL_COL1_TABLE_ALIAS, PRIM_INT_CDE_COL PRIM_INT_CDE_COL, PRIM_INT_CDE_COL_ALIAS PRIM_INT_CDE_COL_ALIAS, PRIM_INT_CDE_COL_DATATYPE PRIM_INT_CDE_COL_DATATYPE, SEC_INT_CDE_COL SEC_INT_CDE_COL, SEC_INT_CDE_COL_ALIAS SEC_INT_CDE_COL_ALIAS, SEC_INT_CDE_COL_DATATYPE SEC_INT_CDE_COL_DATATYPE, INT_CDE_COL_TABLE INT_CDE_COL_TABLE, INT_CDE_COL_TABLE_ALIAS INT_CDE_COL_TABLE_ALIAS, SEEDED_FLAG SEEDED_FLAG, CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG, DISPLAY_TYPE DISPLAY_TYPE, LOV_SQL LOV_SQL, ORG_ID ORG_ID, COLUMN_COUNT COLUMN_COUNT, FORMATTING_FUNCTION_FLAG FORMATTING_FUNCTION_FLAG, FORMATTING_FUNCTION_NAME FORMATTING_FUNCTION_NAME, SPECIAL_FUNCTION_FLAG SPECIAL_FUNCTION_FLAG, SPECIAL_FUNCTION_NAME SPECIAL_FUNCTION_NAME, ENABLE_LOV_VALIDATION ENABLE_LOV_VALIDATION, DISPLAY_SQL1 DISPLAY_SQL1, LOV_SQL2 LOV_SQL2, DISPLAY_SQL2 DISPLAY_SQL2, LOV_SQL3 LOV_SQL3, DISPLAY_SQL3 DISPLAY_SQL3, 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, RULE1 RULE1, RULE2 RULE2, DISPLAY_SEQUENCE DISPLAY_SEQUENCE, DISPLAY_LENGTH DISPLAY_LENGTH, JSP_LOV_SQL JSP_LOV_SQL, USE_IN_LOOKUP_FLAG USE_IN_LOOKUP_FLAG, ALIAS_RULE1 ALIAS_RULE1, ALIAS_RULE2 ALIAS_RULE2, ALIAS_OP_LIKE ALIAS_OP_LIKE, ALIAS_OP_BETWEEN ALIAS_OP_BETWEEN, ALIAS_LINE_ITEM ALIAS_LINE_ITEM, OP_EQL OP_EQL, OP_NOT_EQL OP_NOT_EQL, OP_LSS_THN OP_LSS_THN, OP_LSS_THN_EQL OP_LSS_THN_EQL, OP_GRTR_THN OP_GRTR_THN, OP_GRTR_THN_EQL OP_GRTR_THN_EQL, OP_LIKE OP_LIKE, OP_NOT_LIKE OP_NOT_LIKE, OP_BETWEEN OP_BETWEEN, OP_NOT_BETWEEN OP_NOT_BETWEEN, OP_COMMON_WHERE OP_COMMON_WHERE, QUAL_RELATION_FACTOR QUAL_RELATION_FACTOR, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, COMPARISON_OPERATOR COMPARISON_OPERATOR, LOW_VALUE_CHAR LOW_VALUE_CHAR, HIGH_VALUE_CHAR HIGH_VALUE_CHAR, LOW_VALUE_CHAR_ID LOW_VALUE_CHAR_ID, LOW_VALUE_NUMBER LOW_VALUE_NUMBER, HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, VALUE1_ID VALUE1_ID, VALUE2_ID VALUE2_ID, VALUE3_ID VALUE3_ID, VALUE4_ID VALUE4_ID, FIRST_CHAR FIRST_CHAR, CURRENCY_CODE CURRENCY_CODE, REAL_TIME_SELECT REAL_TIME_SELECT, REAL_TIME_WHERE REAL_TIME_WHERE, REAL_TIME_FROM REAL_TIME_FROM, UPDATE_ATTR_VAL_STMT UPDATE_ATTR_VAL_STMT, INSERT_ATTR_VAL_STMT INSERT_ATTR_VAL_STMT, HTML_LOV_SQL1 HTML_LOV_SQL1, HTML_LOV_SQL2 HTML_LOV_SQL2, HTML_LOV_SQL3 HTML_LOV_SQL3, HIERARCHY_TYPE HIERARCHY_TYPE, EQUAL_FLAG EQUAL_FLAG, LIKE_FLAG LIKE_FLAG, BETWEEN_FLAG BETWEEN_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "JTF"."JTF_QUAL_USGS_ALL"

View Text - HTML Formatted

SELECT QUAL_USG_ID QUAL_USG_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
, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, SEEDED_QUAL_ID SEEDED_QUAL_ID
, QUAL_TYPE_USG_ID QUAL_TYPE_USG_ID
, ENABLED_FLAG ENABLED_FLAG
, QUAL_COL1 QUAL_COL1
, QUAL_COL1_ALIAS QUAL_COL1_ALIAS
, QUAL_COL1_DATATYPE QUAL_COL1_DATATYPE
, QUAL_COL1_TABLE QUAL_COL1_TABLE
, QUAL_COL1_TABLE_ALIAS QUAL_COL1_TABLE_ALIAS
, PRIM_INT_CDE_COL PRIM_INT_CDE_COL
, PRIM_INT_CDE_COL_ALIAS PRIM_INT_CDE_COL_ALIAS
, PRIM_INT_CDE_COL_DATATYPE PRIM_INT_CDE_COL_DATATYPE
, SEC_INT_CDE_COL SEC_INT_CDE_COL
, SEC_INT_CDE_COL_ALIAS SEC_INT_CDE_COL_ALIAS
, SEC_INT_CDE_COL_DATATYPE SEC_INT_CDE_COL_DATATYPE
, INT_CDE_COL_TABLE INT_CDE_COL_TABLE
, INT_CDE_COL_TABLE_ALIAS INT_CDE_COL_TABLE_ALIAS
, SEEDED_FLAG SEEDED_FLAG
, CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG
, DISPLAY_TYPE DISPLAY_TYPE
, LOV_SQL LOV_SQL
, ORG_ID ORG_ID
, COLUMN_COUNT COLUMN_COUNT
, FORMATTING_FUNCTION_FLAG FORMATTING_FUNCTION_FLAG
, FORMATTING_FUNCTION_NAME FORMATTING_FUNCTION_NAME
, SPECIAL_FUNCTION_FLAG SPECIAL_FUNCTION_FLAG
, SPECIAL_FUNCTION_NAME SPECIAL_FUNCTION_NAME
, ENABLE_LOV_VALIDATION ENABLE_LOV_VALIDATION
, DISPLAY_SQL1 DISPLAY_SQL1
, LOV_SQL2 LOV_SQL2
, DISPLAY_SQL2 DISPLAY_SQL2
, LOV_SQL3 LOV_SQL3
, DISPLAY_SQL3 DISPLAY_SQL3
, 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
, RULE1 RULE1
, RULE2 RULE2
, DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, DISPLAY_LENGTH DISPLAY_LENGTH
, JSP_LOV_SQL JSP_LOV_SQL
, USE_IN_LOOKUP_FLAG USE_IN_LOOKUP_FLAG
, ALIAS_RULE1 ALIAS_RULE1
, ALIAS_RULE2 ALIAS_RULE2
, ALIAS_OP_LIKE ALIAS_OP_LIKE
, ALIAS_OP_BETWEEN ALIAS_OP_BETWEEN
, ALIAS_LINE_ITEM ALIAS_LINE_ITEM
, OP_EQL OP_EQL
, OP_NOT_EQL OP_NOT_EQL
, OP_LSS_THN OP_LSS_THN
, OP_LSS_THN_EQL OP_LSS_THN_EQL
, OP_GRTR_THN OP_GRTR_THN
, OP_GRTR_THN_EQL OP_GRTR_THN_EQL
, OP_LIKE OP_LIKE
, OP_NOT_LIKE OP_NOT_LIKE
, OP_BETWEEN OP_BETWEEN
, OP_NOT_BETWEEN OP_NOT_BETWEEN
, OP_COMMON_WHERE OP_COMMON_WHERE
, QUAL_RELATION_FACTOR QUAL_RELATION_FACTOR
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COMPARISON_OPERATOR COMPARISON_OPERATOR
, LOW_VALUE_CHAR LOW_VALUE_CHAR
, HIGH_VALUE_CHAR HIGH_VALUE_CHAR
, LOW_VALUE_CHAR_ID LOW_VALUE_CHAR_ID
, LOW_VALUE_NUMBER LOW_VALUE_NUMBER
, HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, VALUE1_ID VALUE1_ID
, VALUE2_ID VALUE2_ID
, VALUE3_ID VALUE3_ID
, VALUE4_ID VALUE4_ID
, FIRST_CHAR FIRST_CHAR
, CURRENCY_CODE CURRENCY_CODE
, REAL_TIME_SELECT REAL_TIME_SELECT
, REAL_TIME_WHERE REAL_TIME_WHERE
, REAL_TIME_FROM REAL_TIME_FROM
, UPDATE_ATTR_VAL_STMT UPDATE_ATTR_VAL_STMT
, INSERT_ATTR_VAL_STMT INSERT_ATTR_VAL_STMT
, HTML_LOV_SQL1 HTML_LOV_SQL1
, HTML_LOV_SQL2 HTML_LOV_SQL2
, HTML_LOV_SQL3 HTML_LOV_SQL3
, HIERARCHY_TYPE HIERARCHY_TYPE
, EQUAL_FLAG EQUAL_FLAG
, LIKE_FLAG LIKE_FLAG
, BETWEEN_FLAG BETWEEN_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "JTF"."JTF_QUAL_USGS_ALL"