SELECT party_id, party_name, decode(party_type,'PERSON','Customer','ORGANIZATION','Customer','PARTY_RELATIONSHIP','Customer') Type from hz_parties union select person_id, full_name, decode(attribute_category,'EMP','Employee','Employee') Type from per_workforce_current_x
SELECT PARTY_ID
, PARTY_NAME
, DECODE(PARTY_TYPE
, 'PERSON'
, 'CUSTOMER'
, 'ORGANIZATION'
, 'CUSTOMER'
, 'PARTY_RELATIONSHIP'
, 'CUSTOMER') TYPE
FROM HZ_PARTIES UNION SELECT PERSON_ID
, FULL_NAME
, DECODE(ATTRIBUTE_CATEGORY
, 'EMP'
, 'EMPLOYEE'
, 'EMPLOYEE') TYPE
FROM PER_WORKFORCE_CURRENT_X
|
|
|