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.

APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 314: lns_loan_headers_all head

310: select
311: nvl(count(head.loan_id), 0)
312: from
313: lns_participants par,
314: lns_loan_headers_all head
315: where
316: par.hz_party_id = P_PARTY_ID and
317: par.loan_id = head.loan_id and
318: par.loan_participant_type in ('PRIMARY_BORROWER', 'COBORROWER', 'GUARANTOR') and

Line 329: lns_loan_headers_all head

325: nvl(sum(decode(head.LOAN_CURRENCY, P_CURRENCY, head.REQUESTED_AMOUNT + head.ADD_REQUESTED_AMOUNT, ((head.REQUESTED_AMOUNT+ head.ADD_REQUESTED_AMOUNT)*head.EXCHANGE_RATE))), 0),
326: nvl(sum(decode(head.LOAN_CURRENCY, P_CURRENCY, head.FUNDED_AMOUNT, (head.FUNDED_AMOUNT*head.EXCHANGE_RATE))), 0)
327: from
328: lns_participants par,
329: lns_loan_headers_all head
330: where
331: par.hz_party_id = P_PARTY_ID and
332: par.loan_id = head.loan_id and
333: par.loan_participant_type in ('PRIMARY_BORROWER', 'COBORROWER', 'GUARANTOR') and

Line 348: lns_loan_headers_ALL loan,

344: CURSOR amount_ytd_cur(P_PARTY_ID number, P_LINE_TYPE VARCHAR2, P_TIME_FLAG VARCHAR2, P_ORG_ID number) IS
345: select
346: nvl(sum(rec.ACCTD_AMOUNT_APPLIED_TO), 0)
347: from
348: lns_loan_headers_ALL loan,
349: LNS_AMORTIZATION_SCHEDS am,
350: ar_receivable_applications_ALL rec,
351: lns_participants par
352: where

Line 976: lns_loan_headers_all head

972: party.party_name
973: from
974: lns_participants par,
975: hz_parties party,
976: lns_loan_headers_all head
977: where
978: party.party_id = nvl(P_BORROWER_ID, party.party_id) and
979: party.party_id = par.hz_party_id and
980: par.loan_id = head.loan_id and