Oracle SQL Query to Customer Invoices

 Here is the sample SQL Query to analyze the Customer Invoices. Please note this is sample, please modify accordingly as per your requirement :

SELECT 
  hca.ACCOUNT_NUMBER,
  hca.ACCOUNT_NAME,
  rcta.TRX_NUMBER,
  rcta.TRX_DATE,
  rcta.INVOICE_CURRENCY_CODE,
  rctla.EXTENDED_AMOUNT
FROM RA_CUSTOMER_TRX_ALL rcta,
     RA_CUSTOMER_TRX_LINES_ALL rctla,
     HZ_CUST_ACCOUNTS hca
WHERE rcta.CUSTOMER_TRX_ID = rctla.CUSTOMER_TRX_ID
AND   rcta.BILL_TO_CUSTOMER_ID = hca.CUST_ACCOUNT_ID
WHERE rcta.TRX_DATE BETWEEN :P_START_DATE AND :P_END_DATE;