View: CSP_LOCATION_ADDRESS_V

Product:	CSP - Spares Management
Description:	Shows all the existing Address
Implementation/DBA Data:	APPS.CSP_LOCATION_ADDRESS_V

View Text

SELECT HP.PARTY_NAME DESCRIPTION
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.POSTAL_CODE
, HL.STATE
, HL.PROVINCE
, HL.COUNTY
, HL.ADDRESS_LINES_PHONETIC
, HL.COUNTRY
, TO_NUMBER(NULL) LOCATION_ID
, HPS.PARTY_SITE_ID PARTY_SITE_ID
FROM HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID UNION SELECT HL.DESCRIPTION DESCRIPTION
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.POSTAL_CODE
, HL.STATE
, HL.PROVINCE
, HL.COUNTY
, HL.ADDRESS_LINES_PHONETIC
, HL.COUNTRY
, HL.LOCATION_ID
, TO_NUMBER(NULL) PARTY_SITE_ID
FROM HZ_LOCATIONS HL
WHERE NOT EXISTS (SELECT 'X'
FROM HZ_PARTY_SITES HPS
WHERE HL.LOCATION_ID = HPS.LOCATION_ID)
AND HL.DESCRIPTION IS NOT NULL

Columns