View: JTF_HZ_PARTY_LOCATIONS_V

Product:	JTF - CRM Foundation
Description:	JTF_HZ_LOCATIONS_V retreives information about locations. Other entities, such as parties, can reference the locations stored in this table.
Implementation/DBA Data:	APPS.JTF_HZ_PARTY_LOCATIONS_V

View Text

SELECT LOCATION.ROWID
, PARTY_SITE_ID
, LOCATION.LOCATION_ID
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTRY
FROM HZ_LOCATIONS LOCATION
, HZ_PARTY_SITES PARTY_SITES
WHERE LOCATION.LOCATION_ID = PARTY_SITES.LOCATION_ID

Columns