FND Design Data [Home] [Help]

View: JTF_GRID_COLS_VL

Product: JTF - CRM Foundation
Description: MLS view for JTF_GRID_COLS_B and JTF_GRID_COLS_TL
Implementation/DBA Data: ViewAPPS.JTF_GRID_COLS_VL
View Text

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')

Columns

Name
ROW_ID
GRID_DATASOURCE_NAME
GRID_COL_ALIAS
DB_COL_NAME
DATA_TYPE_CODE
QUERY_SEQ
SORTABLE_FLAG
SORT_ASC_BY_DEFAULT_FLAG
VISIBLE_FLAG
FREEZE_VISIBLE_FLAG
DISPLAY_SEQ
DISPLAY_TYPE_CODE
DISPLAY_HSIZE
HEADER_ALIGNMENT_CODE
CELL_ALIGNMENT_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DISPLAY_FORMAT_TYPE_CODE
DISPLAY_FORMAT_MASK
CHECKBOX_CHECKED_VALUE
CHECKBOX_UNCHECKED_VALUE
CHECKBOX_OTHER_VALUES
DB_CURRENCY_CODE_COL
LABEL_TEXT
QUERY_ALLOWED_FLAG
VALIDATION_OBJECT_CODE
QUERY_DISPLAY_SEQ
DB_SORT_COLUMN
FIRE_POST_QUERY_FLAG
IMAGE_DESCRIPTION_COL