VIEW: APPS.IGSFV_SPECIAL_PERMISSIONS

Source

View Text - Preformatted

SELECT ENSP.SPL_PERM_REQUEST_ID, ENSP.DATE_SUBMISSION, ENSP.AUDIT_THE_COURSE, '_LA:AUDIT_THE_COURSE:IGS_LOOKUP_VALUES:YES_NO:MEANING', ENSP.APPROVAL_STATUS, ENSP.REASON_FOR_REQUEST, ENSP.INSTRUCTOR_MORE_INFO, ENSP.INSTRUCTOR_DENY_INFO, ENSP.STUDENT_MORE_INFO, ENSP.TRANSACTION_TYPE, '_LA:TRANSACTION_TYPE:IGS_LOOKUP_VALUES:SPL_PERM_TRANSCTION_TYPE:MEANING', ENSP.REQUEST_TYPE, ENSP.STUDENT_PERSON_ID, HP1.PARTY_NUMBER, HP1.PARTY_NAME, ENSP.INSTRUCTOR_PERSON_ID, HP2.PARTY_NUMBER, HP2.PARTY_NAME, ENSP.UOO_ID, UOO.UNIT_CD, UOO.VERSION_NUMBER, UOO.CAL_TYPE, UOO.CI_SEQUENCE_NUMBER, UOO.LOCATION_CD, UOO.UNIT_CLASS, ENSP.CREATED_BY, ENSP.CREATION_DATE, ENSP.LAST_UPDATED_BY, ENSP.LAST_UPDATE_DATE FROM IGS_EN_SPL_PERM ENSP, IGS_PS_UNIT_OFR_OPT_ALL UOO, HZ_PARTIES HP1, HZ_PARTIES HP2 WHERE ENSP.UOO_ID = UOO.UOO_ID AND ENSP.STUDENT_PERSON_ID = HP1.PARTY_ID AND ENSP.INSTRUCTOR_PERSON_ID = HP2.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT ENSP.SPL_PERM_REQUEST_ID
, ENSP.DATE_SUBMISSION
, ENSP.AUDIT_THE_COURSE
, '_LA:AUDIT_THE_COURSE:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ENSP.APPROVAL_STATUS
, ENSP.REASON_FOR_REQUEST
, ENSP.INSTRUCTOR_MORE_INFO
, ENSP.INSTRUCTOR_DENY_INFO
, ENSP.STUDENT_MORE_INFO
, ENSP.TRANSACTION_TYPE
, '_LA:TRANSACTION_TYPE:IGS_LOOKUP_VALUES:SPL_PERM_TRANSCTION_TYPE:MEANING'
, ENSP.REQUEST_TYPE
, ENSP.STUDENT_PERSON_ID
, HP1.PARTY_NUMBER
, HP1.PARTY_NAME
, ENSP.INSTRUCTOR_PERSON_ID
, HP2.PARTY_NUMBER
, HP2.PARTY_NAME
, ENSP.UOO_ID
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, ENSP.CREATED_BY
, ENSP.CREATION_DATE
, ENSP.LAST_UPDATED_BY
, ENSP.LAST_UPDATE_DATE
FROM IGS_EN_SPL_PERM ENSP
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, HZ_PARTIES HP1
, HZ_PARTIES HP2
WHERE ENSP.UOO_ID = UOO.UOO_ID
AND ENSP.STUDENT_PERSON_ID = HP1.PARTY_ID
AND ENSP.INSTRUCTOR_PERSON_ID = HP2.PARTY_ID WITH READ ONLY