VIEW: APPS.IGSBV_INTM_RETURN_CONDS

Source

View Text - Preformatted

SELECT SRC.PERSON_ID, SRC.COURSE_CD, SRC.START_DT, SRC.LOGICAL_DELETE_DATE, SRC.RETURN_CONDITION, SRC.STATUS_CODE, SRC.APPROVED_DT, SRC.APPROVED_BY, SRC.CREATED_BY, SRC.CREATION_DATE, SRC.LAST_UPDATED_BY, SRC.LAST_UPDATE_DATE, SRC.LAST_UPDATE_LOGIN, HZ.PARTY_NUMBER, PV.TITLE, RC.DESCRIPTION FROM IGS_EN_SPI_RCONDS SRC, IGS_EN_STDNT_PS_ATT_ALL SPA, IGS_PS_VER_ALL PV, HZ_PARTIES HZ, IGS_EN_INTM_RCONDS RC WHERE RC.RETURN_CONDITION = SRC.RETURN_CONDITION AND HZ.PARTY_ID = SRC.PERSON_ID AND SPA.PERSON_ID = SRC.PERSON_ID AND SPA.COURSE_CD = SRC.COURSE_CD AND PV.COURSE_CD = SPA.COURSE_CD AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT SRC.PERSON_ID
, SRC.COURSE_CD
, SRC.START_DT
, SRC.LOGICAL_DELETE_DATE
, SRC.RETURN_CONDITION
, SRC.STATUS_CODE
, SRC.APPROVED_DT
, SRC.APPROVED_BY
, SRC.CREATED_BY
, SRC.CREATION_DATE
, SRC.LAST_UPDATED_BY
, SRC.LAST_UPDATE_DATE
, SRC.LAST_UPDATE_LOGIN
, HZ.PARTY_NUMBER
, PV.TITLE
, RC.DESCRIPTION
FROM IGS_EN_SPI_RCONDS SRC
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PV
, HZ_PARTIES HZ
, IGS_EN_INTM_RCONDS RC
WHERE RC.RETURN_CONDITION = SRC.RETURN_CONDITION
AND HZ.PARTY_ID = SRC.PERSON_ID
AND SPA.PERSON_ID = SRC.PERSON_ID
AND SPA.COURSE_CD = SRC.COURSE_CD
AND PV.COURSE_CD = SPA.COURSE_CD
AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER WITH READ ONLY