VIEW: APPS.IGSFV_STDNT_PRG_INTERMISSIONS

Source

View Text - Preformatted

SELECT SCI.PERSON_ID, HP1.PARTY_NUMBER, HP1.PARTY_NAME, SCI.COURSE_CD, PS.TITLE , SCI.INTERMISSION_TYPE, EITY.DESCRIPTION, SCI. START_DT, SCI.END_DT, SCI.VOLUNTARY_IND, '_LA:VOLUNTARY_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', SCI.COMMENTS, SCI.APPROVED, '_LA:APPROVED:IGS_LOOKUP_VALUES:YES_NO:MEANING', SCI.INSTITUTION_NAME, HP3.PARTY_NUMBER, SCI.MAX_CREDIT_PTS, SCI.MAX_TERMS, SCI.ANTICIPATED_CREDIT_POINTS, '_DF:IGS:IGS_EN_STDNT_INTM_FLEX:SCI', SCI.APPROVER_ID, HP2.PARTY_NUMBER, HP2.PARTY_NAME, SCI.CREATED_BY, SCI.CREATION_DATE, SCI.LAST_UPDATED_BY, SCI.LAST_UPDATE_DATE, SCI.LOGICAL_DELETE_DATE, SCI.COND_RETURN_FLAG FROM IGS_EN_STDNT_PS_INTM SCI, HZ_PARTIES HP1, HZ_PARTIES HP2, HZ_PARTIES HP3, IGS_EN_INTM_TYPES EITY , IGS_EN_STDNT_PS_ATT_ALL SPA, IGS_PS_VER_ALL PS WHERE SCI.PERSON_ID = HP1.PARTY_ID AND SCI.PERSON_ID = SPA.PERSON_ID AND SCI.COURSE_CD = SPA.COURSE_CD AND SPA.COURSE_CD = PS.COURSE_CD AND SPA.VERSION_NUMBER = PS.VERSION_NUMBER AND SCI.APPROVER_ID = HP2.PARTY_ID (+) AND SCI.INSTITUTION_NAME = HP3.PARTY_NAME (+) AND SCI.INTERMISSION_TYPE = EITY.INTERMISSION_TYPE (+) WITH READ ONLY

View Text - HTML Formatted

SELECT SCI.PERSON_ID
, HP1.PARTY_NUMBER
, HP1.PARTY_NAME
, SCI.COURSE_CD
, PS.TITLE
, SCI.INTERMISSION_TYPE
, EITY.DESCRIPTION
, SCI. START_DT
, SCI.END_DT
, SCI.VOLUNTARY_IND
, '_LA:VOLUNTARY_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SCI.COMMENTS
, SCI.APPROVED
, '_LA:APPROVED:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SCI.INSTITUTION_NAME
, HP3.PARTY_NUMBER
, SCI.MAX_CREDIT_PTS
, SCI.MAX_TERMS
, SCI.ANTICIPATED_CREDIT_POINTS
, '_DF:IGS:IGS_EN_STDNT_INTM_FLEX:SCI'
, SCI.APPROVER_ID
, HP2.PARTY_NUMBER
, HP2.PARTY_NAME
, SCI.CREATED_BY
, SCI.CREATION_DATE
, SCI.LAST_UPDATED_BY
, SCI.LAST_UPDATE_DATE
, SCI.LOGICAL_DELETE_DATE
, SCI.COND_RETURN_FLAG
FROM IGS_EN_STDNT_PS_INTM SCI
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, HZ_PARTIES HP3
, IGS_EN_INTM_TYPES EITY
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PS
WHERE SCI.PERSON_ID = HP1.PARTY_ID
AND SCI.PERSON_ID = SPA.PERSON_ID
AND SCI.COURSE_CD = SPA.COURSE_CD
AND SPA.COURSE_CD = PS.COURSE_CD
AND SPA.VERSION_NUMBER = PS.VERSION_NUMBER
AND SCI.APPROVER_ID = HP2.PARTY_ID (+)
AND SCI.INSTITUTION_NAME = HP3.PARTY_NAME (+)
AND SCI.INTERMISSION_TYPE = EITY.INTERMISSION_TYPE (+) WITH READ ONLY