Sunday, July 22, 2018

(AR) Account Receivable Important tables in Oracle APPS

  • TRANSACTIONS(AR INVOICES)
Select * from   RA_CUSTOMER_TRX_ALL

Select * from   RA_CUSTOMER_TRX_LINES_ALL

Select * from   RA_CUST_TRX_LINE_GL_DIST_ALL

Select * from   RA_CUST_TRX_LINE_SALESREPS_ALL

  • AR CASH RECEIPTS
Select * from   AR_CASH_RECEIPTS_ALL

  • AR INVOICE TYPES
Select * from   RA_CUST_TRX_TYPES_ALL

  • AR BATCH SOURCE
Select * from   RA_BATCH_SOURCES_ALL

  • AR SALES REPS
Select * from   RA_SALESREPS_ALL

  • AR PAYMENT TERMS
Select * from   RA_TERMS_TL

Select * from   RA_TERMS_LINES

  • AR RECEIPT PAYMENT METHOD
Select * from   AR_RECEIPT_METHODS

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...