SELECT HZ.PARTY_ID CUSTOMER_ID ,HZ.PARTY_NAME CUSTOMER_NAME ,DECODE( HZ.PARTY_TYPE, 'ORGANIZATION', HZ.ORGANIZATION_NAME_PHONETIC,HZ.PERSON_LAST_NAME_PHONETIC || ' ' || HZ.PERSON_FIRST_NAME_PHONETIC ) ALTERNATE_NAME , HZ.PARTY_NUMBER CUSTOMER_NUMBER , HZ.PARTY_TYPE CUSTOMER_TYPE FROM HZ_PARTIES HZ WHERE EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS HZA WHERE HZ.PARTY_ID = HZA.PARTY_ID )
SELECT HZ.PARTY_ID CUSTOMER_ID
, HZ.PARTY_NAME CUSTOMER_NAME
, DECODE( HZ.PARTY_TYPE
, 'ORGANIZATION'
, HZ.ORGANIZATION_NAME_PHONETIC
, HZ.PERSON_LAST_NAME_PHONETIC || ' ' || HZ.PERSON_FIRST_NAME_PHONETIC ) ALTERNATE_NAME
, HZ.PARTY_NUMBER CUSTOMER_NUMBER
, HZ.PARTY_TYPE CUSTOMER_TYPE
FROM HZ_PARTIES HZ
WHERE EXISTS(SELECT 1
FROM HZ_CUST_ACCOUNTS HZA
WHERE HZ.PARTY_ID = HZA.PARTY_ID )
|
|
|