VIEW: APPS.CS_SYSTEM_BILLTO_LOC_RG_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_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hl, hz_parties hp where hp.party_id = hps.party_id and hcas.party_site_id = hps.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_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, HZ_PARTIES HP
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID