VIEW: APPS.IGSFV_VENUES

Source

View Text - Preformatted

SELECT VEN.VENUE_CD VENUE_CODE, VEN.DESCRIPTION, VEN.EXAM_LOCATION_CD EXAM_LOCATION_CODE, VEN.NUMBER_OF_SEATS, VEN.BOOKING_COST, VEN.SUPERVISOR_LIMIT, VEN.PRIORITY_CD PRIORITY_CODE, VEN.CLOSED_IND CLOSED_INDICATOR, VEN.COMMENTS , VEN.RESOURCES_AVAILABLE, VEN.ANNOUNCEMENTS, VEN.SEATING_INFORMATION, VEN.BOOKING_INFORMATION, VEN.INSTRUCTIONS, LOC.DESCRIPTION EXAM_LOCATION_DESC, HP.PARTY_NUMBER COORDINATE_PERSON_NUMBER, VEN.COORD_PERSON_ID COORDINATE_PERSON_IDENTIFIER, VEN.CREATED_BY, VEN.CREATION_DATE, VEN.LAST_UPDATED_BY, VEN.LAST_UPDATE_DATE FROM IGS_GR_VENUE_ALL VEN, IGS_AD_LOCATION_ALL LOC, HZ_PARTIES HP WHERE VEN.EXAM_LOCATION_CD = LOC.LOCATION_CD AND VEN.COORD_PERSON_ID = HP.PARTY_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT VEN.VENUE_CD VENUE_CODE
, VEN.DESCRIPTION
, VEN.EXAM_LOCATION_CD EXAM_LOCATION_CODE
, VEN.NUMBER_OF_SEATS
, VEN.BOOKING_COST
, VEN.SUPERVISOR_LIMIT
, VEN.PRIORITY_CD PRIORITY_CODE
, VEN.CLOSED_IND CLOSED_INDICATOR
, VEN.COMMENTS
, VEN.RESOURCES_AVAILABLE
, VEN.ANNOUNCEMENTS
, VEN.SEATING_INFORMATION
, VEN.BOOKING_INFORMATION
, VEN.INSTRUCTIONS
, LOC.DESCRIPTION EXAM_LOCATION_DESC
, HP.PARTY_NUMBER COORDINATE_PERSON_NUMBER
, VEN.COORD_PERSON_ID COORDINATE_PERSON_IDENTIFIER
, VEN.CREATED_BY
, VEN.CREATION_DATE
, VEN.LAST_UPDATED_BY
, VEN.LAST_UPDATE_DATE
FROM IGS_GR_VENUE_ALL VEN
, IGS_AD_LOCATION_ALL LOC
, HZ_PARTIES HP
WHERE VEN.EXAM_LOCATION_CD = LOC.LOCATION_CD
AND VEN.COORD_PERSON_ID = HP.PARTY_ID(+) WITH READ ONLY