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.IEM_SUGG_DOC_RANK_PVT dependencies on IEM_KB_RESULTS

Line 26: select * from (select document_id,document_title,kb_repository_name from iem_kb_results

22: l_class_id number;
23: l_rank number;
24: l_sugg_id number;
25: cursor c_top5 is
26: select * from (select document_id,document_title,kb_repository_name from iem_kb_results
27: where message_id=p_message_id and classification_id=l_class_id order by to_number(score) desc)
28: where rownum<=5;
29: cursor c_rest_doc is
30: select document_id,document_title,kb_repository_name from iem_kb_results

Line 30: select document_id,document_title,kb_repository_name from iem_kb_results

26: select * from (select document_id,document_title,kb_repository_name from iem_kb_results
27: where message_id=p_message_id and classification_id=l_class_id order by to_number(score) desc)
28: where rownum<=5;
29: cursor c_rest_doc is
30: select document_id,document_title,kb_repository_name from iem_kb_results
31: where message_id=p_message_id and
32: (document_id,document_title,kb_repository_name) not in
33: (
34: select * from (select document_id,document_title,kb_repository_name from iem_kb_results

Line 34: select * from (select document_id,document_title,kb_repository_name from iem_kb_results

30: select document_id,document_title,kb_repository_name from iem_kb_results
31: where message_id=p_message_id and
32: (document_id,document_title,kb_repository_name) not in
33: (
34: select * from (select document_id,document_title,kb_repository_name from iem_kb_results
35: where message_id=p_message_id and classification_id=l_class_id order by to_number(score) desc)
36: where rownum<=5);
37:
38: BEGIN