[Home] [Help]
View: AR_TA_VRH_ADJ_V
Product: | AR - Receivables |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RH.BATCH_NAME
, RH.CHECK_NUMBER
, RH.HISTORY_LINE_ID
, RH.PARENT_HISTORY_LINE_ID
, RH.ADJUSTMENT_ID
, RH.ADJUSTMENT_NUMBER
, ADJ.AMOUNT ADJ_AMOUNT
, ADJ.STATUS
, ADJ.TYPE ADJ_TYPE
, RTRX.NAME ADJ_ACTIVITY
FROM AR_ADJUSTMENTS ADJ
, AR_RECEIVABLES_TRX RTRX
, AR_TA_REMIT_HIST RH
WHERE ADJ.RECEIVABLES_TRX_ID = RTRX.RECEIVABLES_TRX_ID
AND RH.RECORD_TYPE=9
AND RH.CREATED_FROM = 'CASH_ENGINE'
AND RH.ADJUSTMENT_ID=ADJ.ADJUSTMENT_ID
Columns
Name |
BATCH_NAME |
CHECK_NUMBER |
HISTORY_LINE_ID |
PARENT_HISTORY_LINE_ID |
ADJUSTMENT_ID |
ADJUSTMENT_NUMBER |
ADJ_AMOUNT |
STATUS |
ADJ_TYPE |
ADJ_ACTIVITY |