View: IGS_GR_VENUE_V

Product:	IGS - Student System
Description:	IGS_GR_VENUE_V is used to maintain venues.
Implementation/DBA Data:	APPS.IGS_GR_VENUE_V

View Text

SELECT VE.ROWID
, VE.VENUE_CD
, PE.PERSON_NUMBER
, PE.PREFERRED_NAME
, VE.EXAM_LOCATION_CD
, VE.DESCRIPTION
, VE.NUMBER_OF_SEATS
, VE.BOOKING_COST
, VE.PRIORITY_CD
, VE.SUPERVISOR_LIMIT
, VE.COORD_PERSON_ID
, VE.CLOSED_IND
, VE.COMMENTS
, VE.RESOURCES_AVAILABLE
, VE.ANNOUNCEMENTS
, VE.BOOKING_INFORMATION
, VE.SEATING_INFORMATION
, VE.INSTRUCTIONS
, VE.CREATED_BY
, VE.CREATION_DATE
, VE.LAST_UPDATED_BY
, VE.LAST_UPDATE_DATE
, VE.LAST_UPDATE_LOGIN
FROM IGS_GR_VENUE VE
, IGS_PE_PERSON_V PE
WHERE VE.COORD_PERSON_ID = PE.PERSON_ID(+)

Columns