Join Between Ar_cash_receipts_all And Ra_customer_trx_all

Home » Ar_cash_receipts_all » Join Between Ar_cash_receipts_all And Ra_customer_trx_all

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

Monday, 3 December 2018

Join between ar_cash_receipts_all and ra_customer_trx_all

Join between ar_cash_receipts_all and ra_customer_trx_all

ar_cash_receipts_all tables store the Customer Receipt or we can say payments in oracle apps and ra_customer_trx_all table store the Customer Invoices in the Oracle Apps. When we receipt the Customer Receipts , then we don’t enter any Invoice number for against which AR Invoices we are getting this payment but we apply this payment or receipt to the Customer Invoice to make it close. So the join between ar_cash_receipts_all and ra_customer_trx_all only works when we apply the Customer Receipt with the Customer Invoice. Here below is the example of the SQL query using Joins between ar_cash_receipts_all and ra_customer_trx_all. Join between ar_cash_receipts_all and ra_customer_trx_all

Tables Joins between ar_cash_receipts_all and ra_customer_trx_all

AR_CASH_RECEIPTS_ALL==>CASH_RECEIPT_ID AR_RECEIVABLE_APPLICATIONS_ALL ==> CASH_RECEIPT_ID , APPLIED_CUSTOMER_TRX_ID RA_CUSTOMER_TRX_ALL ==>CUSTOMER_TRX_ID join between ar_cash_receipts_all and ra_customer_trx_all

SQL Query Using Join between ar_cash_receipts_all and ra_customer_trx_all

SELECT ACRA.AMOUNT "Receipt Amount", ACRA.CURRENCY_CODE, ACRA.TYPE, ACRA.RECEIPT_NUMBER, ACRA.RECEIPT_DATE, RCTA.TRX_NUMBER "AR Invoice", RCTA.TRX_DATE"AR Invoice Date", ARAA.AMOUNT_APPLIED FROM AR_RECEIVABLE_APPLICATIONS_ALL ARAA , AR_CASH_RECEIPTS_ALL ACRA, RA_CUSTOMER_TRX_ALL RCTA WHEREARAA.CASH_RECEIPT_ID=ACRA.CASH_RECEIPT_ID AND ACRA.RECEIPT_NUMBER =: P_RECEIPT_NUMBER AND ARAA.APPLIED_CUSTOMER_TRX_ID=RCTA.CUSTOMER_TRX_ID; at 22:09 Labels: Join between ar_cash_receipts_all and ra_customer_trx_all, SQL Query Using Join between ar_cash_receipts_all and ra_customer_trx_all

0 comments:

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_all