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.IEX_DUNNING_HISTORY_V

Source

View Text - Preformatted


SELECT PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, COR.CUSTOMER_ID CUSTOMER_ID, COR.SITE_USE_ID CUSTOMER_SITE_USE_ID, CPS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, PS.INVOICE_CURRENCY_CODE CURRENCY_CODE, PS.CONS_INV_ID CONS_INV_ID , COR.CORRESPONDENCE_DATE DUNNING_DATE, CPS.STAGED_DUNNING_LEVEL DUNNING_LEVEL, CPS.AMOUNT_ACCRUE AMOUNT_ACCRUE, DL.LETTER_NAME LETTER_NAME, DLS.NAME NAME, DLS.DUNNING_TYPE DUNNING_TYPE, DLS.DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID, COR.CORRESPONDENCE_ID CORRESPONDENCE_ID, DECODE (SP.ACCRUE_INTEREST, 'Y',CPS.AMOUNT_ACCRUE, 'N', CPS.AMOUNT_UNACCRUE ) INTEREST_AMT, COR.ORG_ID ORG_ID, COR.ROWID ROW_ID FROM AR_CORRESPONDENCES COR, AR_DUNNING_LETTER_SETS DLS, AR_DUNNING_LETTERS DL, AR_CORRESPONDENCE_PAY_SCHED CPS, AR_SYSTEM_PARAMETERS SP, AR_PAYMENT_SCHEDULES PS WHERE DLS.DUNNING_LETTER_SET_ID = COR.REFERENCE1 AND DL.DUNNING_LETTER_ID = COR.REFERENCE2 AND CPS.CORRESPONDENCE_ID = COR.CORRESPONDENCE_ID AND PS.PAYMENT_SCHEDULE_ID = CPS.PAYMENT_SCHEDULE_ID AND COR.PRELIMINARY_FLAG = 'N'

View Text - HTML Formatted

SELECT PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, COR.CUSTOMER_ID CUSTOMER_ID
, COR.SITE_USE_ID CUSTOMER_SITE_USE_ID
, CPS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.INVOICE_CURRENCY_CODE CURRENCY_CODE
, PS.CONS_INV_ID CONS_INV_ID
, COR.CORRESPONDENCE_DATE DUNNING_DATE
, CPS.STAGED_DUNNING_LEVEL DUNNING_LEVEL
, CPS.AMOUNT_ACCRUE AMOUNT_ACCRUE
, DL.LETTER_NAME LETTER_NAME
, DLS.NAME NAME
, DLS.DUNNING_TYPE DUNNING_TYPE
, DLS.DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID
, COR.CORRESPONDENCE_ID CORRESPONDENCE_ID
, DECODE (SP.ACCRUE_INTEREST
, 'Y'
, CPS.AMOUNT_ACCRUE
, 'N'
, CPS.AMOUNT_UNACCRUE ) INTEREST_AMT
, COR.ORG_ID ORG_ID
, COR.ROWID ROW_ID
FROM AR_CORRESPONDENCES COR
, AR_DUNNING_LETTER_SETS DLS
, AR_DUNNING_LETTERS DL
, AR_CORRESPONDENCE_PAY_SCHED CPS
, AR_SYSTEM_PARAMETERS SP
, AR_PAYMENT_SCHEDULES PS
WHERE DLS.DUNNING_LETTER_SET_ID = COR.REFERENCE1
AND DL.DUNNING_LETTER_ID = COR.REFERENCE2
AND CPS.CORRESPONDENCE_ID = COR.CORRESPONDENCE_ID
AND PS.PAYMENT_SCHEDULE_ID = CPS.PAYMENT_SCHEDULE_ID
AND COR.PRELIMINARY_FLAG = 'N'