VIEW: APPS.IGS_AS_GPC_PROGRAMS_V

Source

View Text - Preformatted

SELECT GPR.ROWID ROW_ID, GPR.GPC_PROGRAM_ID GPC_PROGRAM_ID, GPR.GRADING_PERIOD_CD GRADING_PERIOD_CD, LKUP.MEANING GRADING_PERIOD, GPR.COURSE_CD COURSE_CD, GPR.COURSE_VERSION_NUMBER COURSE_VERSION_NUMBER, PRGV.TITLE COURSE_TITLE, GPR.CREATED_BY CREATED_BY, GPR.CREATION_DATE CREATION_DATE, GPR.LAST_UPDATED_BY LAST_UPDATED_BY, GPR.LAST_UPDATE_DATE LAST_UPDATE_DATE, GPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_GPC_PROGRAMS GPR, IGS_LOOKUPS_VIEW LKUP, IGS_PS_VER PRGV WHERE GPR.GRADING_PERIOD_CD=LKUP.LOOKUP_CODE AND LKUP.LOOKUP_TYPE='AS_GRADING_PERIOD' AND GPR.COURSE_CD=PRGV.COURSE_CD AND GPR.COURSE_VERSION_NUMBER=PRGV.VERSION_NUMBER

View Text - HTML Formatted

SELECT GPR.ROWID ROW_ID
, GPR.GPC_PROGRAM_ID GPC_PROGRAM_ID
, GPR.GRADING_PERIOD_CD GRADING_PERIOD_CD
, LKUP.MEANING GRADING_PERIOD
, GPR.COURSE_CD COURSE_CD
, GPR.COURSE_VERSION_NUMBER COURSE_VERSION_NUMBER
, PRGV.TITLE COURSE_TITLE
, GPR.CREATED_BY CREATED_BY
, GPR.CREATION_DATE CREATION_DATE
, GPR.LAST_UPDATED_BY LAST_UPDATED_BY
, GPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_GPC_PROGRAMS GPR
, IGS_LOOKUPS_VIEW LKUP
, IGS_PS_VER PRGV
WHERE GPR.GRADING_PERIOD_CD=LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE='AS_GRADING_PERIOD'
AND GPR.COURSE_CD=PRGV.COURSE_CD
AND GPR.COURSE_VERSION_NUMBER=PRGV.VERSION_NUMBER