Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 13 Vote(s) - 3.62 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How t query AR on Account Receipts
#1
Hello,
I want to query all on accounts receipt, actually I didn’t know what the exact query is. How can i query them. We are using r12.1.3.
Thanks.

 
Reply
Thanks given by:
#2
you can check these:
AR_CASH_RECEIPTS_ALL Cash Receipt Header tables
AR_RECEIVABLE_APPLICATIONS_ALL stores Receipt Application details
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Change bank account for supplier payment Danuj Ganesh 2 1,190 10-05-2016, 05:20 PM
Last Post: waelmadj
  Want to add different suppliers as Primary Account Owners Ryan Adam 1 833 05-24-2015, 03:55 PM
Last Post: Zishan Ali
  how to define summary account Ali Rizwan 3 972 01-15-2015, 06:17 PM
Last Post: Ali Rizwan
  Unable to find end date for bank account Balin Chakra 1 750 01-02-2015, 12:39 AM
Last Post: M Irfan
  Customer and customer account should create automatically from Supplier Emily Sarah 1 833 12-04-2014, 07:36 PM
Last Post: Saleem Akhtar
  Need exact values of invoice status and accounted in query? Balin Chakra 1 2,310 11-13-2014, 03:55 PM
Last Post: Shoaib Ali
  Retained earnings should be a balance sheet account Archita Jartin 1 2,067 09-02-2014, 06:21 PM
Last Post: M Irfan
Question Purpose of translation adjustment of account in oracle r12. Divya Omkar 2 1,179 07-23-2014, 09:19 PM
Last Post: Divya Omkar
  Change FA clearing account Kashif Manzoor 2 7,508 05-31-2011, 05:31 PM
Last Post: shirfanarshad
  online GL Account Analysis inquiry Sara Khan 2 4,999 12-12-2010, 11:21 PM
Last Post: nandu



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!