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_GR_VENUE

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.VENUE_CD VENUE_CD
, TAB.EXAM_LOCATION_CD EXAM_LOCATION_CD
, TAB.DESCRIPTION DESCRIPTION
, TAB.NUMBER_OF_SEATS NUMBER_OF_SEATS
, TAB.BOOKING_COST BOOKING_COST
, TAB.PRIORITY_CD PRIORITY_CD
, TAB.SUPERVISOR_LIMIT SUPERVISOR_LIMIT
, TAB.COORD_PERSON_ID COORD_PERSON_ID
, TAB.CLOSED_IND CLOSED_IND
, TAB.COMMENTS COMMENTS
, TAB.RESOURCES_AVAILABLE RESOURCES_AVAILABLE
, TAB.ANNOUNCEMENTS ANNOUNCEMENTS
, TAB.BOOKING_INFORMATION BOOKING_INFORMATION
, TAB.SEATING_INFORMATION SEATING_INFORMATION
, TAB.INSTRUCTIONS INSTRUCTIONS
, 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
FROM IGS_GR_VENUE_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
ORG_ID
VENUE_CD
EXAM_LOCATION_CD
DESCRIPTION
NUMBER_OF_SEATS
BOOKING_COST
PRIORITY_CD
SUPERVISOR_LIMIT
COORD_PERSON_ID
CLOSED_IND
COMMENTS
RESOURCES_AVAILABLE
ANNOUNCEMENTS
BOOKING_INFORMATION
SEATING_INFORMATION
INSTRUCTIONS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN