Query to find number of AR invoices received
Hi All,
Looking for a query to find Number of AR Receipts Received (All receipt methods)
I am using below sql. However it is giving duplicates
SELECT DISTINCT
TO_CHAR (acra.creation_date , 'MON', 'nls_date_language=American') period_name,
COUNT(acra.CASH_RECEIPT_ID ) tot_count
FROM
AR_CASH_RECEIPTS_ALL acra,
AR_RECEIPT_CLASSES arc,
AR_RECEIPT_METHODS arm,
AR_RECEIVABLE_APPLICATIONS_ALL ara,
AR_CASH_RECEIPT_HISTORY_ALL acrha,
hr_operating_units hou
WHERE
1 = 1
AND acra.CASH_RECEIPT_ID = acrha.CASH_RECEIPT_ID
AND acra.CASH_RECEIPT_ID = ara.CASH_RECEIPT_ID
--AND acra.CASH_RECEIPT_ID = arc.CASH_RECEIPT_ID