Product: | CSD - Depot Repair |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSD_CUSTOMER_DETAILS_V |
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'