VIEW: APPS.IGS_EN_STDNT_PS_INTM_V

Source

View Text - Preformatted

SELECT espi.ROWID, espi.PERSON_ID, espi.COURSE_CD, eit.INTERMISSION_TYPE, eit.DESCRIPTION, espi.APPROVED, espi.INSTITUTION_NAME INSTITUTION_CD, ioie.NAME INSTITUTION_NAME, espi.MAX_CREDIT_PTS, espi.MAX_TERMS, espi.ANTICIPATED_CREDIT_POINTS, espi.APPROVER_ID, hp.PARTY_NUMBER APPROVER_NUMBER, hp.PARTY_NAME APPROVER_NAME, espi.START_DT, espi.logical_delete_date, espi.END_DT, espi.VOLUNTARY_IND, espi.COMMENTS, espi.CREATED_BY, espi.CREATION_DATE, espi.LAST_UPDATED_BY, espi.LAST_UPDATE_DATE, espi.LAST_UPDATE_LOGIN ,espi.ATTRIBUTE_CATEGORY ,espi.ATTRIBUTE1 ,espi.ATTRIBUTE2 ,espi.ATTRIBUTE3 ,espi.ATTRIBUTE4 ,espi.ATTRIBUTE5 ,espi.ATTRIBUTE6 ,espi.ATTRIBUTE7 ,espi.ATTRIBUTE8 ,espi.ATTRIBUTE9 ,espi.ATTRIBUTE10 ,espi.ATTRIBUTE11 ,espi.ATTRIBUTE12 ,espi.ATTRIBUTE13 ,espi.ATTRIBUTE14 ,espi.ATTRIBUTE15 ,espi.ATTRIBUTE16 ,espi.ATTRIBUTE17 ,espi.ATTRIBUTE18 ,espi.ATTRIBUTE19 ,espi.ATTRIBUTE20 ,espi.COND_RETURN_FLAG FROM IGS_EN_STDNT_PS_INTM espi, IGS_EN_INTM_TYPES eit, HZ_PARTIES hp, igs_or_inst_exempt_v ioie WHERE espi.INTERMISSION_TYPE = eit.INTERMISSION_TYPE(+) AND espi.APPROVER_ID = hp.PARTY_ID(+) AND ioie. EXEMPTION_INSTITUTION_CD(+) = espi.INSTITUTION_NAME

View Text - HTML Formatted

SELECT ESPI.ROWID
, ESPI.PERSON_ID
, ESPI.COURSE_CD
, EIT.INTERMISSION_TYPE
, EIT.DESCRIPTION
, ESPI.APPROVED
, ESPI.INSTITUTION_NAME INSTITUTION_CD
, IOIE.NAME INSTITUTION_NAME
, ESPI.MAX_CREDIT_PTS
, ESPI.MAX_TERMS
, ESPI.ANTICIPATED_CREDIT_POINTS
, ESPI.APPROVER_ID
, HP.PARTY_NUMBER APPROVER_NUMBER
, HP.PARTY_NAME APPROVER_NAME
, ESPI.START_DT
, ESPI.LOGICAL_DELETE_DATE
, ESPI.END_DT
, ESPI.VOLUNTARY_IND
, ESPI.COMMENTS
, ESPI.CREATED_BY
, ESPI.CREATION_DATE
, ESPI.LAST_UPDATED_BY
, ESPI.LAST_UPDATE_DATE
, ESPI.LAST_UPDATE_LOGIN
, ESPI.ATTRIBUTE_CATEGORY
, ESPI.ATTRIBUTE1
, ESPI.ATTRIBUTE2
, ESPI.ATTRIBUTE3
, ESPI.ATTRIBUTE4
, ESPI.ATTRIBUTE5
, ESPI.ATTRIBUTE6
, ESPI.ATTRIBUTE7
, ESPI.ATTRIBUTE8
, ESPI.ATTRIBUTE9
, ESPI.ATTRIBUTE10
, ESPI.ATTRIBUTE11
, ESPI.ATTRIBUTE12
, ESPI.ATTRIBUTE13
, ESPI.ATTRIBUTE14
, ESPI.ATTRIBUTE15
, ESPI.ATTRIBUTE16
, ESPI.ATTRIBUTE17
, ESPI.ATTRIBUTE18
, ESPI.ATTRIBUTE19
, ESPI.ATTRIBUTE20
, ESPI.COND_RETURN_FLAG
FROM IGS_EN_STDNT_PS_INTM ESPI
, IGS_EN_INTM_TYPES EIT
, HZ_PARTIES HP
, IGS_OR_INST_EXEMPT_V IOIE
WHERE ESPI.INTERMISSION_TYPE = EIT.INTERMISSION_TYPE(+)
AND ESPI.APPROVER_ID = HP.PARTY_ID(+)
AND IOIE. EXEMPTION_INSTITUTION_CD(+) = ESPI.INSTITUTION_NAME