VIEW: APPS.CSD_CUSTOMER_DETAILS_V

Source

View Text - Preformatted

SELECT hca1.ROWID, hps1.party_id, hps1.party_site_id, hps1.location_id, hp.party_number, hp.party_name, hp.party_type, hp.person_first_name, hp.person_last_name, hca1.account_number, hca1.account_name, hps1.country bill_to_country, hps1.address1||','||hps1.address2||','||hps1.address3||','||hps1.address4||','||hps1.city||','||hps1.state||hps1.postal_code bill_to_address, hps2.country ship_to_country, hps2.address1||','||hps2.address2||','||hps2.address3||','||hps2.address4||','||hps2.city||','||hps2.state||hps2.postal_code ship_to_address FROM hz_party_sites_v hps1, hz_cust_accounts hca1, hz_party_sites_v hps2, hz_cust_accounts hca2, hz_parties hp WHERE hps1.party_id = hca1.party_id AND hps1.site_use_type = 'BILL_TO' AND hps1.party_id = hp.party_id AND hps2.party_id = hca2.party_id AND hps2.site_use_type = 'SHIP_TO'

View Text - HTML Formatted

SELECT HCA1.ROWID
, HPS1.PARTY_ID
, HPS1.PARTY_SITE_ID
, HPS1.LOCATION_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, HP.PARTY_TYPE
, HP.PERSON_FIRST_NAME
, HP.PERSON_LAST_NAME
, HCA1.ACCOUNT_NUMBER
, HCA1.ACCOUNT_NAME
, HPS1.COUNTRY BILL_TO_COUNTRY
, HPS1.ADDRESS1||'
, '||HPS1.ADDRESS2||'
, '||HPS1.ADDRESS3||'
, '||HPS1.ADDRESS4||'
, '||HPS1.CITY||'
, '||HPS1.STATE||HPS1.POSTAL_CODE BILL_TO_ADDRESS
, HPS2.COUNTRY SHIP_TO_COUNTRY
, HPS2.ADDRESS1||'
, '||HPS2.ADDRESS2||'
, '||HPS2.ADDRESS3||'
, '||HPS2.ADDRESS4||'
, '||HPS2.CITY||'
, '||HPS2.STATE||HPS2.POSTAL_CODE SHIP_TO_ADDRESS
FROM HZ_PARTY_SITES_V HPS1
, HZ_CUST_ACCOUNTS HCA1
, HZ_PARTY_SITES_V HPS2
, HZ_CUST_ACCOUNTS HCA2
, HZ_PARTIES HP
WHERE HPS1.PARTY_ID = HCA1.PARTY_ID
AND HPS1.SITE_USE_TYPE = 'BILL_TO'
AND HPS1.PARTY_ID = HP.PARTY_ID
AND HPS2.PARTY_ID = HCA2.PARTY_ID
AND HPS2.SITE_USE_TYPE = 'SHIP_TO'