VIEW: APPS.IGSBV_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, PSD.MATR_CAL_TYPE, PSD.MATR_SEQUENCE_NUMBER, PSD.INIT_CAL_TYPE, PSD.INIT_SEQUENCE_NUMBER, PSD.RECENT_CAL_TYPE, PSD.RECENT_SEQUENCE_NUMBER, PSD.CATALOG_CAL_TYPE, PSD.CATALOG_SEQUENCE_NUMBER, '_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', 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 WHERE PSD.PERSON_ID=HZP.PARTY_ID 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
, PSD.MATR_CAL_TYPE
, PSD.MATR_SEQUENCE_NUMBER
, PSD.INIT_CAL_TYPE
, PSD.INIT_SEQUENCE_NUMBER
, PSD.RECENT_CAL_TYPE
, PSD.RECENT_SEQUENCE_NUMBER
, PSD.CATALOG_CAL_TYPE
, PSD.CATALOG_SEQUENCE_NUMBER
, '_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'
, 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
WHERE PSD.PERSON_ID=HZP.PARTY_ID WITH READ ONLY