LNS Views (23)

LNS - Loans — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
LNS_AEL_GL_V	This view contains accounting GL info about loans invoices
LNS_AMORTIZATION_SCHEDULES_V	This view contains billing and payment history information for every loan in the system
LNS_AM_SCHEDS_DTL_V	Amortization Schedule Details View
LNS_AM_SCHEDS_V	Amortization Schedules View
LNS_AR_AMORTIZATIONS_V	This view contains basic billing and payment information for every loan in the system.
LNS_LOAN_DETAILS_EXT_V	Loans Accounting Lines Extract
LNS_LOAN_HEADERS_EXT_V	Loans Accounting Header Extract
LNS_LOAN_INFO	Loans Accounting Events Informational View
LNS_LOAN_PARTICIPANTS_V	View for Loan Participants Information
LNS_LOAN_PAYMENT_SUMMARY_V	This view contains basic billing and payment summary information for every loan in the system. This is public view for other applications.
LNS_LOAN_PRODUCTS_ALL_VL
LNS_LOAN_PRODUCTS_VL
LNS_LOAN_SUMMARY_V	View for Loan Summary Information
LNS_LOOKUPS	LNS_LOOKUPS is a view which has information about the Lookup values that you
LNS_OPEN_RECEIVABLES_V	Open Receivables View
LNS_PAYMENTS_SUMMARY_V	This view contains billing and payment summary information for every loan in the system
LNS_PAY_SUM_OVERDUE_V	Overdue Payment Summary View
LNS_PAY_SUM_V	Payment Summary View
LNS_PAY_SUM_YEARLY_V	YTD and Last Year Payment Summary View
LNS_RECEIVABLE_ACTIVITIES_V	This view contains payment activities for all installments of all loans in the system
LNS_REC_ACT_ADJ_V	Receipts and Creadit Memo Receivable Activities View
LNS_REC_ACT_CASH_CM_V	Receipts and Creadit Memo Receivable Activities View
LNS_SL_GL_V2	This view is for internal use only.