VIEW: APPS.IGF_AP_APP_ST_APLINST_V

Source

View Text - Preformatted

SELECT st.rowid row_id,fa.base_id,fa.person_id,pe.person_number, api.api_person_id SSN,fa.ci_cal_type,fa.ci_sequence_number, ca.alternate_code ci_alternate_code,ca.start_dt,ca.end_dt, pe.surname,pe.given_names, st.question_id,st.question_value,st.inst_app_id,ap.question,ap.org_id, st.created_by,st.creation_date,st.last_updated_by,st.last_update_date, st.last_update_login from igf_ap_st_inst_appl st, igf_ap_appl_setup ap, igf_ap_fa_base_rec fa, igs_pe_person pe,igs_ca_inst ca,igs_pe_alt_pers_id api WHERE st.question_id= ap.question_id and st.base_id = fa.base_id and ap.ci_cal_type=fa.ci_cal_type and ap.ci_sequence_number=fa.ci_sequence_number and fa.ci_cal_type=ca.cal_type and fa.ci_sequence_number=ca.sequence_number and fa.person_id=pe.person_id and api.pe_person_id=fa.person_id and api.person_id_type like 'SSN'

View Text - HTML Formatted

SELECT ST.ROWID ROW_ID
, FA.BASE_ID
, FA.PERSON_ID
, PE.PERSON_NUMBER
, API.API_PERSON_ID SSN
, FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE CI_ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, PE.SURNAME
, PE.GIVEN_NAMES
, ST.QUESTION_ID
, ST.QUESTION_VALUE
, ST.INST_APP_ID
, AP.QUESTION
, AP.ORG_ID
, ST.CREATED_BY
, ST.CREATION_DATE
, ST.LAST_UPDATED_BY
, ST.LAST_UPDATE_DATE
, ST.LAST_UPDATE_LOGIN
FROM IGF_AP_ST_INST_APPL ST
, IGF_AP_APPL_SETUP AP
, IGF_AP_FA_BASE_REC FA
, IGS_PE_PERSON PE
, IGS_CA_INST CA
, IGS_PE_ALT_PERS_ID API
WHERE ST.QUESTION_ID= AP.QUESTION_ID
AND ST.BASE_ID = FA.BASE_ID
AND AP.CI_CAL_TYPE=FA.CI_CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER=FA.CI_SEQUENCE_NUMBER
AND FA.CI_CAL_TYPE=CA.CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER=CA.SEQUENCE_NUMBER
AND FA.PERSON_ID=PE.PERSON_ID
AND API.PE_PERSON_ID=FA.PERSON_ID
AND API.PERSON_ID_TYPE LIKE 'SSN'