VIEW: APPS.AR_INTEREST_LINES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)