[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Foreign Key resolved View for Inquiry Entry Status. The following attributes in the old view are made obsolete: ENQUIRY_SOURCE_TYPE ,ENQ_SOURCE_DESCRIPTION ,ACTIVITY_SOURCE_CD ,ACTIVITY_SOURCE_MEANING ,TEST_SOURCE_ID , HIERARCHY_CD , HIERAR |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IES. ROWID ROW_ID
, IES.INQ_ENTRY_STAT_ID
, INVL.INTEREST_TYPE INQ_ENTRY_STAT
, INVL.DESCRIPTION INQ_ENTRY_STAT_DESCRIPTION
, IES.INTEREST_TYPE_ID
, IES.INSTITUTION_TYPE
, IES.IMP_SOURCE_TYPE_ID
, PSR.SOURCE_TYPE IMP_SOURCE_TYPE
, IES.EMAIL_LINK
, IES.PKG_ITEM_REDUC_CD
, LK5.MEANING PKG_ITEM_REDUC_MEANING
, INVL.ENABLED_FLAG
, INVL.CREATED_BY
, INVL.CREATION_DATE
, INVL.LAST_UPDATED_BY
, INVL.LAST_UPDATE_DATE
, INVL.LAST_UPDATE_LOGIN
, IES.CONFIGURABILITY_FUNC_NAME
, FFV.USER_FUNCTION_NAME CONFIG_FUNC_NAME_DESC
FROM IGS_RC_I_ENT_STATS IES
, AS_INTEREST_TYPES_VL INVL
, IGS_PE_SRC_TYPES PSR
, IGS_LOOKUP_VALUES LK5
, FND_FORM_FUNCTIONS_VL FFV
WHERE IES.IMP_SOURCE_TYPE_ID = PSR.SOURCE_TYPE_ID(+)
AND IES.PKG_ITEM_REDUC_CD = LK5.LOOKUP_CODE(+)
AND LK5.LOOKUP_TYPE(+) = 'IGS_ITEM_REDUCTION'
AND IES.CONFIGURABILITY_FUNC_NAME=FFV.FUNCTION_NAME(+)
AND INVL.INTEREST_TYPE_ID = IES. INTEREST_TYPE_ID