eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AS_EXAM_SESSION

Product:	IGS - Student System (Obsolete)
Description:	This is the Multi org view for the table exam session details.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAB.ROWID ROW_ID
, TAB.EXAM_CAL_TYPE EXAM_CAL_TYPE
, TAB.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER
, TAB.DT_ALIAS DT_ALIAS
, TAB.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, TAB.CI_START_DT CI_START_DT
, TAB.CI_END_DT CI_END_DT
, TAB.START_TIME START_TIME
, TAB.END_TIME END_TIME
, TAB.ESE_ID ESE_ID
, TAB.EXAM_SESSION_NUMBER EXAM_SESSION_NUMBER
, TAB.COMMENTS COMMENTS
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
FROM IGS_AS_EXAM_SESSION_ALL TAB
WHERE NVL (TAB.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)

Columns

Name
ROW_ID
EXAM_CAL_TYPE
EXAM_CI_SEQUENCE_NUMBER
DT_ALIAS
DAI_SEQUENCE_NUMBER
CI_START_DT
CI_END_DT
START_TIME
END_TIME
ESE_ID
EXAM_SESSION_NUMBER
COMMENTS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ORG_ID