Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Form View for IGS_I_INQUIRY_TYPE table |
Implementation/DBA Data: | Not implemented in this database |
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(+)