Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RH.BATCH_NAME
, RH.CHECK_NUMBER
, RH.CASH_RECEIPT_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, RH.LAST_UPDATE_DATE
, RH.DEPOSIT_DATE
, RH.POSTMARK_DATE
, RH.RECEIPT_DATE
, RH.REMITTANCE_AMOUNT
, RH.APPLICATION_STATUS
, RH.CURRENCY_CODE
, RH.EDI_REASS_TRACE_NUMBER
, RH.EDI_TRX_HANDLING_CODE
FROM AR_TA_REMIT_HIST RH
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE RH.RECORD_TYPE = 5
AND RH.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID =PARTY.PARTY_ID
AND RH.CREATED_FROM = 'CASH_ENGINE'