[Home] [Help]
View: 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
Name |
PAYMENT_SCHEDULE_ID |
DUNNING_DATE |
DUNNING_LEVEL |
LETTER_NAME |
NAME |
DUNNING_TYPE |
DUNNING_LETTER_SET_ID |
CORRESPONDENCE_ID |
INTEREST_AMT |
ROW_ID |