VIEW: APPS.IGS_AD_INQ_ENTRY_STAT_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)