DBA Data[Home] [Help]

VIEW: APPS.IGI_GCC_INSTALLED_OPTIONS

Source

View Text - Preformatted

SELECT OPTION_ID , OPTION_NAME , STATUS_FLAG , VERSION_NUMBER , SWITCH_OPTION , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , ORG_ID , LUP.MEANING DESCRIPTION FROM IGI_GCC_INST_OPTIONS , IGI_LOOKUPS LUP WHERE LUP.LOOKUP_TYPE = 'GCC_DESCRIPTION' AND LUP.LOOKUP_CODE = OPTION_NAME
View Text - HTML Formatted

SELECT OPTION_ID
, OPTION_NAME
, STATUS_FLAG
, VERSION_NUMBER
, SWITCH_OPTION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
, LUP.MEANING DESCRIPTION
FROM IGI_GCC_INST_OPTIONS
, IGI_LOOKUPS LUP
WHERE LUP.LOOKUP_TYPE = 'GCC_DESCRIPTION'
AND LUP.LOOKUP_CODE = OPTION_NAME