VIEW: APPS.JTF_GRID_COLS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.GRID_DATASOURCE_NAME, B.GRID_COL_ALIAS, B.DB_COL_NAME, B.DATA_TYPE_CODE, B.QUERY_SEQ, B.SORTABLE_FLAG, B.SORT_ASC_BY_DEFAULT_FLAG, B.VISIBLE_FLAG, B.FREEZE_VISIBLE_FLAG, B.DISPLAY_SEQ, B.DISPLAY_TYPE_CODE, B.DISPLAY_HSIZE, B.HEADER_ALIGNMENT_CODE, B.CELL_ALIGNMENT_CODE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.DISPLAY_FORMAT_TYPE_CODE, B.DISPLAY_FORMAT_MASK, B.CHECKBOX_CHECKED_VALUE, B.CHECKBOX_UNCHECKED_VALUE, B.CHECKBOX_OTHER_VALUES, B.DB_CURRENCY_CODE_COL, T.LABEL_TEXT, B.QUERY_ALLOWED_FLAG, B.VALIDATION_OBJECT_CODE, B.QUERY_DISPLAY_SEQ, B.DB_SORT_COLUMN, B.FIRE_POST_QUERY_FLAG, B.IMAGE_DESCRIPTION_COL from JTF_GRID_COLS_TL T, JTF_GRID_COLS_B B WHERE B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME and B.GRID_COL_ALIAS = T.GRID_COL_ALIAS and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.GRID_DATASOURCE_NAME
, B.GRID_COL_ALIAS
, B.DB_COL_NAME
, B.DATA_TYPE_CODE
, B.QUERY_SEQ
, B.SORTABLE_FLAG
, B.SORT_ASC_BY_DEFAULT_FLAG
, B.VISIBLE_FLAG
, B.FREEZE_VISIBLE_FLAG
, B.DISPLAY_SEQ
, B.DISPLAY_TYPE_CODE
, B.DISPLAY_HSIZE
, B.HEADER_ALIGNMENT_CODE
, B.CELL_ALIGNMENT_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.DISPLAY_FORMAT_TYPE_CODE
, B.DISPLAY_FORMAT_MASK
, B.CHECKBOX_CHECKED_VALUE
, B.CHECKBOX_UNCHECKED_VALUE
, B.CHECKBOX_OTHER_VALUES
, B.DB_CURRENCY_CODE_COL
, T.LABEL_TEXT
, B.QUERY_ALLOWED_FLAG
, B.VALIDATION_OBJECT_CODE
, B.QUERY_DISPLAY_SEQ
, B.DB_SORT_COLUMN
, B.FIRE_POST_QUERY_FLAG
, B.IMAGE_DESCRIPTION_COL
FROM JTF_GRID_COLS_TL T
, JTF_GRID_COLS_B B
WHERE B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
AND B.GRID_COL_ALIAS = T.GRID_COL_ALIAS
AND T.LANGUAGE = USERENV('LANG')