eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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