[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Shows the location, venue, and address details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT LA.ROWID ROW_ID
, LA.LOCATION_VENUE_ADDR_ID
, LA.LOCATION_ID
, LA.LOCATION_VENUE_CD
, LA.SOURCE_TYPE
, HL. ADDRESS_EFFECTIVE_DATE START_DT
, HL. ADDRESS_EXPIRATION_DATE END_DT
, HL.ADDRESS1 ADDR_LINE_1
, HL.ADDRESS2 ADDR_LINE_2
, HL.ADDRESS3 ADDR_LINE_3
, HL.ADDRESS4 ADDR_LINE_4
, HL.ADDRESS_LINES_PHONETIC
, 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
, HL.CITY
, HL.STATE
, HL.PROVINCE
, HL.COUNTY
, HL.COUNTRY
, FT.TERRITORY_SHORT_NAME COUNTRY_NAME
, FT.ADDRESS_STYLE
, 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
, HL.OBJECT_VERSION_NUMBER
FROM HZ_LOCATIONS HL
, IGS_AD_LOCVENUE_ADDR LA
, IGS_PE_HZ_LOCATIONS IHL
, FND_TERRITORIES_VL FT
WHERE HL.LOCATION_ID = LA.LOCATION_ID
AND HL.LOCATION_ID = IHL.LOCATION_ID
AND FT.TERRITORY_CODE = HL.COUNTRY