VIEW: APPS.IGS_AD_INQ_PROG_PREFS_V

Source

View Text - Preformatted

SELECT IPF.RowId, IPF.Inq_Prog_Pref_Id, IPF.Person_Id, IPF.Enquiry_Appl_Number, IPF.Inq_Prog_Code_Id, IP.Inq_Prog_Code, IP.Description, IPF.Prog_Pref_Id, IPF.Program_Application_Id, IPF.Program_Id, IPF.Program_Update_Date, IPF.Request_Id, IPF.Created_By, IPF.Creation_Date, IPF.Last_Updated_By, IPF.Last_Update_Date, IPF.Last_Update_Login , EAP.Enquiry_Dt, EAP.Enquiry_Source_Type FROM IGS_AD_I_PRG_PREFS IPF, IGS_AD_INQ_PROGS IP , IGS_IN_ENQUIRY_APPL EAP WHERE IPF.Inq_Prog_Code_Id = IP.Inq_Prog_Code_Id AND IPF.Person_Id = EAP.Person_Id AND IPF.Enquiry_Appl_Number = EAP.Enquiry_Appl_Number

View Text - HTML Formatted

SELECT IPF.ROWID
, IPF.INQ_PROG_PREF_ID
, IPF.PERSON_ID
, IPF.ENQUIRY_APPL_NUMBER
, IPF.INQ_PROG_CODE_ID
, IP.INQ_PROG_CODE
, IP.DESCRIPTION
, IPF.PROG_PREF_ID
, IPF.PROGRAM_APPLICATION_ID
, IPF.PROGRAM_ID
, IPF.PROGRAM_UPDATE_DATE
, IPF.REQUEST_ID
, IPF.CREATED_BY
, IPF.CREATION_DATE
, IPF.LAST_UPDATED_BY
, IPF.LAST_UPDATE_DATE
, IPF.LAST_UPDATE_LOGIN
, EAP.ENQUIRY_DT
, EAP.ENQUIRY_SOURCE_TYPE
FROM IGS_AD_I_PRG_PREFS IPF
, IGS_AD_INQ_PROGS IP
, IGS_IN_ENQUIRY_APPL EAP
WHERE IPF.INQ_PROG_CODE_ID = IP.INQ_PROG_CODE_ID
AND IPF.PERSON_ID = EAP.PERSON_ID
AND IPF.ENQUIRY_APPL_NUMBER = EAP.ENQUIRY_APPL_NUMBER