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_EVENTS

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 989: FROM lns_events le, lns_event_actions lea

985: , priority_num
986: , nvl(active_for_num,0)*24*60 -- This has to be converted into minutes
987: , delivery_method
988: , event_action_id
989: FROM lns_events le, lns_event_actions lea
990: WHERE le.event_name = p_event_name
991: AND le.enabled_flag = 'Y'
992: AND le.loan_class_code = p_loan_class_code
993: AND lea.event_id = le.event_id

Line 1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;

1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1438: l_current_user_name fnd_user.user_name%TYPE;

Line 2459: from lns_event_actions ea, lns_events ev,

2455: , LNS_UTILITY_PUB.CREATED_BY
2456: , sysdate
2457: , LNS_UTILITY_PUB.LAST_UPDATED_BY
2458: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2459: from lns_event_actions ea, lns_events ev,
2460: (select loan_class_code, loan_type_id
2461: from lns_loan_types_vl
2462: minus
2463: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id

Line 2464: from lns_events ev, lns_event_actions ea

2460: (select loan_class_code, loan_type_id
2461: from lns_loan_types_vl
2462: minus
2463: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id
2464: from lns_events ev, lns_event_actions ea
2465: where ea.event_id = ev.event_id
2466: and ea.event_action_name = 'NOTIFICATION') missingvalues
2467: where ev.loan_class_code = missingvalues.loan_class_code
2468: and ea.event_id = ev.event_id