View: IGS_GR_VENUE_ADDR

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_GR_VENUE_ADDR

View Text

SELECT LA.ROWID ROW_ID
, LA.LOCATION_ID
, LA.LOCATION_VENUE_CD VENUE_CD
, HL. ADDRESS_EFFECTIVE_DATE START_DT
, HL. ADDRESS_EXPIRATION_DATE END_DT
, PLU.SITE_USE_CODE ADDR_TYPE
, HL.ADDRESS1 ADDR_LINE_1
, HL.ADDRESS2 ADDR_LINE_2
, HL.ADDRESS3 ADDR_LINE_3
, HL.ADDRESS4 ADDR_LINE_4
, 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