View: IGS_AD_LOCATION_ADDR_V

Product:	IGS - Student System
Description:	Contains the location, venue, and the address details for a person
Implementation/DBA Data:	APPS.IGS_AD_LOCATION_ADDR_V

View Text

SELECT LA.ROWID ROW_ID
, LA.LOCATION_ID
, LA.LOCATION_VENUE_CD LOCATION_CD
, HL.ADDRESS_EFFECTIVE_DATE START_DT
, HL.ADDRESS_EXPIRATION_DATE END_DT
, PLU.SITE_USE_CODE
, 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_CREATED_BY
, HL.CREATION_DATE HL_CREATION_DATE
, HL.LAST_UPDATED_BY HL_LAST_UPDATED_BY
, HL.LAST_UPDATE_DATE HL_LAST_UPDATE_DATE
, HL.LAST_UPDATE_LOGIN HL_LAST_UPDATE_LOGIN
, IHL.DATE_LAST_VERIFIED
, LA.IDENTIFYING_ADDRESS_FLAG
, 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_REQUEST_ID
, HL.PROGRAM_APPLICATION_ID HL_PROGRAM_APPLICATION_ID
, HL.PROGRAM_ID HL_PROGRAM_ID
, HL.PROGRAM_UPDATE_DATE HL_PROGRAM_UPDATE_DATE
, LA.CREATED_BY
, LA.CREATION_DATE
, LA.LAST_UPDATED_BY
, LA.LAST_UPDATE_DATE
, LA.LAST_UPDATE_LOGIN
, LA.REQUEST_ID
, LA.PROGRAM_APPLICATION_ID
, LA.PROGRAM_ID
, LA.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 = 'L'
AND LA.LOCATION_VENUE_ADDR_ID = PLU.LOC_VENUE_ADDR_ID (+)

Columns