Queries - TCA

Distinguish a SUPPLIER / CUSTOMER : 

SELECT hpab.party_usage_code, hpab.party_usage_type, hp.party_name
  FROM apps.hz_party_usg_assignments hpua,
       apps.hz_party_usages_b hpab,
       apps.hz_parties hp
 WHERE     hp.party_id = hpua.party_id
       AND hpua.party_usage_code = hpab.party_usage_code
       AND hpab.party_usage_code LIKE 'SUPPLIER%'
       OR hpab.party_usage_code LIKE 'CUSTOMER%'