DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_DEPLVL_PRG_V

Source

View Text - Preformatted

SELECT DLPG.ROWID, DLPG.ADMISSION_APPLICATION_TYPE, DLPG.PROGRAM_CODE, PV.TITLE, DLPG.VERSION_NUMBER, DLPG.CLOSED_IND, DLPG.CREATED_BY, DLPG.CREATION_DATE, DLPG.LAST_UPDATED_BY, DLPG.LAST_UPDATE_DATE, DLPG.LAST_UPDATE_LOGIN FROM IGS_AD_DEPLVL_PRG DLPG, IGS_PS_VER PV WHERE DLPG.PROGRAM_CODE = PV.COURSE_CD AND DLPG.VERSION_NUMBER = PV.VERSION_NUMBER
View Text - HTML Formatted

SELECT DLPG.ROWID
, DLPG.ADMISSION_APPLICATION_TYPE
, DLPG.PROGRAM_CODE
, PV.TITLE
, DLPG.VERSION_NUMBER
, DLPG.CLOSED_IND
, DLPG.CREATED_BY
, DLPG.CREATION_DATE
, DLPG.LAST_UPDATED_BY
, DLPG.LAST_UPDATE_DATE
, DLPG.LAST_UPDATE_LOGIN
FROM IGS_AD_DEPLVL_PRG DLPG
, IGS_PS_VER PV
WHERE DLPG.PROGRAM_CODE = PV.COURSE_CD
AND DLPG.VERSION_NUMBER = PV.VERSION_NUMBER