AR Receipts To Transaction Drill Down - OracleAppsToday

OracleAppsToday

All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks

• Home
• Basic Oracle Apps
  • AOL
  • API
  • Queries
  • XML Gateway
  • Workflow
• UNIX/Linux
  • Unix/Linux
• PL/SQL
  • Tutorials
• Modules
  • TCA
  • General Ledger
  • Order Management
  • Oracle Pricing
  • Oracle Receivables
  • Oracle Payables
  • Oracle E-Tax
  • Oracle Purchasing
• Repository
• Tips 'N' Tricks
• Out Of the Box
• ORA
• ReviewsToday

Categories

• Accounting
• API
• Big Data
• E-Tax
• General Ledger
• Java
• ORA
• Oracle Apps
• Order Management
• Out Of the Box
• Payables
• PL/SQL
• Pricing
• Purchasing
• Queries
• Receivables
• Repository
• TCA
• Tips n Tricks
• UNIX/LINUX
• Workflow
• XML Gateway

Saturday, May 17, 2014

AR Receipts to Transaction Drill Down

2:51 PM General Ledger, Queries, Receivables No comments select acra.receipt_number, acra.amount, rcta.trx_number, acra.receipt_date, apsa.amount_applied from ar_cash_receipts_all acra, ar_receivable_applications_all araa, ra_customer_trx_all rcta, ar_payment_schedules_all apsa where acra.receipt_number = 'BACS170211MORETON' and apsa.customer_trx_id=rcta.customer_trx_id and araa.cash_receipt_id = acra.cash_Receipt_id and rcta.customer_trx_id=araa.applied_customer_trx_id; Email ThisBlogThis!Share to XShare to Facebook Newer Post Older Post Home

0 comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Social Profiles

Subscribe posts directly to your Inbox :

• Popular Posts
• Archives

• Steps to Create Supplier, Supplier Site and Supplier Banks : Oracle EBS R12 Below are the steps to create Supplier and related sites and banks in Oracle EBS R12 1) Choose the responsibility “Purchasing Super User”....
• Query to find responsibilities attached to a user in Oracle R12 SELECT * FROM FND_USER WHERE user_name LIKE 'DAVIDEVANS'; SELECT *   FROM FND_USER_RESP_GROUPS  WHERE user_id=1180; --user_id i...
• Steps to Pay Invoices using Payment Batch : Oracle EBS R12 With R12 the payment process is streamlined to provide a robust and easy payment experience. Using a single window you can select, build ,...
• Oracle Apps R12 Query to Find Payment against Invoice SELECT b . segment1 vendor_number ,        b . vendor_name vendor_name ,        c . vendor_site_code ,        c . pay_group_look...
• Query to find ORG_ID attached to a responsibility SELECT * --fpov.profile_option_value              FROM applsys.fnd_profile_option_values fpov                 , applsys.fnd_profile_optio...

Blog Archive

• ►  2015 (14)
  • ►  August (1)
  • ►  June (4)
  • ►  May (4)
  • ►  April (3)
  • ►  March (1)
  • ►  January (1)

• ▼  2014 (102)
  • ►  November (3)
  • ►  October (16)
  • ►  September (28)
  • ►  August (15)
  • ►  July (9)
  • ►  June (9)
  • ▼  May (22)
    • Customer Conversion/Interface Techniques in Oracle...
    • Mandatory Column For GL_Interface
    • Creating and Extracting a tar file
    • Accounting FlexFields of Bank Account in R12
    • Request Set of a Concurrent Program
    • Programs in a Request Set
    • Query to find ORG_ID attached to a responsibility
    • Examples of XMLCONCAT in PLSQL
    • How To Calculate Tax as Inclusive on an Invoice Or...
    • Oracle Workflow Important Tables
    • TCA Parties Table Drill Down
    • Query to find strategies of a Customer Oracle R12 AR
    • Tables used in Defining Request Sets Oracle R12
    • Query to find responsibilities attached to a user ...
    • Concurrent Program to Executable Name Drill Down O...
    • AR Transactions to GL Drill Down
    • AR Receipts to Transaction Drill Down
    • Open Requisition of a User
    • Join GL tables with XLA (SubLedger Accounting) tables
    • Few Examples on Dynamic SQL
    • Convert CSV to Rows in Oracle
    • Drill Down from AR Cash Receipts to GL Ledger R12

 

• About Me

  Unknown View my complete profile

• Contact Us/ Submit Post

  Name Email * Message *

• Labels

  Accounting (34) API (8) Big Data (1) E-Tax (1) General Ledger (6) Java (1) ORA (2) Oracle Apps (14) Order Management (5) Out Of the Box (1) Payables (8) PL/SQL (12) Pricing (6) Purchasing (1) Queries (25) Receivables (5) Repository (1) TCA (7) Tips n Tricks (1) UNIX/LINUX (2) Workflow (1) XML Gateway (6)

• Total Pageviews

  

Copyright © OracleAppsToday Designed and Maintained by Anurag Jain