DBA Data[Home] [Help]

VIEW: APPS.IGS_EN_PSV_TERM_IT_V

Source

View Text - Preformatted

SELECT PTIT.ROWID, PTIT.CAL_TYPE, PTIT.SEQUENCE_NUMBER, PTIT.COURSE_CD, PTIT.VERSION_NUMBER, PSV.TITLE, PTIT.TERM_INSTRUCTION_TIME, PTIT.CREATED_BY, PTIT.CREATION_DATE, PTIT.LAST_UPDATED_BY , PTIT.LAST_UPDATE_DATE, PTIT.LAST_UPDATE_LOGIN FROM IGS_EN_PSV_TERM_IT PTIT, IGS_PS_VER_ALL PSV WHERE PTIT.COURSE_CD = PSV.COURSE_CD AND PTIT.VERSION_NUMBER = PSV.VERSION_NUMBER
View Text - HTML Formatted

SELECT PTIT.ROWID
, PTIT.CAL_TYPE
, PTIT.SEQUENCE_NUMBER
, PTIT.COURSE_CD
, PTIT.VERSION_NUMBER
, PSV.TITLE
, PTIT.TERM_INSTRUCTION_TIME
, PTIT.CREATED_BY
, PTIT.CREATION_DATE
, PTIT.LAST_UPDATED_BY
, PTIT.LAST_UPDATE_DATE
, PTIT.LAST_UPDATE_LOGIN
FROM IGS_EN_PSV_TERM_IT PTIT
, IGS_PS_VER_ALL PSV
WHERE PTIT.COURSE_CD = PSV.COURSE_CD
AND PTIT.VERSION_NUMBER = PSV.VERSION_NUMBER