[Home] [Help]
View: 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
Name |
DESCRIPTION |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
POSTAL_CODE |
STATE |
PROVINCE |
COUNTY |
ADDRESS_LINES_PHONETIC |
COUNTRY |
LOCATION_ID |
PARTY_SITE_ID |