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_DISPUTE_HISTORY_V

Product:	AR - Receivables
Description:	(Release 115 Only)
Implementation/DBA Data:	APPS.AR_DISPUTE_HISTORY_V

View Text

SELECT DH.ROWID
, DH.DISPUTE_HISTORY_ID
, DH.PAYMENT_SCHEDULE_ID
, PS.AMOUNT_DUE_REMAINING
, DH.AMOUNT_IN_DISPUTE
, DH.DISPUTE_AMOUNT
, DH.START_DATE
, DH.END_DATE
, DH.CREATION_DATE
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATED_BY
, DH.LAST_UPDATE_LOGIN
, DH.CREATED_BY
, DH.CREATED_FROM
, FNDU.USER_NAME
FROM AR_DISPUTE_HISTORY DH
, FND_USER FNDU
, AR_PAYMENT_SCHEDULES PS
WHERE FNDU.USER_ID = DH.LAST_UPDATED_BY
AND DH.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID

Columns

Name
ROW_ID
DISPUTE_HISTORY_ID
PAYMENT_SCHEDULE_ID
AMOUNT_DUE_REMAINING
AMOUNT_IN_DISPUTE
DISPUTE_AMOUNT
START_DATE
END_DATE
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATED_FROM
FNDU_CREATED_BY