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.JTY_WEBADI_QUAL_HEADER#

Source

View Text - Preformatted


select USER_SEQUENCE USER_SEQUENCE, QUAL_USG_ID QUAL_USG_ID, QUALIFIER_NAME QUALIFIER_NAME, QUALIFIER_NUM QUALIFIER_NUM, DISPLAY_TYPE DISPLAY_TYPE, OPERATOR_TYPE OPERATOR_TYPE, QUAL_COND_COL_NAME QUAL_COND_COL_NAME, QUAL_VAL1_COL_NAME QUAL_VAL1_COL_NAME, QUAL_VAL2_COL_NAME QUAL_VAL2_COL_NAME, QUAL_VAL3_COL_NAME QUAL_VAL3_COL_NAME, HTML_LOV_SQL1 HTML_LOV_SQL1, COMPARISON_OPERATOR COMPARISON_OPERATOR, HTML_LOV_SQL2 HTML_LOV_SQL2, HTML_LOV_SQL3 HTML_LOV_SQL3, CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG, DISPLAY_SQL1 DISPLAY_SQL1, DISPLAY_SQL2 DISPLAY_SQL2, DISPLAY_SQL3 DISPLAY_SQL3 from "JTF"."JTY_WEBADI_QUAL_HEADER"

View Text - HTML Formatted

SELECT USER_SEQUENCE USER_SEQUENCE
, QUAL_USG_ID QUAL_USG_ID
, QUALIFIER_NAME QUALIFIER_NAME
, QUALIFIER_NUM QUALIFIER_NUM
, DISPLAY_TYPE DISPLAY_TYPE
, OPERATOR_TYPE OPERATOR_TYPE
, QUAL_COND_COL_NAME QUAL_COND_COL_NAME
, QUAL_VAL1_COL_NAME QUAL_VAL1_COL_NAME
, QUAL_VAL2_COL_NAME QUAL_VAL2_COL_NAME
, QUAL_VAL3_COL_NAME QUAL_VAL3_COL_NAME
, HTML_LOV_SQL1 HTML_LOV_SQL1
, COMPARISON_OPERATOR COMPARISON_OPERATOR
, HTML_LOV_SQL2 HTML_LOV_SQL2
, HTML_LOV_SQL3 HTML_LOV_SQL3
, CONVERT_TO_ID_FLAG CONVERT_TO_ID_FLAG
, DISPLAY_SQL1 DISPLAY_SQL1
, DISPLAY_SQL2 DISPLAY_SQL2
, DISPLAY_SQL3 DISPLAY_SQL3
FROM "JTF"."JTY_WEBADI_QUAL_HEADER"