95: HZ_PARTIES PARTY,
96: HZ_CUST_ACCOUNTS CUST,
97: AR_CASH_RECEIPTS_ALL CR,
98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,
99: AR_BATCHES_ALL REM_BAT,
100: AR_BATCHES_ALL BAT,
101: AR_BATCHES_ALL BAT_BR,
102: AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED
103: WHERE
96: HZ_CUST_ACCOUNTS CUST,
97: AR_CASH_RECEIPTS_ALL CR,
98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,
99: AR_BATCHES_ALL REM_BAT,
100: AR_BATCHES_ALL BAT,
101: AR_BATCHES_ALL BAT_BR,
102: AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED
103: WHERE
104: CR.PAY_FROM_CUSTOMER = CUST.CUST_ACCOUNT_ID (+)
97: AR_CASH_RECEIPTS_ALL CR,
98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,
99: AR_BATCHES_ALL REM_BAT,
100: AR_BATCHES_ALL BAT,
101: AR_BATCHES_ALL BAT_BR,
102: AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED
103: WHERE
104: CR.PAY_FROM_CUSTOMER = CUST.CUST_ACCOUNT_ID (+)
105: AND CUST.PARTY_ID = PARTY.PARTY_ID(+)