VIEW: APPS.IGS_EN_SPL_PERM_V

Source

View Text - Preformatted

SELECT sp.rowid, sp.spl_perm_request_id, sp.student_person_id, uoo.unit_cd, uoo.version_number, uoo.unit_class, uoo.call_number, uv.title, sp.uoo_id, sp.date_submission, sp.audit_the_course, sp.instructor_person_id, sp.approval_status, sp.reason_for_request, sp.instructor_more_info, sp.instructor_deny_info, sp.student_more_info, sp.transaction_type, lkv.meaning, sp.created_by, sp.creation_date, sp.last_updated_by, sp.last_update_date, sp.last_update_login ,uoo.cal_type , uoo.ci_sequence_number, ci.description, uoo.location_cd, sp.request_type FROM IGS_EN_SPL_PERM sp, IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_UNIT_VER uv, IGS_LOOKUP_VALUES lkv ,IGS_CA_INST ci WHERE uv.unit_cd = uoo.unit_cd AND uv.version_number = uoo.version_number AND sp.uoo_id = uoo.uoo_id AND sp.transaction_type (+) = lkv.lookup_code AND lkv.lookup_type = 'SPL_PERM_TRANSCTION_TYPE' AND ci.cal_type = uoo.cal_type AND ci.sequence_number = uoo.ci_sequence_number

View Text - HTML Formatted

SELECT SP.ROWID
, SP.SPL_PERM_REQUEST_ID
, SP.STUDENT_PERSON_ID
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.UNIT_CLASS
, UOO.CALL_NUMBER
, UV.TITLE
, SP.UOO_ID
, SP.DATE_SUBMISSION
, SP.AUDIT_THE_COURSE
, SP.INSTRUCTOR_PERSON_ID
, SP.APPROVAL_STATUS
, SP.REASON_FOR_REQUEST
, SP.INSTRUCTOR_MORE_INFO
, SP.INSTRUCTOR_DENY_INFO
, SP.STUDENT_MORE_INFO
, SP.TRANSACTION_TYPE
, LKV.MEANING
, SP.CREATED_BY
, SP.CREATION_DATE
, SP.LAST_UPDATED_BY
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATE_LOGIN
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.LOCATION_CD
, SP.REQUEST_TYPE
FROM IGS_EN_SPL_PERM SP
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_VER UV
, IGS_LOOKUP_VALUES LKV
, IGS_CA_INST CI
WHERE UV.UNIT_CD = UOO.UNIT_CD
AND UV.VERSION_NUMBER = UOO.VERSION_NUMBER
AND SP.UOO_ID = UOO.UOO_ID
AND SP.TRANSACTION_TYPE (+) = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'SPL_PERM_TRANSCTION_TYPE'
AND CI.CAL_TYPE = UOO.CAL_TYPE
AND CI.SEQUENCE_NUMBER = UOO.CI_SEQUENCE_NUMBER