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.

VIEW: APPS.AR_DISPUTE_HISTORY_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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