eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSBV_HIGH_EDU_PRG_REFERENCES

Source

View Text - Preformatted


SELECT REC.COURSE_CD PROGRAM_CODE, REC.VERSION_NUMBER PROGRAM_VERSION_NUMBER, REC.REFERENCE_CD_TYPE REFERENCE_CODE_TYPE, REC.REFERENCE_CD REFERENCE_CODE, REC.DESCRIPTION REFERENCE_CODE_DESCRIPTION, VE.TITLE PROGRAM_TITLE, RET.DESCRIPTION REFERENCE_CODE_TYPE_DESC, REC.CREATED_BY, REC.CREATION_DATE, REC.LAST_UPDATED_BY, REC.LAST_UPDATE_DATE FROM IGS_PS_REF_CD REC, IGS_PS_VER_ALL VE, IGS_GE_REF_CD_TYPE_ALL RET WHERE REC.COURSE_CD = VE.COURSE_CD AND REC.VERSION_NUMBER = VE.VERSION_NUMBER AND REC.REFERENCE_CD_TYPE = RET.REFERENCE_CD_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT REC.COURSE_CD PROGRAM_CODE
, REC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, REC.REFERENCE_CD_TYPE REFERENCE_CODE_TYPE
, REC.REFERENCE_CD REFERENCE_CODE
, REC.DESCRIPTION REFERENCE_CODE_DESCRIPTION
, VE.TITLE PROGRAM_TITLE
, RET.DESCRIPTION REFERENCE_CODE_TYPE_DESC
, REC.CREATED_BY
, REC.CREATION_DATE
, REC.LAST_UPDATED_BY
, REC.LAST_UPDATE_DATE
FROM IGS_PS_REF_CD REC
, IGS_PS_VER_ALL VE
, IGS_GE_REF_CD_TYPE_ALL RET
WHERE REC.COURSE_CD = VE.COURSE_CD
AND REC.VERSION_NUMBER = VE.VERSION_NUMBER
AND REC.REFERENCE_CD_TYPE = RET.REFERENCE_CD_TYPE WITH READ ONLY