Receivables - EBS (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center