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:
Not implemented in this database
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
[Home] [Help]