Product: | AR - Receivables |
---|---|
Description: | Late Charge line preview work bench |
Implementation/DBA Data: | APPS.AR_INTEREST_LINES_V |
SELECT L.INTEREST_LINE_ID
, L.INTEREST_HEADER_ID
, L.PAYMENT_SCHEDULE_ID
, L.OUTSTANDING_AMOUNT
, L.DAYS_OVERDUE_LATE
, L.DAYS_OF_INTEREST
, L.INTEREST_CHARGED
, L.PAYMENT_DATE
, L.FINANCE_CHARGE_CHARGED
, L.AMOUNT_DUE_ORIGINAL
, L.AMOUNT_DUE_REMAINING
, L.ORIGINAL_TRX_ID
, L.LAST_CHARGE_DATE
, L.DUE_DATE
, L.ACTUAL_DATE_CLOSED
, L.INTEREST_RATE
, L.RATE_START_DATE
, L.RATE_END_DATE
, L.SCHEDULE_DAYS_FROM
, L.SCHEDULE_DAYS_TO
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.CREATED_BY
, L.CREATION_DATE
, L.ORG_ID
, L.PROCESS_MESSAGE
, L.PROCESS_STATUS
, L.ORIGINAL_TRX_CLASS
, L.TYPE
, L.DAILY_INTEREST_CHARGE
, L.RECEIVABLES_TRX_ID
, L.OBJECT_VERSION_NUMBER
, CT.TRX_NUMBER
, CT.DOC_SEQUENCE_VALUE
, RT.NAME
FROM AR_INTEREST_LINES L
, AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
, AR_RECEIVABLES_TRX RT
WHERE L.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID (+)
AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+)
AND L.RECEIVABLES_TRX_ID = RT.RECEIVABLES_TRX_ID(+)