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_WORK_FLOW dependencies on LNS_LOAN_HEADERS_ALL_VL

Line 596: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt

592: || ' ' || lh.loan_currency loan_undisbursed_amount
593: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
594: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
595: ,lh.last_updated_by current_user_id
596: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt
597: WHERE lh.loan_class_code = le.loan_class_code
598: AND le.enabled_flag = 'Y'
599: AND le.event_name = p_event_name
600: AND lt.loan_type_id = lh.loan_type_id

Line 1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,

1034: ,LNS_FINANCIALS.getActiveRate(llh.LOAN_ID) interest_rate
1035: ,llkp.meaning loan_purpose
1036: ,llh.org_id
1037: ,lprod.loan_product_name
1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,
1039: jtf_rs_resource_extns res, fnd_user fnd,
1040: lns_payments_summary_v ps,
1041: lns_lookups llktt,
1042: lns_lookups llklc,