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_GRID_COLS_B#

Source

View Text - Preformatted


select GRID_DATASOURCE_NAME GRID_DATASOURCE_NAME, GRID_COL_ALIAS GRID_COL_ALIAS, DB_COL_NAME DB_COL_NAME, DATA_TYPE_CODE DATA_TYPE_CODE, QUERY_SEQ QUERY_SEQ, SORTABLE_FLAG SORTABLE_FLAG, SORT_ASC_BY_DEFAULT_FLAG SORT_ASC_BY_DEFAULT_FLAG, VISIBLE_FLAG VISIBLE_FLAG, FREEZE_VISIBLE_FLAG FREEZE_VISIBLE_FLAG, DISPLAY_SEQ DISPLAY_SEQ, DISPLAY_TYPE_CODE DISPLAY_TYPE_CODE, DISPLAY_HSIZE DISPLAY_HSIZE, HEADER_ALIGNMENT_CODE HEADER_ALIGNMENT_CODE, CELL_ALIGNMENT_CODE CELL_ALIGNMENT_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DISPLAY_FORMAT_TYPE_CODE DISPLAY_FORMAT_TYPE_CODE, DISPLAY_FORMAT_MASK DISPLAY_FORMAT_MASK, CHECKBOX_CHECKED_VALUE CHECKBOX_CHECKED_VALUE, CHECKBOX_UNCHECKED_VALUE CHECKBOX_UNCHECKED_VALUE, CHECKBOX_OTHER_VALUES CHECKBOX_OTHER_VALUES, DB_CURRENCY_CODE_COL DB_CURRENCY_CODE_COL, SECURITY_GROUP_ID SECURITY_GROUP_ID, QUERY_ALLOWED_FLAG QUERY_ALLOWED_FLAG, VALIDATION_OBJECT_CODE VALIDATION_OBJECT_CODE, QUERY_DISPLAY_SEQ QUERY_DISPLAY_SEQ, DB_SORT_COLUMN DB_SORT_COLUMN, FIRE_POST_QUERY_FLAG FIRE_POST_QUERY_FLAG, IMAGE_DESCRIPTION_COL IMAGE_DESCRIPTION_COL, ZD_EDITION_NAME ZD_EDITION_NAME from "JTF"."JTF_GRID_COLS_B"

View Text - HTML Formatted

SELECT GRID_DATASOURCE_NAME GRID_DATASOURCE_NAME
, GRID_COL_ALIAS GRID_COL_ALIAS
, DB_COL_NAME DB_COL_NAME
, DATA_TYPE_CODE DATA_TYPE_CODE
, QUERY_SEQ QUERY_SEQ
, SORTABLE_FLAG SORTABLE_FLAG
, SORT_ASC_BY_DEFAULT_FLAG SORT_ASC_BY_DEFAULT_FLAG
, VISIBLE_FLAG VISIBLE_FLAG
, FREEZE_VISIBLE_FLAG FREEZE_VISIBLE_FLAG
, DISPLAY_SEQ DISPLAY_SEQ
, DISPLAY_TYPE_CODE DISPLAY_TYPE_CODE
, DISPLAY_HSIZE DISPLAY_HSIZE
, HEADER_ALIGNMENT_CODE HEADER_ALIGNMENT_CODE
, CELL_ALIGNMENT_CODE CELL_ALIGNMENT_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DISPLAY_FORMAT_TYPE_CODE DISPLAY_FORMAT_TYPE_CODE
, DISPLAY_FORMAT_MASK DISPLAY_FORMAT_MASK
, CHECKBOX_CHECKED_VALUE CHECKBOX_CHECKED_VALUE
, CHECKBOX_UNCHECKED_VALUE CHECKBOX_UNCHECKED_VALUE
, CHECKBOX_OTHER_VALUES CHECKBOX_OTHER_VALUES
, DB_CURRENCY_CODE_COL DB_CURRENCY_CODE_COL
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, QUERY_ALLOWED_FLAG QUERY_ALLOWED_FLAG
, VALIDATION_OBJECT_CODE VALIDATION_OBJECT_CODE
, QUERY_DISPLAY_SEQ QUERY_DISPLAY_SEQ
, DB_SORT_COLUMN DB_SORT_COLUMN
, FIRE_POST_QUERY_FLAG FIRE_POST_QUERY_FLAG
, IMAGE_DESCRIPTION_COL IMAGE_DESCRIPTION_COL
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "JTF"."JTF_GRID_COLS_B"