VIEW: APPS.CSP_LOCATION_ADDRESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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