VIEW: APPS.AR_DUNNING_HISTORY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'