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.
[Home] [Help]
View: IGSBV_ALTERNATV_PRG_EXITS
Product: IGS - Student System
Description: This is the base view which describes the possible alternative exit points from a program. This consists of another program, often of a lower level (where an early exit is granted).
Implementation/DBA Data:
APPS.IGSBV_ALTERNATV_PRG_EXITS
View Text
SELECT ALT.COURSE_CD , ALT.VERSION_NUMBER , ALT.EXIT_COURSE_CD , ALT.EXIT_VERSION_SET , VER1.TITLE , VER2.TITLE , ALT.CREATED_BY , ALT.CREATION_DATE , ALT.LAST_UPDATED_BY , ALT.LAST_UPDATE_DATE FROM IGS_PE_ALTERNATV_EXT ALT , IGS_PS_VER_ALL VER1 , IGS_PS_VER_ALL VER2 , IGS_PS_COURSE CO WHERE ALT.COURSE_CD = VER1.COURSE_CD AND ALT.VERSION_NUMBER = VER1.VERSION_NUMBER AND ALT.EXIT_COURSE_CD = CO.COURSE_CD AND CO.COURSE_CD = VER2.COURSE_CD AND VER2.VERSION_NUMBER = (SELECT MAX(VERSION_NUMBER) FROM IGS_PS_VER_ALL WHERE COURSE_CD = ALT.EXIT_COURSE_CD) WITH READ ONLY
Columns
Name
PROGRAM_CODE
VERSION_NUMBER
EXIT_PROGRAM_CODE
EXIT_VERSION_SET
PROGRAM_CODE_TITLE
EXIT_PROGRAM_CODE_TITLE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE