Query To Get AR Receipt, Invoice And Bank Details In Oracle Apps

Home » Ar_cash_receipt_history_all Query » Query To Get AR Receipt, Invoice And Bank Details In Oracle Apps

Maybe your like

  • Skip to navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer
pacesettergraam

Concentrate where you are, Focus where you want to go

  • Home
  • Get Me
  • Home Town
  • Its Me
← Installing Emacs Reference Manual in Debian 11 Printing a Diamond Star/Rhombus Dynamically in Java → Query to get AR Receipt, Invoice and Bank Details in Oracle Apps

Sep 28

Posted by pacesettergraam

Below is the Query to get AR Receipt, Invoice and Bank Details. Before executing the Query set the MO_GLOBAL.SET_POLICY_CONTEXT and execute

BEGIN MO_GLOBAL.SET_POLICY_CONTEXT('S', 83); END; --Applied Receipts SELECT acra.RECEIPT_NUMBER, acra.DOC_SEQUENCE_VALUE, ACRA.RECEIPT_DATE, ACRA.COMMENTS, ACRA.amount, ARAA.AMOUNT_APPLIED, rcta.TRX_NUMBER, araa.gl_date Receipt_applied_gl_date, acrha.GL_Date, BB.BANK_NAME REMIT_BANK_NAME, BB.BANK_BRANCH_NAME REMIT_BANK_BRANCH FROM AR_CASH_RECEIPTS_ALL acra, AR_CASH_RECEIPT_HISTORY_ALL acrha, AR_RECEIVABLE_APPLICATIONS_ALL araa, RA_CUSTOMER_TRX_ALL rcta, HZ_CUST_SITE_USES_ALL HCSUA, CE_BANK_ACCOUNTS CBA, CE_BANK_ACCT_USES_OU REMIT_BANK, CE_BANK_BRANCHES_V BB WHERE acrha.CASH_RECEIPT_ID = acra.CASH_RECEIPT_ID AND acrha.CASH_RECEIPT_HISTORY_ID = araa.CASH_RECEIPT_HISTORY_ID(+) AND acrha.CASH_RECEIPT_ID = araa.CASH_RECEIPT_ID(+) AND araa.display = 'Y' AND rcta.CUSTOMER_TRX_ID(+) = araa.APPLIED_CUSTOMER_TRX_ID AND rcta.BILL_TO_SITE_USE_ID = HCSUA.SITE_USE_ID(+) AND REMIT_BANK.BANK_ACCT_USE_ID(+) = acra.REMIT_BANK_ACCT_USE_ID AND REMIT_BANK.ORG_ID(+) = acra.ORG_ID AND remit_bank.bank_account_id = CBA.bank_account_id(+) AND BB.BRANCH_PARTY_ID(+) = CBA.BANK_BRANCH_ID AND acra.TYPE <> 'MISC' AND acrha.GL_Date BETWEEN :P_START_DATE AND :P_END_DATE -- Pass Dates in parameter --Miscellaneous Receipt UNION ALL SELECT acra.RECEIPT_NUMBER, acra.DOC_SEQUENCE_VALUE, ACRA.RECEIPT_DATE, ACRA.COMMENTS, ACRA.amount, NULL AMOUNT_APPLIED, NULL TRX_NUMBER, NULL Receipt_applied_gl_date, acrha.GL_Date, BB.BANK_NAME REMIT_BANK_NAME, BB.BANK_BRANCH_NAME REMIT_BANK_BRANCH FROM AR_CASH_RECEIPTS_ALL acra, AR_CASH_RECEIPT_HISTORY_ALL acrha -- ,AR_RECEIVABLE_APPLICATIONS_ALL araa -- ,RA_CUSTOMER_TRX_ALL rcta -- ,HZ_CUST_SITE_USES_ALL HCSUA, , CE_BANK_ACCOUNTS CBA, CE_BANK_ACCT_USES_OU REMIT_BANK, CE_BANK_BRANCHES_V BB WHERE acrha.CASH_RECEIPT_ID = acra.CASH_RECEIPT_ID -- AND acrha.CASH_RECEIPT_HISTORY_ID = araa.CASH_RECEIPT_HISTORY_ID(+) -- AND acrha.CASH_RECEIPT_ID = araa.CASH_RECEIPT_ID(+) -- and araa.display = 'Y' -- AND rcta.CUSTOMER_TRX_ID(+) = araa.APPLIED_CUSTOMER_TRX_ID -- AND rcta.BILL_TO_SITE_USE_ID = HCSUA.SITE_USE_ID(+) AND REMIT_BANK.BANK_ACCT_USE_ID(+) = acra.REMIT_BANK_ACCT_USE_ID AND REMIT_BANK.ORG_ID(+) = acra.ORG_ID AND remit_bank.bank_account_id = CBA.bank_account_id(+) AND BB.BRANCH_PARTY_ID(+) = CBA.BANK_BRANCH_ID AND acra.TYPE = 'MISC' AND acrha.GL_Date BETWEEN :P_START_DATE AND :P_END_DATE -- Pass Dates in parameter ORDER BY RECEIPT_NUMBER;

Share this:

  • X
  • Facebook
  • More
  • Pinterest
  • LinkedIn
  • Tumblr
  • Reddit
Like Loading...

Related

Unknown's avatar

About pacesettergraam

A good and realistic person View all posts by pacesettergraam »

Posted on September 28, 2021, in SQL/PLSQL, Technical and tagged AR Invoice, AR Receipt, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, Bank, Bank Details, CE_BANK_ACCOUNTS, Invoice, RA_CUSTOMER_TRX_ALL, Receipt. Bookmark the permalink. Leave a comment.

← Installing Emacs Reference Manual in Debian 11 Printing a Diamond Star/Rhombus Dynamically in Java →

  • Leave a comment

  • Comments 0

Leave a comment Cancel reply

Δ

  • Search for:
  • September 2021
    M T W T F S S
    12345
    6789101112
    13141516171819
    20212223242526
    27282930
    « Aug Oct »

  • Recent Posts

    • Query Based on Recursion to Deduct total quantity from lines
    • Reproduce packages from one user to another
    • Installing tamil language in Gnu guix
    • Query to get Sale Order and Move Order Info in Oracle apps R12 EBS
    • Install Oracle JDK in Ubuntu 24.04
    • Installing Forticlient VPN in Ubuntu
    • Using TRAMP to connect to remote server from Emacs on OCI Instance
    • Creating a simple Oracle Integration
    • A great time at Periya Pathai to Sabarimala
    • Writing large volume of Data to File from Oracle Tables using PLSQL in Oracle apps

  • Categories

    • AI
    • Chennai
    • Coding
    • coding-web development
    • emacs
    • Free Software
    • Free Tools/Apps
    • Functional
    • Git
    • Java
    • life
    • linux
    • lisp
    • MS
    • OAF & Forms
    • Oracle
    • oracle apps
    • oracle apps hrms
    • Photography
    • Reports – RDF & RTF
    • sabayon
    • SQL/PLSQL
    • Technical
    • Trek
    • ubuntu
    • Uncategorized
    • wordpress
    • Workflow & AME

  • Your Area

    Map

  • Creative Commons License

    This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

    Creative Commons LicenseBlog posts by Gowtham Raam is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

    You are free to:

    Share — copy and redistribute the material in any medium or format Adapt — remix, transform, and build upon the material for any purpose, even commercially.

    The licensor cannot revoke these freedoms as long as you follow the license terms.

    Under the following terms:

    Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

    ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.

    No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.

Blog at WordPress.com.

  • Comment
  • Reblog
  • Subscribe Subscribed
    • pacesettergraam
      • Sign me up
    • Already have a WordPress.com account? Log in now.
    • pacesettergraam
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • View post in Reader
    • Manage subscriptions
    • Collapse this bar
%d Design a site like this with WordPress.comGet started

Tag » Ar_cash_receipt_history_all Query