eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: JG_ZZ_INTEREST_INVOICE_LINES_V

Product:	JG - Regional Localizations
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT IIL.ROWID ROW_ID
, IIL.INTEREST_INVOICE_LINE_ID
, IIL.INTEREST_INVOICE_ID
, IIL.PAYMENT_SCHEDULE_ID
, IIL.RECEIVABLE_APPLICATION_ID
, IIL.TYPE
, IIL.DAILY_INTEREST_CHARGE
, IIL.OUTSTANDING_AMOUNT
, IIL.DAYS_OF_INTEREST
, IIL.INTEREST_CHARGED
, IIL.PAYMENT_DATE
, PS.DUE_DATE
, IIL.DAYS_OVERDUE_LATE DAYS_OVERDUE
, CT.TRX_NUMBER INVOICE_NUMBER
, IIL.ORG_ID
, IIL.LAST_UPDATED_BY
, IIL.LAST_UPDATE_DATE
, IIL.CREATION_DATE
, IIL.LAST_UPDATE_LOGIN
, IIL.CREATED_BY
, IIL.INTEREST_RATE FROM JG_ZZ_INTEREST_INVOICE_LINES IIL
, JG_ZZ_INTEREST_INVOICES II
, JG_ZZ_INTEREST_BATCHES IB
, AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
, AR_RECEIVABLE_APPLICATIONS AR
WHERE IIL.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID (+)
AND IIL.INTEREST_INVOICE_ID = II.INTEREST_INVOICE_ID
AND IB.INTEREST_BATCH_ID = II.INTEREST_BATCH_ID
AND IIL.RECEIVABLE_APPLICATION_ID = AR.RECEIVABLE_APPLICATION_ID(+)
AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+)

Columns

Name
ROW_ID
INTEREST_INVOICE_LINE_ID
INTEREST_INVOICE_ID
PAYMENT_SCHEDULE_ID
RECEIVABLE_APPLICATION_ID
TYPE
DAILY_INTEREST_CHARGE
OUTSTANDING_AMOUNT
DAYS_OF_INTEREST
INTEREST_CHARGED
PAYMENT_DATE
DUE_DATE
DAYS_OVERDUE
INVOICE_NUMBER
ORG_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATION_DATE
LAST_UPDATE_LOGIN
CREATED_BY
INTEREST_RATE