SELECT GRM.COURSE_CD PROGRAM_CODE, GRM.VERSION_NUMBER PROGRAM_VERSION_NUMBER, GRM.COURSE_GROUP_CD PROGRAM_GROUP_CODE, VE.TITLE PROGRAM_TITLE, GRA.DESCRIPTION PROGRAM_GROUP_DESCRIPTION, GRM.CREATED_BY, GRM.CREATION_DATE, GRM.LAST_UPDATED_BY, GRM.LAST_UPDATE_DATE FROM IGS_PS_GRP_MBR GRM, IGS_PS_VER_ALL VE, IGS_PS_GRP_ALL GRA WHERE GRM.COURSE_CD = VE.COURSE_CD AND GRM.VERSION_NUMBER = VE.VERSION_NUMBER AND GRM.COURSE_GROUP_CD = GRA.COURSE_GROUP_CD WITH READ ONLY
SELECT GRM.COURSE_CD PROGRAM_CODE
, GRM.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, GRM.COURSE_GROUP_CD PROGRAM_GROUP_CODE
, VE.TITLE PROGRAM_TITLE
, GRA.DESCRIPTION PROGRAM_GROUP_DESCRIPTION
, GRM.CREATED_BY
, GRM.CREATION_DATE
, GRM.LAST_UPDATED_BY
, GRM.LAST_UPDATE_DATE
FROM IGS_PS_GRP_MBR GRM
, IGS_PS_VER_ALL VE
, IGS_PS_GRP_ALL GRA
WHERE GRM.COURSE_CD = VE.COURSE_CD
AND GRM.VERSION_NUMBER = VE.VERSION_NUMBER
AND GRM.COURSE_GROUP_CD = GRA.COURSE_GROUP_CD WITH READ ONLY
|
|
|