VIEW: APPS.IGSFV_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, HZ1.PARTY_NUMBER, PV.TITLE, RC.DESCRIPTION, '_LA:STATUS_CODE:IGS_LOOKUP_VALUES:IGS_EN_INTM_RCOND_STS:MEANING', HZ2.PARTY_NUMBER FROM IGS_EN_SPI_RCONDS SRC, HZ_PARTIES HZ1, HZ_PARTIES HZ2, IGS_EN_INTM_RCONDS RC, IGS_EN_STDNT_PS_ATT_ALL SPA, IGS_PS_VER_ALL PV WHERE RC.RETURN_CONDITION = SRC.RETURN_CONDITION AND HZ1.PARTY_ID = SRC.PERSON_ID AND HZ2.PARTY_ID(+) = SRC.APPROVED_BY 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
, HZ1.PARTY_NUMBER
, PV.TITLE
, RC.DESCRIPTION
, '_LA:STATUS_CODE:IGS_LOOKUP_VALUES:IGS_EN_INTM_RCOND_STS:MEANING'
, HZ2.PARTY_NUMBER
FROM IGS_EN_SPI_RCONDS SRC
, HZ_PARTIES HZ1
, HZ_PARTIES HZ2
, IGS_EN_INTM_RCONDS RC
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PV
WHERE RC.RETURN_CONDITION = SRC.RETURN_CONDITION
AND HZ1.PARTY_ID = SRC.PERSON_ID
AND HZ2.PARTY_ID(+) = SRC.APPROVED_BY
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