VIEW: APPS.IGS_EN_SPA_TERMS_V

Source

View Text - Preformatted

SELECT SPAT.ROWID, SPAT. TERM_RECORD_ID, SPAT.PERSON_ID, SPAT.PROGRAM_CD, SPAT.PROGRAM_VERSION, CV.COURSE_TYPE CAREER, SPAT.COO_ID, SPAT.ACAD_CAL_TYPE, SPAT.TERM_CAL_TYPE, SPAT.TERM_SEQUENCE_NUMBER, CI.DESCRIPTION DESCRIPTION_TERM, SPAT.KEY_PROGRAM_FLAG, SPAT.LOCATION_CD, SPAT.ATTENDANCE_MODE, SPAT.ATTENDANCE_TYPE, SPAT.FEE_CAT, SPAT.CLASS_STANDING_ID, PRCS.CLASS_STANDING, CI.START_DT, CI.END_DT, SPAT.PLAN_SHT_STATUS, SPAT.CREATED_BY, SPAT.CREATION_DATE, SPAT.LAST_UPDATED_BY, SPAT.LAST_UPDATE_DATE, SPAT.LAST_UPDATE_LOGIN, SPAT.REQUEST_ID, SPAT.PROGRAM_APPLICATION_ID, SPAT.PROGRAM_ID, SPAT.PROGRAM_UPDATE_DATE, SPAT.ATTRIBUTE_CATEGORY, SPAT.ATTRIBUTE1, SPAT.ATTRIBUTE2, SPAT.ATTRIBUTE3, SPAT.ATTRIBUTE4, SPAT.ATTRIBUTE5, SPAT.ATTRIBUTE6, SPAT.ATTRIBUTE7, SPAT.ATTRIBUTE8, SPAT.ATTRIBUTE9, SPAT.ATTRIBUTE10, SPAT.ATTRIBUTE11, SPAT.ATTRIBUTE12, SPAT.ATTRIBUTE13, SPAT.ATTRIBUTE14, SPAT.ATTRIBUTE15, SPAT.ATTRIBUTE16, SPAT.ATTRIBUTE17, SPAT.ATTRIBUTE18, SPAT.ATTRIBUTE19, SPAT.ATTRIBUTE20 FROM IGS_EN_SPA_TERMS SPAT, IGS_CA_INST CI, IGS_PS_VER CV, IGS_PR_CLASS_STD PRCS WHERE SPAT.TERM_CAL_TYPE = CI.CAL_TYPE AND SPAT.TERM_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND CV. COURSE_CD = SPAT.PROGRAM_CD AND CV.VERSION_NUMBER = SPAT.PROGRAM_VERSION AND PRCS.IGS_PR_CLASS_STD_ID(+) = SPAT.CLASS_STANDING_ID

View Text - HTML Formatted

SELECT SPAT.ROWID
, SPAT. TERM_RECORD_ID
, SPAT.PERSON_ID
, SPAT.PROGRAM_CD
, SPAT.PROGRAM_VERSION
, CV.COURSE_TYPE CAREER
, SPAT.COO_ID
, SPAT.ACAD_CAL_TYPE
, SPAT.TERM_CAL_TYPE
, SPAT.TERM_SEQUENCE_NUMBER
, CI.DESCRIPTION DESCRIPTION_TERM
, SPAT.KEY_PROGRAM_FLAG
, SPAT.LOCATION_CD
, SPAT.ATTENDANCE_MODE
, SPAT.ATTENDANCE_TYPE
, SPAT.FEE_CAT
, SPAT.CLASS_STANDING_ID
, PRCS.CLASS_STANDING
, CI.START_DT
, CI.END_DT
, SPAT.PLAN_SHT_STATUS
, SPAT.CREATED_BY
, SPAT.CREATION_DATE
, SPAT.LAST_UPDATED_BY
, SPAT.LAST_UPDATE_DATE
, SPAT.LAST_UPDATE_LOGIN
, SPAT.REQUEST_ID
, SPAT.PROGRAM_APPLICATION_ID
, SPAT.PROGRAM_ID
, SPAT.PROGRAM_UPDATE_DATE
, SPAT.ATTRIBUTE_CATEGORY
, SPAT.ATTRIBUTE1
, SPAT.ATTRIBUTE2
, SPAT.ATTRIBUTE3
, SPAT.ATTRIBUTE4
, SPAT.ATTRIBUTE5
, SPAT.ATTRIBUTE6
, SPAT.ATTRIBUTE7
, SPAT.ATTRIBUTE8
, SPAT.ATTRIBUTE9
, SPAT.ATTRIBUTE10
, SPAT.ATTRIBUTE11
, SPAT.ATTRIBUTE12
, SPAT.ATTRIBUTE13
, SPAT.ATTRIBUTE14
, SPAT.ATTRIBUTE15
, SPAT.ATTRIBUTE16
, SPAT.ATTRIBUTE17
, SPAT.ATTRIBUTE18
, SPAT.ATTRIBUTE19
, SPAT.ATTRIBUTE20
FROM IGS_EN_SPA_TERMS SPAT
, IGS_CA_INST CI
, IGS_PS_VER CV
, IGS_PR_CLASS_STD PRCS
WHERE SPAT.TERM_CAL_TYPE = CI.CAL_TYPE
AND SPAT.TERM_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CV. COURSE_CD = SPAT.PROGRAM_CD
AND CV.VERSION_NUMBER = SPAT.PROGRAM_VERSION
AND PRCS.IGS_PR_CLASS_STD_ID(+) = SPAT.CLASS_STANDING_ID