View: IGS_AS_USEC_ATTEND_ENTRY_V

Product:	IGS - Student System
Description:	Describes Unit Sections due for Attendance View
Implementation/DBA Data:	APPS.IGS_AS_USEC_ATTEND_ENTRY_V

View Text

SELECT TTL.LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION
, UOO.UNIT_CD
, UOO.UNIT_CLASS
, UOO.LOCATION_DESCRIPTION LOCATION
, UOO.CALL_NUMBER
, UOO.TITLE
, HZ.PERSON_LAST_NAME || '
, ' || HZ.PERSON_FIRST_NAME || ' ' || HZ.PERSON_MIDDLE_NAME INSTRUCTOR_NAME
, UOO.UOO_ID
, USTR.INSTRUCTOR_ID
, TTL.LOAD_CAL_TYPE
, TTL.LOAD_CI_SEQUENCE_NUMBER
, TTL.LOAD_START_DT
, TTL.LOAD_END_DT
, UOO.CAL_TYPE TEACH_CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER TEACH_CI_SEQUENCE_NUMBER
FROM IGS_PS_UNIT_OFR_OPT_V UOO
, HZ_PARTIES HZ
, IGS_CA_TEACH_TO_LOAD_V TTL
, IGS_PS_USEC_TCH_RESP USTR
WHERE UOO.UOO_ID = USTR.UOO_ID
AND UOO.UNIT_SECTION_STATUS IN ('OPEN'
, 'CLOSED'
, 'HOLD'
, 'FULLWAITOK')
AND USTR.LEAD_INSTRUCTOR_FLAG = 'Y'
AND USTR.INSTRUCTOR_ID = HZ.PARTY_ID
AND UOO.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER
AND SYSDATE > (SELECT MAX(CDI.ALIAS_VAL) ATTENDANCE_START_DT
FROM IGS_CA_DA_INST_V CDI
, IGS_AS_CAL_CONF CAC
WHERE CDI.DT_ALIAS = CAC.FINAL_MGS_START_DT_ALIAS
AND CDI.CAL_TYPE = UOO.CAL_TYPE
AND CDI.CI_SEQUENCE_NUMBER = UOO.CI_SEQUENCE_NUMBER)

Columns