VIEW: APPS.IGFFV_STU_INST_APPLICATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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