VIEW: APPS.IGSBV_ST_HESA_ADMISSION_DETAIL

Source

View Text - Preformatted

SELECT had.HESA_AD_DTL_ID HESA_AD_DTL_ID, had.PERSON_ID PERSON_ID, per.PARTY_NUMBER PERSON_NUMBER, had.NOMINATED_COURSE_CD NOMINATED_PROGRAM_CODE, had.ADMISSION_APPL_NUMBER ADMISSION_APPLICATION_NUMBER, had.SEQUENCE_NUMBER SEQUENCE_NUMBER, had.OCCUPATION_CD OCCUPATION_CODE, had.DOMICILE_CD DOMICILE_CODE, had.SOCIAL_CLASS_CD SOCIAL_CLASS_CODE, had.SPECIAL_STUDENT_CD SPECIAL_STUDENT_CODE, had.CREATION_DATE CREATION_DATE, had.CREATED_BY CREATED_BY, had.LAST_UPDATE_DATE LAST_UPDATE_DATE, had.LAST_UPDATED_BY LAST_UPDATED_BY FROM IGS_HE_AD_DTL_ALL had, HZ_PARTIES per WHERE per.PARTY_ID = had.PERSON_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HAD.HESA_AD_DTL_ID HESA_AD_DTL_ID
, HAD.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, HAD.NOMINATED_COURSE_CD NOMINATED_PROGRAM_CODE
, HAD.ADMISSION_APPL_NUMBER ADMISSION_APPLICATION_NUMBER
, HAD.SEQUENCE_NUMBER SEQUENCE_NUMBER
, HAD.OCCUPATION_CD OCCUPATION_CODE
, HAD.DOMICILE_CD DOMICILE_CODE
, HAD.SOCIAL_CLASS_CD SOCIAL_CLASS_CODE
, HAD.SPECIAL_STUDENT_CD SPECIAL_STUDENT_CODE
, HAD.CREATION_DATE CREATION_DATE
, HAD.CREATED_BY CREATED_BY
, HAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HAD.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_HE_AD_DTL_ALL HAD
, HZ_PARTIES PER
WHERE PER.PARTY_ID = HAD.PERSON_ID WITH READ ONLY