View: AR_DUNNING_HISTORY_V

Product:	AR - Receivables
Description:	View dunning history information
Implementation/DBA Data:	APPS.AR_DUNNING_HISTORY_V

View Text

SELECT PS.PAYMENT_SCHEDULE_ID
, COR.CORRESPONDENCE_DATE
, CPS.STAGED_DUNNING_LEVEL
, DL.LETTER_NAME
, DLS.NAME
, DLS.DUNNING_TYPE
, DLS.DUNNING_LETTER_SET_ID
, COR.CORRESPONDENCE_ID
, DECODE (SP.ACCRUE_INTEREST
, 'Y'
, CPS.AMOUNT_ACCRUE
, 'N'
, CPS.AMOUNT_UNACCRUE )
, COR.ROWID
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'

Columns