Showing posts with label Customers table in Oracle apps R12. Show all posts
Showing posts with label Customers table in Oracle apps R12. Show all posts

Saturday, 23 August 2014

Customers and Account Receivables tables in Oracle



Customer tables in Oracle Applications R12 are as follows:-

  • HZ_CUST_ACCOUNTS
  • HZ_CUST_ACCT_SITES_ALL
  • HZ_CUST_SITE_USES_ALL
  • HZ_PARTIES
  • HZ_PARTY_SITES
  • HZ_LOCATIONS


Account Receivables tables in Oracle Applications R12 are as follows:-

  • RA_CUSTOMER_TRX_ALL
  • RA_CUSTOMER_TRX_LINES_ALL
  • RA_CUST_TRX_LINE_GL_DIST_ALL
  • RA_CUST_TRX_LINE_SALESREPS_ALL
  • AR_CASH_RECEIPTS_ALL
  • AR_RECEIVABLE_APPLICATIONS_ALL
  • AR_PAYMENT_SCHEDULES_ALL
  • AR_CASH_RECEIPT_HISTORY_ALL