VIEW: APPS.IGSFV_AS_CHNG_GRD_REQUESTS

Source

View Text - Preformatted

SELECT HP1.PARTY_NAME, HP1.PARTY_NUMBER, CGR.COURSE_CD, CGR.UNIT_CD, UV.TITLE, CGR.UNIT_CLASS, UC.DESCRIPTION, CGR.LOCATION_CD, LOC.DESCRIPTION, CGR.TEACH_CAL_TYPE, CGR.TEACH_CI_SEQUENCE_NUMBER, CI1.DESCRIPTION, CGR.REQUEST_DATE, CGR.LOAD_CAL_TYPE, CGR.LOAD_CI_SEQUENCE_NUMBER, CI2.DESCRIPTION, CGR.CURRENT_MARK, CGR.CURRENT_GRADING_SCHEMA_CD, CGR.CURRENT_GS_VERSION_NUMBER, CGR.CURRENT_GRADE, GSG1.FULL_GRADE_NAME, CGR.CHANGE_MARK, CGR.CHANGE_GRADING_SCHEMA_CD, CGR.CHANGE_GS_VERSION_NUMBER, CGR.CHANGE_GRADE, GSG2.FULL_GRADE_NAME, CGR.REQUESTER_COMMENTS, CGR.APPROVER_DATE, CGR.APPROVER_COMMENTS, CGR.CURRENT_STATUS, HP2.PARTY_NAME, HP2.PARTY_NUMBER, HP3.PARTY_NAME, HP3.PARTY_NUMBER, '_LA:CGR.MARK_CAPPED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:CGR.SHOW_ON_ACADEMIC_HISTRY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', CGR.UOO_ID, CGR.PERSON_ID, CGR.REQUESTER_ID, CGR.APPROVER_ID, CGR.CREATED_BY, CGR.CREATION_DATE, CGR.LAST_UPDATED_BY, CGR.LAST_UPDATE_DATE FROM IGS_AS_CHN_GRD_REQ CGR, HZ_PARTIES HP1, IGS_PS_UNIT_VER_ALL UV, IGS_AS_UNIT_CLASS_ALL UC, IGS_AD_LOCATION LOC, IGS_CA_INST_ALL CI1, IGS_PS_UNIT_OFR_OPT_ALL UOO, HZ_PARTIES HP2, HZ_PARTIES HP3, IGS_AS_GRD_SCH_GRADE GSG1, IGS_AS_GRD_SCH_GRADE GSG2, IGS_CA_INST_ALL CI2 WHERE CGR.PERSON_ID = HP1.PARTY_ID AND CGR.APPROVER_ID = HP2.PARTY_ID (+) AND CGR.REQUESTER_ID = HP3.PARTY_ID AND CGR.UOO_ID = UOO.UOO_ID AND UOO.UNIT_CD = UV.UNIT_CD AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER AND CGR.UNIT_CLASS = UC.UNIT_CLASS AND CGR.LOCATION_CD = LOC.LOCATION_CD AND CGR.TEACH_CAL_TYPE = CI1.CAL_TYPE AND CGR.TEACH_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER AND CGR.LOAD_CAL_TYPE = CI2.CAL_TYPE AND CGR.LOAD_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER AND CGR.CURRENT_GRADING_SCHEMA_CD = GSG1.GRADING_SCHEMA_CD AND CGR.CURRENT_GS_VERSION_NUMBER = GSG1.VERSION_NUMBER AND CGR.CURRENT_GRADE = GSG1.GRADE AND CGR.CHANGE_GRADING_SCHEMA_CD = GSG2.GRADING_SCHEMA_CD AND CGR.CHANGE_GS_VERSION_NUMBER = GSG2.VERSION_NUMBER AND CGR.CHANGE_GRADE = GSG2.GRADE WITH READ ONLY

View Text - HTML Formatted

SELECT HP1.PARTY_NAME
, HP1.PARTY_NUMBER
, CGR.COURSE_CD
, CGR.UNIT_CD
, UV.TITLE
, CGR.UNIT_CLASS
, UC.DESCRIPTION
, CGR.LOCATION_CD
, LOC.DESCRIPTION
, CGR.TEACH_CAL_TYPE
, CGR.TEACH_CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION
, CGR.REQUEST_DATE
, CGR.LOAD_CAL_TYPE
, CGR.LOAD_CI_SEQUENCE_NUMBER
, CI2.DESCRIPTION
, CGR.CURRENT_MARK
, CGR.CURRENT_GRADING_SCHEMA_CD
, CGR.CURRENT_GS_VERSION_NUMBER
, CGR.CURRENT_GRADE
, GSG1.FULL_GRADE_NAME
, CGR.CHANGE_MARK
, CGR.CHANGE_GRADING_SCHEMA_CD
, CGR.CHANGE_GS_VERSION_NUMBER
, CGR.CHANGE_GRADE
, GSG2.FULL_GRADE_NAME
, CGR.REQUESTER_COMMENTS
, CGR.APPROVER_DATE
, CGR.APPROVER_COMMENTS
, CGR.CURRENT_STATUS
, HP2.PARTY_NAME
, HP2.PARTY_NUMBER
, HP3.PARTY_NAME
, HP3.PARTY_NUMBER
, '_LA:CGR.MARK_CAPPED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:CGR.SHOW_ON_ACADEMIC_HISTRY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, CGR.UOO_ID
, CGR.PERSON_ID
, CGR.REQUESTER_ID
, CGR.APPROVER_ID
, CGR.CREATED_BY
, CGR.CREATION_DATE
, CGR.LAST_UPDATED_BY
, CGR.LAST_UPDATE_DATE
FROM IGS_AS_CHN_GRD_REQ CGR
, HZ_PARTIES HP1
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_AD_LOCATION LOC
, IGS_CA_INST_ALL CI1
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, HZ_PARTIES HP2
, HZ_PARTIES HP3
, IGS_AS_GRD_SCH_GRADE GSG1
, IGS_AS_GRD_SCH_GRADE GSG2
, IGS_CA_INST_ALL CI2
WHERE CGR.PERSON_ID = HP1.PARTY_ID
AND CGR.APPROVER_ID = HP2.PARTY_ID (+)
AND CGR.REQUESTER_ID = HP3.PARTY_ID
AND CGR.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND CGR.UNIT_CLASS = UC.UNIT_CLASS
AND CGR.LOCATION_CD = LOC.LOCATION_CD
AND CGR.TEACH_CAL_TYPE = CI1.CAL_TYPE
AND CGR.TEACH_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND CGR.LOAD_CAL_TYPE = CI2.CAL_TYPE
AND CGR.LOAD_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER
AND CGR.CURRENT_GRADING_SCHEMA_CD = GSG1.GRADING_SCHEMA_CD
AND CGR.CURRENT_GS_VERSION_NUMBER = GSG1.VERSION_NUMBER
AND CGR.CURRENT_GRADE = GSG1.GRADE
AND CGR.CHANGE_GRADING_SCHEMA_CD = GSG2.GRADING_SCHEMA_CD
AND CGR.CHANGE_GS_VERSION_NUMBER = GSG2.VERSION_NUMBER
AND CGR.CHANGE_GRADE = GSG2.GRADE WITH READ ONLY