eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSI_HZCA_ADDRESSES_V

Source

View Text - Preformatted


SELECT HL.CITY PARTY_CITY, HL.ADDRESS1 || ' ' || HL.ADDRESS2 || ' ' || HL.ADDRESS3 || ' ' || HL.ADDRESS4 || ' ' || HL.CITY || ' ' || HL.STATE || ' ' || HL.POSTAL_CODE || ' ' || HL.COUNTRY PARTY_ADDRESS, HP.PARTY_NAME PARTY_NAME, HCAS.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, HL.ADDRESS1 PARTY_ADDRESS1, HL.ADDRESS2 PARTY_ADDRESS2, SUBSTR(HL.CITY || DECODE(HL.CITY,'','', DECODE(HL.STATE||HL.COUNTRY|| HL.POSTAL_CODE,'','',', ')) || HL.STATE || ' ' || HL.POSTAL_CODE || ' ' || HL.COUNTRY, 1, 220) PARTY_ADDRESS3, HCAS.CUST_ACCOUNT_ID CUST_ACCOUNT_ID FROM HZ_PARTIES HP, HZ_PARTY_SITES HPS, HZ_CUST_ACCT_SITES_ALL HCAS, HZ_LOCATIONS HL WHERE HP.PARTY_ID = HPS.PARTY_ID AND HPS.PARTY_SITE_ID = HCAS.PARTY_SITE_ID AND HPS.LOCATION_ID = HL.LOCATION_ID

View Text - HTML Formatted

SELECT HL.CITY PARTY_CITY
, HL.ADDRESS1 || ' ' || HL.ADDRESS2 || ' ' || HL.ADDRESS3 || ' ' || HL.ADDRESS4 || ' ' || HL.CITY || ' ' || HL.STATE || ' ' || HL.POSTAL_CODE || ' ' || HL.COUNTRY PARTY_ADDRESS
, HP.PARTY_NAME PARTY_NAME
, HCAS.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, HL.ADDRESS1 PARTY_ADDRESS1
, HL.ADDRESS2 PARTY_ADDRESS2
, SUBSTR(HL.CITY || DECODE(HL.CITY
, ''
, ''
, DECODE(HL.STATE||HL.COUNTRY|| HL.POSTAL_CODE
, ''
, ''
, '
, ')) || HL.STATE || ' ' || HL.POSTAL_CODE || ' ' || HL.COUNTRY
, 1
, 220) PARTY_ADDRESS3
, HCAS.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_LOCATIONS HL
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HPS.PARTY_SITE_ID = HCAS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID