View: JTF_PARTY_LOCATIONS_V

Product:	JTF - CRM Foundation
Description:	Address Information of a Party
Implementation/DBA Data:	APPS.JTF_PARTY_LOCATIONS_V

View Text

SELECT SITE.ROWID
, SITE.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, LOC.LOCATION_ID
, SITE.PARTY_SITE_ID
, USE.PARTY_SITE_USE_ID
, SITE.STATUS
, USE.SITE_USE_TYPE
, LOC.ADDRESS1||DECODE(LOC.ADDRESS2
, NULL
, NULL
, ';'||LOC.ADDRESS2|| DECODE(LOC.ADDRESS3
, NULL
, NULL
, ';'||LOC.ADDRESS3|| DECODE(LOC.ADDRESS4
, NULL
, NULL
, ';'||LOC.ADDRESS4))) ADDRESS
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.COUNTY
, LOC.COUNTRY
, SITE.IDENTIFYING_ADDRESS_FLAG
, LOC.LAST_UPDATE_DATE
, SITE.LAST_UPDATE_DATE
, USE.LAST_UPDATE_DATE
FROM HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTY_SITE_USES USE
, HZ_PARTIES PARTY
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID
AND SITE.PARTY_ID = PARTY.PARTY_ID
AND SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID(+)

Columns