Monday, March 16, 2015

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




No comments:

Post a Comment