AR Receipt Information Report

AR Receipt Information Report

SELECT ACRA.RECEIPT_NUMBER,

       ACRA.RECEIPT_DATE,

       ACRA.AMOUNT,

       ARM.NAME,

       RCT.TRX_NUMBER,

       HP.PARTY_NAME,

       HCA.ACCOUNT_NUMBER

  FROM AR_CASH_RECEIPTS_ALL ACRA,

       AR_RECEIPT_METHODS ARM,

       AR_RECEIVABLE_APPLICATIONS_ALL ARAA,

       AR_PAYMENT_SCHEDULES_ALL APSC,

       RA_CUSTOMER_TRX_ALL RCT,

       HZ_PARTIES HP,

       HZ_CUST_ACCOUNTS HCA

 WHERE ACRA.RECEIPT_METHOD_ID=ARM.RECEIPT_METHOD_ID

   AND ACRA.CASH_RECEIPT_ID=ARAA.CASH_RECEIPT_ID

   AND ARAA.APPLIED_PAYMENT_SCHEDULE_ID=APSC.PAYMENT_SCHEDULE_ID

   AND APSC.CUSTOMER_TRX_ID=RCT.CUSTOMER_TRX_ID

   AND ACRA.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)

   AND HCA.PARTY_ID = HP.PARTY_ID(+)

   AND ACRA.RECEIPT_NUMBER=NVL(:P_RNO,ACRA.RECEIPT_NUMBER)

   AND ACRA.ORG_ID=204