Product: | JTF - CRM Foundation |
---|---|
Description: | MLS view for JTF_GRID_COLS_B and JTF_GRID_COLS_TL |
Implementation/DBA Data: | APPS.JTF_GRID_COLS_VL |
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')