AR Receipts Query In Oracle Apps

Home » Ar Cash Receipts Query » AR Receipts Query In Oracle Apps

Maybe your like

Oracle Application's Blog

The purpose of this blog , is to do Knowledge sharing with my Followers through my own Experiences. Contact us for Oracle Applications Job Support , Project Support and any other freelancing work.

  • About us
  • Fusion E-Books
  • Workflows
  • OAF
  • Interfaces
  • Scripts
  • XML
  • Fusion Technical
  • Fusion Financial
  • EBS

Wednesday, 29 August 2018

AR receipts query in oracle apps

AR receipts query in oracle apps

In this post , We will discuss about Oracle receivables receipts sql queries. I will share my sql queries which helps to extract the AR receipts query in oracle apps. This sql query will help to fetch the most of the important information for the Customer receipt in oracle apps. Here below is the complete AR receipts query in oracle apps

Tables Uses in AR receipts query in oracle apps

ar_payment_schedules_all ar_customers HZ_CUST_SITE_USES_ALL HZ_CUST_ACCT_SITES_ALL HZ_PARTY_SITES ar_cash_receipts_all

Complete Example of AR receipts query in oracle apps

select A1.AMOUNT_DUE_ORIGINAL RECEIPT_AMOUNT, A1.AMOUNT_DUE_REMAINING UNAPPLIED_AMOUNT, A1.DUE_DATE,DECODE(A1.STATUS,'OP','OPEN','CL','CLOSED') RECEIPT_STATUS, A1.INVOICE_CURRENCY_CODE, A2.CUSTOMER_NAME, A5.PARTY_SITE_NUMBER, A3.SITE_USE_CODE, A6.RECEIPT_NUMBER, A6.RECEIPT_DATE, A6.COMMENTS, A1.AMOUNT_APPLIED, A1.EXCHANGE_RATE, A1.EXCHANGE_DATE, A1.EXCHANGE_RATE_TYPE from ar_payment_schedules_all A1,ar_customers a2, HZ_CUST_SITE_USES_ALL A3,HZ_CUST_ACCT_SITES_ALL A4,HZ_PARTY_SITES A5,ar_cash_receipts_all A6 where A1.org_id=:P_ORG_ID AND A1.CUSTOMER_ID=A2.CUSTOMER_ID AND A1.CASH_RECEIPT_ID=A6.CASH_RECEIPT_ID and A1.CLASS='PMT' --AND A1.STATUS='OP' ANDA1.CUSTOMER_SITE_USE_ID=A3.SITE_USE_ID AND A3.CUST_ACCT_SITE_ID=A4.CUST_ACCT_SITE_ID AND A4.PARTY_SITE_ID=A5.PARTY_SITE_ID at 22:37 Labels: AR receipts query in oracle apps, Tables Uses in AR receipts query in oracle apps

1 comments:

Anonymous said...

excellent

8 March 2024 at 00:46

Post a Comment

Newer Post Older Post Home

Contact us for any Collaboration, Project Support & On Job Support Work

Name Email * Message *

Know More About Us

  • Products & Offerings

Learn Fusion Financials' (Online Book)

Learn Fusion Financials' (Online Book) Click To Download

Oracle Fusion Self Paced Trainings in Discounted Prices

Oracle Fusion Self Paced Trainings in Discounted Prices Click to know more

Buy Oracle Cloud Instance Access (Click to Know More)

Buy Oracle Cloud Instance Access (Click to Know More)

Oracle Fusion/EBS Interview's Question Answer Series

  • Top 33 Oracle Fusion Order Management Interview Questions
  • TOP 31 Oracle Fusion SCM Cloud Interview Questions
  • TOP 21 Oracle Fusion HCM Interview Questions
  • Complete Tax Setups in Oracle Fusion
  • Top 50 oracle reports interview questions
  • 33 Most Important Oracle Fusion fixed assets interview questions
  • TOP 33 Most Important Oracle Apps Technical Interview Questions
  • 25 Most Important Oracle receivable interview questions
  • 21 Most Important Oracle r12 Payables Interview Questions
  • TOP 20 general ledger interview questions in oracle apps r12
  • TOP 23 Most Important Oracle Fusion Interview Questions
  • TOP 23 Most Important oaf interview questions

Online Oracle Courses (Free of Cost)

  • Complete Tax Setups in Oracle Fusion
  • Learn Tax Implementation in Oracle Fusion
  • Learn P2P Cycle in Oracle Fusion
  • Learn Oracle Reports XML Tutorial
  • Learn Oracle Fusion Custom Roles Tutorial
  • Learn Oracle Fusion Technical Online
  • Learn Oracle Fusion/cloud Financials Online
  • Learn Oracle Cloud BPM Online
  • Learn Complete OAF Step by Step Online
  • Learn Oracle Workflow Builder Online

Online Fusion Application Composer/Customization Book

Online Fusion Application Composer/Customization Book Online Fusion Application Composer/Customization Book Click To Know More

Oracle Fusion Technical Book

Oracle Fusion Technical Book Oracle Fusion Technical Book

Oracle Fusion Web Services(REST& SOAP API's) / Integration Book

Oracle Fusion Web Services(REST& SOAP API's) / Integration Book

Contact Me

[email protected]

Most Viewed Posts

Report Bursting in oracle fusion AR to GL reconciliation in oracle apps r12 Set the override email address in Oracle Fusion How to Create PO and Receiving Inquiry(View Only) Role in Oracle Fusion How to create a new Oracle apps Data base source to Design the BIP reports How to add hyperlink in the email body using Bursting in Oracle Cloud BIP reports What is Rapid Implementation in Oracle Cloud : Rapid Implementation Data Upload Process in Oracle Fusion Drill Down OTBI reports to Navigate Directly in to Oracle Cloud Payment Page How to create vacation rules in Oracle cloud TOP 30 Most Important OAF Interview Questions  

Tag » Ar Cash Receipts Query