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 Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...