[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Unit sections for grade entry information |
| Implementation/DBA Data: | Not implemented in this database |
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'