VIEW: APPS.IGSBV_STDNT_PRG_INTERMISSIONS

Source

View Text - Preformatted

SELECT SCI.PERSON_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, SCI.COURSE_CD, SCI.INTERMISSION_TYPE, 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, SCI.MAX_CREDIT_PTS, SCI.MAX_TERMS, SCI.ANTICIPATED_CREDIT_POINTS, SCI.APPROVER_ID, 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 HP WHERE SCI.PERSON_ID = HP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT SCI.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SCI.COURSE_CD
, SCI.INTERMISSION_TYPE
, 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
, SCI.MAX_CREDIT_PTS
, SCI.MAX_TERMS
, SCI.ANTICIPATED_CREDIT_POINTS
, SCI.APPROVER_ID
, 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 HP
WHERE SCI.PERSON_ID = HP.PARTY_ID WITH READ ONLY