[Home] [Help]
View: AR_TA_VRH_RLINES_V
Product: | AR - Receivables |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RH.BATCH_NAME
, RH.CHECK_NUMBER
, RH.CASH_RECEIPT_ID
, RH.HISTORY_LINE_ID
, RH.TRX_NUMBER
, RH.TRX_AMOUNT
, RH.CUSTOMER_REF_NUMBER
, CRP.NAME
, CR.SHORT_NAME
, RH.EDI_REASS_TRACE_NUMBER
, RH.EDI_TRX_HANDLING_CODE
FROM AR_TA_REMIT_HIST RH
, AR_TA_REMIT_PROF CRP
, AR_TA_RULES CR
WHERE RH.RECORD_TYPE = 6
AND RH.CREATED_FROM = 'CASH_ENGINE'
AND CRP.PROFILE_ID(+) = RH.PROFILE_ID
AND CR.RULE_ID(+) = RH.RULE_ID
Columns
Name |
BATCH_NAME |
CHECK_NUMBER |
CASH_RECEIPT_ID |
HISTORY_LINE_ID |
TRX_NUMBER |
TRX_AMOUNT |
CUSTOMER_REF_NUMBER |
NAME |
SHORT_NAME |
EDI_REASS_TRACE_NUMBER |
EDI_TRX_HANDLING_CODE |