VIEW: APPS.IGSBV_STUDENT_PRG_TRANSFERS

Source

View Text - Preformatted

SELECT PST. PERSON_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, PST.COURSE_CD, PSV.TITLE, PST.TRANSFER_COURSE_CD, PSV1.TITLE, PST.TRANSFER_DT, PST.COMMENTS, PST.CREATED_BY, PST.CREATION_DATE, PST.LAST_UPDATED_BY, PST.LAST_UPDATE_DATE, PST.APPROVED_DATE, PST.EFFECTIVE_TERM_CAL_TYPE, PST.EFFECTIVE_TERM_SEQUENCE_NUM, PST.DISCONTINUE_SOURCE_FLAG, PST. TRANSFER_ADV_STAND_FLAG, PST. UOOIDS_TO_TRANSFER, PST. SUSA_TO_TRANSFER, PST.STATUS_FLAG, PST.STATUS_DATE FROM IGS_PS_STDNT_TRN PST, HZ_PARTIES HP, IGS_EN_STDNT_PS_ATT_ALL SCA, IGS_EN_STDNT_PS_ATT_ALL SCA1, IGS_PS_VER_ALL PSV, IGS_PS_VER_ALL PSV1 WHERE PST.PERSON_ID = HP.PARTY_ID AND PST.PERSON_ID = SCA.PERSON_ID AND PST.COURSE_CD = SCA.COURSE_CD AND PST.COURSE_CD = PSV.COURSE_CD AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER AND PST.PERSON_ID = SCA1.PERSON_ID AND PST.TRANSFER_COURSE_CD = SCA1.COURSE_CD AND PST.TRANSFER_COURSE_CD = PSV1.COURSE_CD AND SCA1.VERSION_NUMBER = PSV1.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT PST. PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, PST.COURSE_CD
, PSV.TITLE
, PST.TRANSFER_COURSE_CD
, PSV1.TITLE
, PST.TRANSFER_DT
, PST.COMMENTS
, PST.CREATED_BY
, PST.CREATION_DATE
, PST.LAST_UPDATED_BY
, PST.LAST_UPDATE_DATE
, PST.APPROVED_DATE
, PST.EFFECTIVE_TERM_CAL_TYPE
, PST.EFFECTIVE_TERM_SEQUENCE_NUM
, PST.DISCONTINUE_SOURCE_FLAG
, PST. TRANSFER_ADV_STAND_FLAG
, PST. UOOIDS_TO_TRANSFER
, PST. SUSA_TO_TRANSFER
, PST.STATUS_FLAG
, PST.STATUS_DATE
FROM IGS_PS_STDNT_TRN PST
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_EN_STDNT_PS_ATT_ALL SCA1
, IGS_PS_VER_ALL PSV
, IGS_PS_VER_ALL PSV1
WHERE PST.PERSON_ID = HP.PARTY_ID
AND PST.PERSON_ID = SCA.PERSON_ID
AND PST.COURSE_CD = SCA.COURSE_CD
AND PST.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND PST.PERSON_ID = SCA1.PERSON_ID
AND PST.TRANSFER_COURSE_CD = SCA1.COURSE_CD
AND PST.TRANSFER_COURSE_CD = PSV1.COURSE_CD
AND SCA1.VERSION_NUMBER = PSV1.VERSION_NUMBER WITH READ ONLY