AR_PAYMENT_SCHEDULES_ALL

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 […]

Oracle Apps R12 Account Receivables (AR) Tables

The below given are the Account Receivables (AR) Tables used for AR Setup , AR Transactions. Oracle Apps R12 Account Receivables (AR) Tables                     Table Name                                          Table Description AR Setup tables RA_BATCH_SOURCES AR Table for storing the transaction sources RA_CUST_TRX_TYPES_ALL The table stores information about each transaction type for all classes of transactions, for […]

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