Skip to content

oracleappshelp.com

Node.JS Blogs

  • MongoDB
  • Oracle R12
  • SOA Suite 12c
  • ADF 12c
  • Interview Questions
  • Node.js
  • ReactJS

Categories

  • ADF Issues
  • Angular JS
  • AP- Account Payables
  • Architecture
  • cloud computing
  • Databases
  • Devops
  • FA – Fixed Assets
  • Interview Questions
  • Java
  • Java Basics
  • Java Springs
  • JavaScript
  • JDeveloper
  • MongoDB tutorial
  • Node.js tutorial
  • OM- Order Managment
  • Oracle ADF
  • Oracle Apps
  • Oracle General Ledger
  • Oracle Receivables
  • Oracle SOA
  • ReactJS Tutorial
  • SQL Server
  • System Administrator
  • WebLogic
  • XML Tutorial

Popular Tutorials

  • MongoDB
  • Oracle R12
  • SOA Suite 12c
  • ADF 12c
  • Interview Questions
  • Node.js
  • ReactJS

Pages

  • MongoDB Tutorial for beginners
  • Oracle ADF 12c Tutorials for beginners
  • Oracle EBS R12 Tutorials
  • Oracle SOA Suite 12c Tutorials for beginners
  • React JS Programming Tutorial for beginners
  • RSS Feed
  • Style Components in React JS

Tag: Oracle apps AR Cash Receipt for Bank Account Id

Oracle EBS R12 AR SQL to get Customer Bank details

14 Mar 2016 oracleappsadmin

The below given Bank Query retrieves data for AR Cash Receipt Number

SELECT   APBB.BANK_NAME BANK_ACCOUNT_NAME ,
APBAA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM,
APBAA.BANK_ACCOUNT_ID,
HP.PARTY_NAME CUSTOMER_NAME,
HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER,
ACR.PAY_FROM_CUSTOMER CUST_ACCOUNT_ID,
ACR.RECEIPT_NUMBER RECEIPT_NUMBER,
ACR.CURRENCY_CODE,
ACR.SET_OF_BOOKS_ID,
ACR.TYPE,
ACR.DEPOSIT_DATE DEPOSIT_DATE,
ACR.RECEIPT_DATE RECEIPT_DATE,
ACR.AMOUNT RECEIPT_AMOUNT ,
ARM.NAME DOCUMENT_TYPE
FROM
HZ_PARTIES HP,
HZ_CUST_ACCOUNTS_ALL HCA,
AR_CASH_RECEIPTS_ALL ACR,
AR_RECEIPT_METHODS ARM,
AR_RECEIPT_CLASSES ARC,
AP_BANK_ACCOUNTS_ALL APBAA,
AP_BANK_BRANCHES APBB
WHERE       1 = 1
AND ACR.CONFIRMED_FLAG = 'Y'
AND ACR.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)
AND HP.PARTY_ID(+) = HCA.PARTY_ID
AND ACR.REMITTANCE_BANK_ACCOUNT_ID = APBAA.BANK_ACCOUNT_ID(+)
AND APBB.BANK_BRANCH_ID(+) = APBAA.BANK_BRANCH_ID
AND ACR.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID
AND ARM.RECEIPT_CLASS_ID = ARC.RECEIPT_CLASS_ID
--AND APBAA.Bank_Account_Id = NVL (:p_bank_account_id, APBAA.Bank_Account_Id)
AND ACR.RECEIPT_NUMBER = '538AR201507030'
--AND TRUNC (acr.receipt_date) >= '31-MAY-2015'
-- AND TRUNC (acr.receipt_date) <= '30-JUN-2015'
ORDER BY ACR.RECEIPT_DATE DESC


AP- Account Payables AP Bank Query, AR Cash Receipt Bank Info, AR Cash Receipt for Bank Account Id, Customer Bank Data, Oracle apps AR Cash Receipt for Bank Account Id, Oracle apps Customer Bank Data, Oracle apps R12 AP Bank Query

Meta

  • Register
  • Log in

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Powered by WordPress. Theme: Brawny by Webulous Themes

Recent Posts

  • How to create legal entity registration in Oracle Fusion
  • Query to get organization structure details in Oracle Fusion General Ledger
  • Assign Legal Entities and Balancing segments in Oracle Fusion
  • Create Legal Entity in Oracle Fusion
  • How to Create Implementation Project in Oracle Fusion
  • Purchase Requisition BPM Approval Workflow Tables in Oracle Fusion
  • Query to get Oracle Fusion Payables Cloud approver comments
  • How to create implementation user in Oracle Fusion
  • Functional Setup Manager in Oracle fusion
  • Top 50 AJAX Interview Questions and Answers