VIEW: APPS.IGS_AS_USEC_GRADE_ENTRY_V

Source

View Text - Preformatted

SELECT ttl.load_description load_description , ttl.teach_description teach_description , uoo.unit_cd , uoo.unit_class , loc.location_cd , loc.description location , uoo.call_number , uv.title , NVL (usecgs.grading_schema_code, ugs.grading_schema_code) grading_schema_code, NVL (usecgs.grd_schm_version_number, ugs.grd_schm_version_number) grd_schm_version_number, ustr.instructor_id , p.person_last_name || ', ' || p.person_first_name || ' '|| p.person_middle_name instructor_name , uoo.uoo_id , ttl.load_cal_type , ttl.load_ci_sequence_number , uoo.cal_type teach_cal_type, uoo.ci_sequence_number teach_ci_sequence_number , uoo.owner_org_unit_cd, ttl.teach_alternate_code FROM igs_ps_unit_ofr_opt_all uoo , igs_ps_unit_grd_schm ugs, igs_ps_usec_grd_schm usecgs, hz_parties p , igs_ca_teach_to_load_v ttl , igs_ps_usec_tch_resp ustr , igs_ad_location_all loc, igs_ps_unit_ver_all uv WHERE uoo.uoo_id = ustr.uoo_id AND uoo.unit_section_status IN ('OPEN' , 'CLOSED' , 'HOLD' , 'FULLWAITOK') AND ustr.instructor_id = p.party_id AND uoo.cal_type = ttl.teach_cal_type AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number AND uoo.location_cd = loc.location_cd AND uoo.unit_cd = uv.unit_cd AND uoo.version_number = uv.version_number AND ugs.unit_code = uoo.unit_cd AND ugs.unit_version_number = uoo.version_number AND ugs.default_flag = 'Y' AND usecgs.uoo_id(+) = uoo.uoo_id AND usecgs.default_flag(+) = 'Y'

View Text - HTML Formatted

SELECT TTL.LOAD_DESCRIPTION LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION TEACH_DESCRIPTION
, UOO.UNIT_CD
, UOO.UNIT_CLASS
, LOC.LOCATION_CD
, LOC.DESCRIPTION LOCATION
, UOO.CALL_NUMBER
, UV.TITLE
, NVL (USECGS.GRADING_SCHEMA_CODE
, UGS.GRADING_SCHEMA_CODE) GRADING_SCHEMA_CODE
, NVL (USECGS.GRD_SCHM_VERSION_NUMBER
, UGS.GRD_SCHM_VERSION_NUMBER) GRD_SCHM_VERSION_NUMBER
, USTR.INSTRUCTOR_ID
, P.PERSON_LAST_NAME || '
, ' || P.PERSON_FIRST_NAME || ' '|| P.PERSON_MIDDLE_NAME INSTRUCTOR_NAME
, UOO.UOO_ID
, TTL.LOAD_CAL_TYPE
, TTL.LOAD_CI_SEQUENCE_NUMBER
, UOO.CAL_TYPE TEACH_CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER TEACH_CI_SEQUENCE_NUMBER
, UOO.OWNER_ORG_UNIT_CD
, TTL.TEACH_ALTERNATE_CODE
FROM IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_PS_UNIT_GRD_SCHM UGS
, IGS_PS_USEC_GRD_SCHM USECGS
, HZ_PARTIES P
, IGS_CA_TEACH_TO_LOAD_V TTL
, IGS_PS_USEC_TCH_RESP USTR
, IGS_AD_LOCATION_ALL LOC
, IGS_PS_UNIT_VER_ALL UV
WHERE UOO.UOO_ID = USTR.UOO_ID
AND UOO.UNIT_SECTION_STATUS IN ('OPEN'
, 'CLOSED'
, 'HOLD'
, 'FULLWAITOK')
AND USTR.INSTRUCTOR_ID = P.PARTY_ID
AND UOO.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UGS.UNIT_CODE = UOO.UNIT_CD
AND UGS.UNIT_VERSION_NUMBER = UOO.VERSION_NUMBER
AND UGS.DEFAULT_FLAG = 'Y'
AND USECGS.UOO_ID(+) = UOO.UOO_ID
AND USECGS.DEFAULT_FLAG(+) = 'Y'