Thursday, 24 May 2012

account receivable(ar)important tables in oracle apps


--ACCOUNT RECIEVABLES TABLES

--TRANSACTIONS(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

--CASH RECIEPTS

Select * from   AR_CASH_RECEIPTS_ALL

--INVOICE TYPES

Select * from   RA_CUST_TRX_TYPES_ALL

--SOURCE

Select * from   RA_BATCH_SOURCES_ALL

--SALES REPS

Select * from   RA_SALESREPS_ALL

--PAYMENT TERMS

Select * from   RA_TERMS_TL

Select * from   RA_TERMS_LINES

--RECEIPT PAYMENT METHOD

Select * from   AR_RECEIPT_METHODS



3 comments:

  1. Wonderful job on completing the posts about island of oracle applications. I've seen also your past articles about them and I'm glad you continued the trend. Thanks for posting.

    ReplyDelete