Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Obsolete - This view is created using a join between IGS_AD_I_ENTRY_STATS, IGS_AD_CODE_CLASSES, IGS_PE_SRC_TYPES, IGS_IN_ENQ_SRC_TYPE and IGS_LOOKUPS_VIEW |
Implementation/DBA Data: | Not implemented in this database |
SELECT IES.ROWID
, IES.INQ_ENTRY_STAT_ID
, IES.INQ_ENTRY_STAT
, IES.DESCRIPTION
, EST.ENQUIRY_SOURCE_TYPE
, EST.DESCRIPTION
, IES.ACTIVITY_SOURCE_CD
, LK2.MEANING
, IES.INSTITUTION_TYPE
, CC1.NAME
, IES.TEST_SOURCE_ID
, IES.IMP_SOURCE_TYPE_ID
, PSR.SOURCE_TYPE
, IES.EMAIL_LINK
, IES.HIERARCHY_CD
, LK1.MEANING
, IES.PROG_CODE_REDUC_CD
, LK3.MEANING
, IES.UNIT_SET_REDUC_CD
, LK4.MEANING
, IES.PKG_ITEM_REDUC_CD
, LK5.MEANING
, IES.CLOSED_IND
, IES.CREATED_BY
, IES.CREATION_DATE
, IES.LAST_UPDATED_BY
, IES.LAST_UPDATE_DATE
, IES.LAST_UPDATE_LOGIN
, IES.CONFIGURABILITY_FUNC_NAME
, FFV.USER_FUNCTION_NAME
FROM IGS_AD_I_ENTRY_STATS IES
, IGS_AD_CODE_CLASSES CC1
, IGS_PE_SRC_TYPES PSR
, IGS_IN_ENQ_SRC_TYPE EST
, IGS_LOOKUPS_VIEW LK1
, IGS_LOOKUPS_VIEW LK2
, IGS_LOOKUPS_VIEW LK3
, IGS_LOOKUPS_VIEW LK4
, IGS_LOOKUPS_VIEW LK5
, FND_FORM_FUNCTIONS_VL FFV
WHERE IES.HIERARCHY_CD = LK1.LOOKUP_CODE
AND IES.ACTIVITY_SOURCE_CD = LK2.LOOKUP_CODE(+)
AND IES.ENQUIRY_SOURCE_TYPE = EST.ENQUIRY_SOURCE_TYPE(+)
AND IES.TEST_SOURCE_ID = CC1.CODE_ID (+)
AND IES.IMP_SOURCE_TYPE_ID = PSR.SOURCE_TYPE_ID(+)
AND IES.PROG_CODE_REDUC_CD = LK3.LOOKUP_CODE(+)
AND IES.UNIT_SET_REDUC_CD = LK4.LOOKUP_CODE(+)
AND IES.PKG_ITEM_REDUC_CD = LK5.LOOKUP_CODE(+)
AND LK1.LOOKUP_TYPE = 'HIERARCHY'
AND LK2.LOOKUP_TYPE(+) = 'ACTIVITY_SOURCE'
AND LK3.LOOKUP_TYPE(+) = 'IGS_ITEM_REDUCTION'
AND LK4.LOOKUP_TYPE(+) = 'IGS_ITEM_REDUCTION'
AND LK5.LOOKUP_TYPE(+) = 'IGS_ITEM_REDUCTION'
AND IES.CONFIGURABILITY_FUNC_NAME=FFV.FUNCTION_NAME(+)