Oracle Loans LNS EBS 11.5.10.2

 

Experts,

I would like to know how does GL identify transactions originating from Loans. I am having some difficulties understanding how to pull loan repayment transactions from Gl_je_lines; I understand repayments would have been done through receivables when we receive from customers for principal payment and interest payment but how can I find out from gl_je_lines if a transaction was a loan repayment or interest payment by customer.

Select DISTINCT llh.loan_number, llh.Initial_loan_balance, PSV.PRINCIPAL_PAID_TODATE from apps.lns_payments_summary_v psv,

Select DISTINCT llh.loan_number, llh.Initial_loan_balance