How to find Supplier or Customer in TCA Oracle Applications or Difference between Supplier and Customer in TCA

SELECT  PARTY_USAGE_CODE FROM HZ_PARTY_USG_ASSIGNMENTS;


Party usage code in Party_usg_assginments will show is the party Customer or Supplier or Bank.

Distinct values in TCA Party Types:

PARTY_USAGE_CODE

1. BANK
2. BANK_BRANCH
3. CUSTOMER
4. INTERCOMPANY_ORG
5. LEGAL_ENTITY
6. ORG_CONTACT
7. SUPPLIER
8. SUPPLIER_CONTACT