Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view defines the details of the placement sessions. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SESSNS.ROWID ROW_ID
, SESSNS.SESSION_NAME
, SESSNS.SESSION_DESCRIPTION
, SESSNS.UOO_ID
, SESSNS.UNIT_SECTION_OCCURRENCE_ID
, DECODE(SESSNS.UNIT_SECTION_OCCURRENCE_ID
, NULL
, NULL
, IGS_AS_GEN_008.GET_OCCUR_DETAILS (SESSNS.UOO_ID
, SESSNS.UNIT_SECTION_OCCURRENCE_ID)) OCCURENCE_DESC
, SESSNS.SESSION_START_DATE_TIME
, SESSNS.SESSION_END_DATE_TIME
, SESSNS.SESSION_LOCATION_DESC
, SESSNS.CREATED_BY
, SESSNS.CREATION_DATE
, SESSNS.LAST_UPDATED_BY
, SESSNS.LAST_UPDATE_DATE
, SESSNS.LAST_UPDATE_LOGIN
FROM IGS_AS_USEC_SESSNS SESSNS