[Home] [Help]
View: CZ_STDBUTTON_ATTRS_LKV
View Text
SELECT LKV.LIST_NAME
, LKV.DATA_VALUE
, LKV.NUMERIC_ID_VALUE
, LKV.VALUE_SEQ
, LKV.DATA_TYPE_ID
, LKV.NULL_VALUE_FLAG
, LKV.VALUE_LABEL
, LKV.VALUE_DESCRIPTION
, LKV.VALUE_NOTES
, LKV.LANGUAGE
, LKV.SOURCE_LANG
, ATPL.JRAD_DOC AS ATTRIBUTE_SET_JRAD_DOC
FROM CZ_LOOKUP_VALUES_VL LKV
, CZ_UI_TEMPLATES ATPL
WHERE LKV.LIST_NAME = 'STD_BUTTON_TYPES'
AND LKV.DATA_TYPE_ID = ATPL.TEMPLATE_TYPE
AND LKV.NUMERIC_ID_VALUE = ATPL.TEMPLATE_ID
AND ATPL.UI_DEF_ID = 0
Columns
| Name |
| LIST_NAME |
| DATA_VALUE |
| NUMERIC_ID_VALUE |
| VALUE_SEQ |
| DATA_TYPE_ID |
| NULL_VALUE_FLAG |
| VALUE_LABEL |
| VALUE_DESCRIPTION |
| VALUE_NOTES |
| LANGUAGE |
| SOURCE_LANG |
| ATTRIBUTE_SET_JRAD_DOC |
APPS.CZ_STDBUTTON_ATTRS_LKV