View: IGFFV_STU_INST_APPLICATIONS

Product:	IGF - Financial Aid
Description:	Contains the values for all the user-defined questions
Implementation/DBA Data:	APPS.IGFFV_STU_INST_APPLICATIONS

View Text

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, IAS.QUESTION
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, SIA.QUESTION_VALUE
, SIA.INST_APP_ID
, SIA.BASE_ID
, SIA.QUESTION_ID
, SIA.CREATED_BY
, SIA.CREATION_DATE
, SIA.LAST_UPDATED_BY
, SIA.LAST_UPDATE_DATE
, SIA.APPLICATION_CODE
, FA_DETAIL.PERSON_ID
FROM IGF_AP_ST_INST_APPL_ALL SIA
, IGF_AP_FA_BASE_REC_ALL FA_DETAIL
, HZ_PARTIES HP
, IGF_AP_APPL_SETUP_ALL IAS
, IGS_CA_INST_ALL CI
WHERE SIA.BASE_ID = FA_DETAIL.BASE_ID AND FA_DETAIL.PERSON_ID = HP.PARTY_ID AND SIA.QUESTION_ID = IAS.QUESTION_ID
AND SIA.APPLICATION_CODE = IAS.APPLICATION_CODE AND IAS.CI_CAL_TYPE = CI.CAL_TYPE AND IAS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

Columns