VIEW: APPS.IGSFV_ACADEMIC_CATALOGS

Source

View Text - Preformatted

SELECT HZP.PARTY_NUMBER, PSD.EFFECTIVE_START_DATE, PSD.EFFECTIVE_END_DATE, PSD.IN_STATE_TUITION, PSD.TUITION_ST_DATE, PSD.TUITION_END_DATE, CIA1.ALTERNATE_CODE, PSD.MATR_CAL_TYPE, PSD.MATR_SEQUENCE_NUMBER, CIA1.START_DT, CIA1.END_DT, CIA2.ALTERNATE_CODE, PSD.INIT_CAL_TYPE, PSD.INIT_SEQUENCE_NUMBER, CIA2.START_DT, CIA2.END_DT, CIA3.ALTERNATE_CODE, PSD.RECENT_CAL_TYPE, PSD.RECENT_SEQUENCE_NUMBER, CIA3.START_DT, CIA3.END_DT, CIA4.ALTERNATE_CODE, PSD.CATALOG_CAL_TYPE, PSD.CATALOG_SEQUENCE_NUMBER, CIA4.START_DT, CIA4.END_DT, '_LA:PSD.FURTHER_EDUCATION_CD:IGS_LOOKUP_VALUES:PE_FUR_EDU:MEANING', '_LA:PSD.RELIGION_CD:IGS_LOOKUP_VALUES:PE_RELIGION:MEANING', '_LA:PSD.SOCIO_ECO_CD:IGS_LOOKUP_VALUES:PE_SOCECO_STAT:MEANING', '_DF:IGS:IGS_PE_PERS_STAT:PSD', PSD.PERSON_ID, PSD.CREATION_DATE, PSD.CREATED_BY, PSD.LAST_UPDATED_BY, PSD.LAST_UPDATE_DATE FROM IGS_PE_STAT_DETAILS PSD, HZ_PARTIES HZP, IGS_CA_INST_ALL CIA1, IGS_CA_INST_ALL CIA2, IGS_CA_INST_ALL CIA3, IGS_CA_INST_ALL CIA4 WHERE PSD.PERSON_ID=HZP.PARTY_ID AND CIA1.CAL_TYPE(+)=PSD.MATR_CAL_TYPE AND CIA1.SEQUENCE_NUMBER(+)=PSD.MATR_SEQUENCE_NUMBER AND CIA2.CAL_TYPE(+)=PSD.INIT_CAL_TYPE AND CIA2.SEQUENCE_NUMBER(+)=PSD.INIT_SEQUENCE_NUMBER AND CIA3.CAL_TYPE(+)=PSD.RECENT_CAL_TYPE AND CIA3.SEQUENCE_NUMBER(+)=RECENT_SEQUENCE_NUMBER AND CIA4.CAL_TYPE(+)=PSD.CATALOG_CAL_TYPE AND CIA4.SEQUENCE_NUMBER(+)=PSD.CATALOG_SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT HZP.PARTY_NUMBER
, PSD.EFFECTIVE_START_DATE
, PSD.EFFECTIVE_END_DATE
, PSD.IN_STATE_TUITION
, PSD.TUITION_ST_DATE
, PSD.TUITION_END_DATE
, CIA1.ALTERNATE_CODE
, PSD.MATR_CAL_TYPE
, PSD.MATR_SEQUENCE_NUMBER
, CIA1.START_DT
, CIA1.END_DT
, CIA2.ALTERNATE_CODE
, PSD.INIT_CAL_TYPE
, PSD.INIT_SEQUENCE_NUMBER
, CIA2.START_DT
, CIA2.END_DT
, CIA3.ALTERNATE_CODE
, PSD.RECENT_CAL_TYPE
, PSD.RECENT_SEQUENCE_NUMBER
, CIA3.START_DT
, CIA3.END_DT
, CIA4.ALTERNATE_CODE
, PSD.CATALOG_CAL_TYPE
, PSD.CATALOG_SEQUENCE_NUMBER
, CIA4.START_DT
, CIA4.END_DT
, '_LA:PSD.FURTHER_EDUCATION_CD:IGS_LOOKUP_VALUES:PE_FUR_EDU:MEANING'
, '_LA:PSD.RELIGION_CD:IGS_LOOKUP_VALUES:PE_RELIGION:MEANING'
, '_LA:PSD.SOCIO_ECO_CD:IGS_LOOKUP_VALUES:PE_SOCECO_STAT:MEANING'
, '_DF:IGS:IGS_PE_PERS_STAT:PSD'
, PSD.PERSON_ID
, PSD.CREATION_DATE
, PSD.CREATED_BY
, PSD.LAST_UPDATED_BY
, PSD.LAST_UPDATE_DATE
FROM IGS_PE_STAT_DETAILS PSD
, HZ_PARTIES HZP
, IGS_CA_INST_ALL CIA1
, IGS_CA_INST_ALL CIA2
, IGS_CA_INST_ALL CIA3
, IGS_CA_INST_ALL CIA4
WHERE PSD.PERSON_ID=HZP.PARTY_ID
AND CIA1.CAL_TYPE(+)=PSD.MATR_CAL_TYPE
AND CIA1.SEQUENCE_NUMBER(+)=PSD.MATR_SEQUENCE_NUMBER
AND CIA2.CAL_TYPE(+)=PSD.INIT_CAL_TYPE
AND CIA2.SEQUENCE_NUMBER(+)=PSD.INIT_SEQUENCE_NUMBER
AND CIA3.CAL_TYPE(+)=PSD.RECENT_CAL_TYPE
AND CIA3.SEQUENCE_NUMBER(+)=RECENT_SEQUENCE_NUMBER
AND CIA4.CAL_TYPE(+)=PSD.CATALOG_CAL_TYPE
AND CIA4.SEQUENCE_NUMBER(+)=PSD.CATALOG_SEQUENCE_NUMBER WITH READ ONLY