VIEW: APPS.IGR_I_INQUIRY_TYPES_V

Source

View Text - Preformatted

SELECT IIT.ROWID ROW_ID, IIT.INQUIRY_TYPE_ID, IIT.INQUIRY_TYPE_CD, IIT.INQUIRY_TYPE_DESC, IIT.ENABLED_FLAG, IIT.IMP_SOURCE_TYPE_ID, PSR.SOURCE_TYPE IMP_SOURCE_TYPE, IIT.INFO_TYPE_ID, IFT.INFORMATION_TYPE, IFT.DESCRIPTION INFORMATION_TYPE_DESC, IIT.CONFIGURABILITY_FUNC_NAME, FFV.USER_FUNCTION_NAME CONFIG_FUNC_NAME_DESC, IIT.CREATED_BY, IIT.CREATION_DATE, IIT.LAST_UPDATED_BY, IIT.LAST_UPDATE_DATE, IIT.LAST_UPDATE_LOGIN FROM IGR_I_INQUIRY_TYPES IIT, IGS_PE_SRC_TYPES PSR, IGR_I_INFO_TYPES_V IFT, FND_FORM_FUNCTIONS_VL FFV WHERE IIT.IMP_SOURCE_TYPE_ID = PSR.SOURCE_TYPE_ID(+) AND IIT.CONFIGURABILITY_FUNC_NAME=FFV.FUNCTION_NAME(+) AND IIT.INFO_TYPE_ID = IFT.INFO_TYPE_ID(+)

View Text - HTML Formatted

SELECT IIT.ROWID ROW_ID
, IIT.INQUIRY_TYPE_ID
, IIT.INQUIRY_TYPE_CD
, IIT.INQUIRY_TYPE_DESC
, IIT.ENABLED_FLAG
, IIT.IMP_SOURCE_TYPE_ID
, PSR.SOURCE_TYPE IMP_SOURCE_TYPE
, IIT.INFO_TYPE_ID
, IFT.INFORMATION_TYPE
, IFT.DESCRIPTION INFORMATION_TYPE_DESC
, IIT.CONFIGURABILITY_FUNC_NAME
, FFV.USER_FUNCTION_NAME CONFIG_FUNC_NAME_DESC
, IIT.CREATED_BY
, IIT.CREATION_DATE
, IIT.LAST_UPDATED_BY
, IIT.LAST_UPDATE_DATE
, IIT.LAST_UPDATE_LOGIN
FROM IGR_I_INQUIRY_TYPES IIT
, IGS_PE_SRC_TYPES PSR
, IGR_I_INFO_TYPES_V IFT
, FND_FORM_FUNCTIONS_VL FFV
WHERE IIT.IMP_SOURCE_TYPE_ID = PSR.SOURCE_TYPE_ID(+)
AND IIT.CONFIGURABILITY_FUNC_NAME=FFV.FUNCTION_NAME(+)
AND IIT.INFO_TYPE_ID = IFT.INFO_TYPE_ID(+)