Query to find Credit Memos on an AP invoice
•By Amol Jadhav
Query to find Credit Memos on an AP invoice
Oracle apps ebs Credit Memos on an AP invoice
SQL Querysql
1SELECT COUNT (DISTINCT ai2.invoice_num), ai1.invoice_num
2 FROM ap.ap_invoices_all ai1,
3 ap.ap_invoice_distributions_all aid1,
4 ap.ap_invoices_all ai2
5 WHERE ai1.invoice_id = aid1.invoice_id
6 AND aid1.parent_invoice_id = ai2.invoice_id
7 AND ai1.org_id = ai2.org_id
8GROUP BY ai1.invoice_numRelated posts:
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS