Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view holds all the timeslots that pertain to one specific calendar year and their corresponding date aliases. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ETC.ROWID ROW_ID
, ETC.IGS_EN_TIMESLOT_CONF_ID IGS_EN_TIMESLOT_CONF_ID
, ETC.TIMESLOT_NAME TIMESLOT_NAME
, ETC.START_DT_ALIAS START_DT_ALIAS
, CD1.DESCRIPTION DSP_DESCRIPTION1
, CD1.CLOSED_IND DSP_CLOSED_IND1
, ETC.END_DT_ALIAS END_DT_ALIAS
, CD2.DESCRIPTION DSP_DESCRIPTION2
, CD2.CLOSED_IND DSP_CLOSED_IND2
, ETC.CREATED_BY CREATED_BY
, ETC.CREATION_DATE CREATION_DATE
, ETC.LAST_UPDATED_BY LAST_UPDATED_BY
, ETC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_CONF ETC
, IGS_CA_DA CD1
, IGS_CA_DA CD2
WHERE ETC.START_DT_ALIAS = CD1.DT_ALIAS
AND ETC.END_DT_ALIAS = CD2.DT_ALIAS
AND NVL(ETC.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) =NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)