AR_RECEIVABLE_APPLICATIONS APP,AR_CASH_RECEIPTS           CR,AR_PAYMENT_SCHEDULES       PS_INV,HZ_CUST_ACCOUNTS           CUST,HZ_PARTIES                 PARTY,RA_CUSTOMER_TRX            CT,RA_CUST_TRX_TYPES          CTT,RA_CUSTOMER_TRX_LINES      CTL,RA_BATCH_SOURCES           BS,HZ_CUST_SITE_USES          SU,AR_CONS_INV                CI,AR_LOOKUPS                 L_CLASS,AR_RECEIVABLES_TRX         ART
 WHERE APP.DISPLAY = ‘Y‘
   AND APP.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
   AND CT.CUSTOMER_TRX_ID(+) = PS_INV.CUSTOMER_TRX_ID
   AND BS.BATCH_SOURCE_ID(+) = CT.BATCH_SOURCE_ID
   AND CTT.CUST_TRX_TYPE_ID(+) = PS_INV.CUST_TRX_TYPE_ID
   AND CUST.CUST_ACCOUNT_ID(+) = PS_INV.CUSTOMER_ID
   AND CUST.PARTY_ID = PARTY.PARTY_ID(+)
   AND SU.SITE_USE_ID(+) = PS_INV.CUSTOMER_SITE_USE_ID
   AND CTL.CUSTOMER_TRX_LINE_ID(+) = APP.APPLIED_CUSTOMER_TRX_LINE_ID
   AND PS_INV.CLASS = L_CLASS.LOOKUP_CODE
   AND L_CLASS.LOOKUP_TYPE = ‘INV/CM‘
   AND CI.CONS_INV_ID(+) = PS_INV.CONS_INV_ID
   AND APP.APPLIED_PAYMENT_SCHEDULE_ID = PS_INV.PAYMENT_SCHEDULE_ID
   AND ART.RECEIVABLES_TRX_ID(+) = APP.RECEIVABLES_TRX_ID;