eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AMS_LT_HZ_LOCATIONS

Product:	AMS - Marketing
Description:	Data Source view based on hz_locations
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HS.LOCATION_ID
, HS.COUNTRY
, HS.STATE
, HS.POSTAL_CODE
, HS.ADDRESS1
, HS.ADDRESS2
, HS.ADDRESS3
, HS.ADDRESS4
, HS.CITY
, HS.PROVINCE
, HS.COUNTY
, HS.ADDRESS_KEY
, HS.ADDRESS_STYLE
, HS.APARTMENT_FLAG
, HS.PO_BOX_NUMBER
, HS.HOUSE_NUMBER
, HS.STREET_SUFFIX
, HS.APARTMENT_NUMBER
, HS.SECONDARY_SUFFIX_ELEMENT
, HS.STREET
, HS.RURAL_ROUTE_TYPE
, HS.RURAL_ROUTE_NUMBER
, HS.STREET_NUMBER
, HS.BUILDING
, HS.FLOOR
, HS.SUITE
, HS.ROOM
, HS.POSTAL_PLUS4_CODE
, HS.TIME_ZONE
, HS.OVERSEAS_ADDRESS_FLAG
, HS.POST_OFFICE
, HS.POSITION
, HS.DELIVERY_POINT_CODE
, HS.LOCATION_DIRECTIONS
, HS.ADDRESS_EFFECTIVE_DATE
, HS.ADDRESS_EXPIRATION_DATE
, HS.ADDRESS_ERROR_CODE
, HS.TRAILING_DIRECTORY_CODE
, HS.LANGUAGE
, HS.LIFE_CYCLE_STATUS
, HS.TIMEZONE_ID
, HPS.PARTY_ID
, HPS.MAILSTOP
, HPS.PARTY_SITE_ID
FROM HZ_LOCATIONS HS
, HZ_PARTY_SITES HPS
WHERE HS.LOCATION_ID = HPS.LOCATION_ID
AND IDENTIFYING_ADDRESS_FLAG = 'Y'

Columns

Name
LOCATION_ID
COUNTRY
STATE
POSTAL_CODE
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
PROVINCE
COUNTY
ADDRESS_KEY
ADDRESS_STYLE
APARTMENT_FLAG
PO_BOX_NUMBER
HOUSE_NUMBER
STREET_SUFFIX
APARTMENT_NUMBER
SECONDARY_SUFFIX_ELEMENT
STREET
RURAL_ROUTE_TYPE
RURAL_ROUTE_NUMBER
STREET_NUMBER
BUILDING
FLOOR
SUITE
ROOM
POSTAL_PLUS4_CODE
TIME_ZONE
OVERSEAS_ADDRESS_FLAG
POST_OFFICE
POSITION
DELIVERY_POINT_CODE
LOCATION_DIRECTIONS
ADDRESS_EFFECTIVE_DATE
ADDRESS_EXPIRATION_DATE
ADDRESS_ERROR_CODE
TRAILING_DIRECTORY_CODE
LANGUAGE
LIFE_CYCLE_STATUS
TIMEZONE_ID
PARTY_ID
MAILSTOP
PARTY_SITE_ID