View: IGS_EN_TIMESLOT_REVW_V

Product:	IGS - Student System
Description:	Review Timeslot Allocation
Implementation/DBA Data:	APPS.IGS_EN_TIMESLOT_REVW_V

View Text

SELECT TSR.ROWID ROW_ID
, TSR.PERSON_ID
, TSR.START_DT_TIME
, TSR.END_DT_TIME
, TSP.CAL_TYPE
, CT.DESCRIPTION CAL_TYPE_DESC
, TSP.TIMESLOT_CALENDAR
, TSP.TS_MODE
, LKUP.MEANING
FROM IGS_EN_TIMESLOT_RSLT TSR
, IGS_CA_TYPE CT
, IGS_EN_TIMESLOT_PARA TSP
, IGS_LOOKUPS_VIEW LKUP
WHERE TSP.IGS_EN_TIMESLOT_PARA_ID = TSR.IGS_EN_TIMESLOT_PARA_ID
AND TSP.CAL_TYPE = CT.CAL_TYPE
AND (TSP.TS_MODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'TIMESLOT_MODE')

Columns