[Home] [Help]
View: CSI_HZCA_ADDRESSES_V
Product: | CSI - Install Base |
Description: | Customer Account Address View for the record groups. |
Implementation/DBA Data: |
APPS.CSI_HZCA_ADDRESSES_V
|
View Text
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
Columns
Name |
PARTY_CITY |
PARTY_ADDRESS |
PARTY_NAME |
CUST_ACCT_SITE_ID |
PARTY_ADDRESS1 |
PARTY_ADDRESS2 |
PARTY_ADDRESS3 |
CUST_ACCOUNT_ID |