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_FINANCIALS dependencies on LNS_REC_ACT_CASH_CM_V

Line 6915: from LNS_REC_ACT_CASH_CM_V

6911: -- this cursor is to get the last activity date on the loan
6912: -- payoff processing will use this date
6913: cursor c_last_loan_activity(p_loan_id number) is
6914: select max(activity_date)
6915: from LNS_REC_ACT_CASH_CM_V
6916: where activity_code = 'PMT'
6917: and loan_id = p_loan_id;
6918:
6919: -- begin fix for bug 6724561

Line 9599: from LNS_REC_ACT_CASH_CM_V rav

9595: union all
9596: select trunc(activity_date) activity_date,
9597: sum(activity_amount) activity_amount,
9598: LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID, activity_date) --min(balance_by_activity_date) ending_balance
9599: from LNS_REC_ACT_CASH_CM_V rav
9600: where rav.loan_id = p_loan_id and
9601: line_type_code = 'PRIN' and
9602: (activity_code in ('PMT', 'ADJ') or (activity_code = 'CM' and activity_number like 'NET%'))
9603: group by activity_date