Skip to content
[Home] [Help]
View: IGI_GCC_GL_FA_INST_OPS
View Text
SELECT OPTION_ID
, OPTION_NAME
, STATUS_FLAG
, VERSION_NUMBER
, SWITCH_OPTION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LUP.MEANING DESCRIPTION
FROM IGI_GCC_GL_FA_INST_OPTIONS
, IGI_LOOKUPS LUP
WHERE LUP.LOOKUP_TYPE = 'GCC_DESCRIPTION'
AND LUP.LOOKUP_CODE = OPTION_NAME
Columns
| Name |
| OPTION_ID |
| OPTION_NAME |
| STATUS_FLAG |
| VERSION_NUMBER |
| SWITCH_OPTION |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| DESCRIPTION |