query to get unpaid invoices in oracle apps

AR SQL Query to get Open Invoices where Customer payment status is Open

Hi All, The below given SQL Query for Oracle Apps Receivables (AR)  provides the main columns from the table – RA_CUSTOMER_TRX_ALL and AR_PAYMENT_SCHEDULES_ALL to get the details for the Open Invoices for a particular Customer ( enter TRX_NUMBER) or for all Customers. SELECTRA_CUST_TRX.STATUS_TRX,RA_CUST_TRX.TRX_NUMBER,RA_CUST_TRX.TRX_DATE,RA_CUST_TRX.BILLING_DATE,RA_CUST_TRX.BATCH_ID,RA_CUST_TRX.BATCH_SOURCE_ID,RA_TERMS.NAME || ‘-‘ || RA_TERMS.DESCRIPTION   TERM_NAME,RA_CUST_TRX.INVOICE_CURRENCY_CODE TRX_CURR,APS.ORG_ID,APS.CUSTOMER_ID,APS.CUSTOMER_TRX_ID,–APS.TRX_NUMBER,–APS.TRX_DATE,APS.GL_DATE,APS.CLASS,APS.GL_DATE_CLOSED,APS.STATUS PAYMENT_STATUS,APS.INVOICE_CURRENCY_CODE,APS.EXCHANGE_DATE,APS.EXCHANGE_RATE_TYPE,APS.EXCHANGE_RATE,APS.DUE_DATE,APS.AMOUNT_DUE_ORIGINAL,APS.AMOUNT_DUE_REMAINING,APS.AMOUNT_LINE_ITEMS_REMAINING,APS.AMOUNT_APPLIED,APS.NUMBER_OF_DUE_DATESFROMHZ_CUST_ACCOUNTS HZ_ACCT,HZ_PARTIES HP,HZ_CUST_ACCT_SITES_ALL HCASA,HZ_CUST_SITE_USES_ALL HCSUA,HZ_PARTY_SITES HPS_BILL,RA_CUST_TRX_LINE_GL_DIST_ALL […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.