View: IGS_GR_VENUE_ADDR_V

Product:	IGS - Student System
Description:	IGS_GR_VENUE_ADDR_V is used to maintain venue addresses.
Implementation/DBA Data:	APPS.IGS_GR_VENUE_ADDR_V

View Text

SELECT LA.ROWID ROW_ID
, LA.LOCATION_ID
, LA.LOCATION_VENUE_CD VENUE_CD
, HL. ADDRESS_EFFECTIVE_DATE
, HL. ADDRESS_EXPIRATION_DATE
, PLU.SITE_USE_CODE ADDR_TYPE
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, IHL.CONTACT_PERSON
, HL.CREATED_BY
, HL.CREATION_DATE
, HL.LAST_UPDATED_BY
, HL.LAST_UPDATE_DATE
, HL.LAST_UPDATE_LOGIN
, IHL.DATE_LAST_VERIFIED
, LA.IDENTIFYING_ADDRESS_FLAG CORRESPONDENCE_IND
, HL.CITY
, HL.STATE
, HL.PROVINCE
, HL.COUNTY
, HL.COUNTRY
, HL.POSTAL_CODE
, HL.DELIVERY_POINT_CODE
, IHL.OTHER_DETAILS_1
, IHL.OTHER_DETAILS_2
, IHL.OTHER_DETAILS_3
, HL.REQUEST_ID
, HL.PROGRAM_APPLICATION_ID
, HL.PROGRAM_ID
, HL.PROGRAM_UPDATE_DATE
FROM HZ_LOCATIONS HL
, IGS_AD_LOCVENUE_ADDR LA
, IGS_PE_HZ_LOCATIONS IHL
, IGS_PE_LOCVENUE_USE PLU
WHERE HL.LOCATION_ID = LA.LOCATION_ID AND HL.LOCATION_ID = IHL.LOCATION_ID AND SOURCE_TYPE = 'V'
AND LA.LOCATION_VENUE_ADDR_ID = PLU.LOC_VENUE_ADDR_ID(+)

Columns