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.JTF_MENU_PUB dependencies on FND_MENUS

Line 28: from fnd_menu_entries_vl a, fnd_menus b

24: );
25:
26: cursor get_app_menu(p_menuid number) is
27: select a.sub_menu_id , prompt,description,function_id,menu_name
28: from fnd_menu_entries_vl a, fnd_menus b
29: where a.menu_id = p_menuid and b.menu_id(+) = a.sub_menu_id ;
30:
31: cursor get_function_c(p_functionid number) is
32: select web_host_name, web_agent_name,web_html_call,

Line 198: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r

194: cnt number := 0;
195: l_resp_name varchar2(256);
196: cursor root_menu(pp_respid number, pp_appid number, pp_lang varchar2) is
197: select b.menu_id, b.menu_name , t.user_menu_name, t.description
198: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
199: where b.menu_id = t.menu_id and
200: t.language = pp_lang and
201: b.menu_id = r.menu_id and
202: r.responsibility_id = pp_respid and

Line 260: --from fnd_menus_vl a , fnd_responsibility b

256: -- here's the old cursor definition, which assumed userenv('lang')
257: -- was set correctly:
258: -- cursor root_menu(pp_respid number, pp_appid number) is
259: --select a.menu_id, a.menu_name , a.user_menu_name, a.description
260: --from fnd_menus_vl a , fnd_responsibility b
261: --where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
262: --and b.application_id = pp_appid;
263:
264: -- here's the new one, which assumes we use pp_lang instead

Line 267: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r

263:
264: -- here's the new one, which assumes we use pp_lang instead
265: cursor root_menu(pp_respid number, pp_appid number, pp_lang varchar2) is
266: select b.menu_id, b.menu_name , t.user_menu_name, t.description
267: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
268: where b.menu_id = t.menu_id and
269: t.language = pp_lang and
270: b.menu_id = r.menu_id and
271: r.responsibility_id = pp_respid and

Line 332: from fnd_menus_vl a , fnd_responsibility b

328: cnt number := 0;
329: l_resp_name varchar2(256);
330: cursor root_menu(pp_respid number, pp_appid number) is
331: select a.menu_id, a.menu_name , a.user_menu_name, a.description
332: from fnd_menus_vl a , fnd_responsibility b
333: where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
334: and b.application_id = pp_appid;
335:
336: --cursor get_responsibilities(pp_menuid number) is

Line 394: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm

390: rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,
391: B.SUB_MENU_ID, B.FUNCTION_ID,
392: B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN,
393: B.CREATION_DATE , B.CREATED_BY , T.PROMPT, T.DESCRIPTION, fm.menu_name
394: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm
395: WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
396: and b.menu_id = p_mid and fm.menu_id(+) = b.sub_menu_id
397: AND T.LANGUAGE = pp_lang
398: order by b.entry_sequence;

Line 450: -- from fnd_menu_entries_vl a, fnd_menus b

446: cursor get_sub_menus(p_mid number, pp_lang varchar2) is
447: -- here's the query, before we parameterized it by language
448: -- select sub_menu_id, prompt, description, function_id, menu_name,
449: -- rowidtochar(a.rowid) menu_entry_rowid
450: -- from fnd_menu_entries_vl a, fnd_menus b
451: -- where a.menu_id = p_mid and b.menu_id(+) = a.sub_menu_id
452: -- order by entry_sequence;
453: SELECT
454: rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,

Line 458: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm

454: rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,
455: B.SUB_MENU_ID, B.FUNCTION_ID,
456: B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN,
457: B.CREATION_DATE , B.CREATED_BY , T.PROMPT, T.DESCRIPTION, fm.menu_name
458: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm
459: WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
460: and b.menu_id = p_mid and fm.menu_id(+) = b.sub_menu_id
461: AND T.LANGUAGE = pp_lang
462: order by b.entry_sequence;

Line 510: from fnd_menu_entries_vl a, fnd_menus b

506:
507: cursor get_sub_menus(p_mid number) is
508: --select sub_menu_id, prompt, description, function_id, menu_name, rowidtochar(a.rowid) menu_entry_rowid
509: select sub_menu_id, prompt, description, function_id, menu_name, rowidtochar(a.row_id) menu_entry_rowid
510: from fnd_menu_entries_vl a, fnd_menus b
511: where a.menu_id = p_mid and b.menu_id(+) = a.sub_menu_id
512: order by entry_sequence;
513:
514: BEGIN

Line 711: -- from fnd_menus_vl

707: l_prompt_name varchar2(80);
708: -- here's the query, before we parameterized it by language
709: -- cursor get_root_name(p_menu_id number) is
710: -- select user_menu_name
711: -- from fnd_menus_vl
712: -- where menu_id = p_menu_id;
713: cursor get_root_name(p_menu_id number, pp_lang varchar2) is
714: SELECT T.USER_MENU_NAME
715: FROM FND_MENUS_TL T, FND_MENUS B

Line 715: FROM FND_MENUS_TL T, FND_MENUS B

711: -- from fnd_menus_vl
712: -- where menu_id = p_menu_id;
713: cursor get_root_name(p_menu_id number, pp_lang varchar2) is
714: SELECT T.USER_MENU_NAME
715: FROM FND_MENUS_TL T, FND_MENUS B
716: WHERE B.MENU_ID = T.MENU_ID AND T.LANGUAGE = pp_lang and
717: b.menu_id = p_menu_id;
718: begin
719: open get_root_name(p_menu_id, t_lang);

Line 734: from fnd_menus_vl

730: l_prompt_name varchar2(80);
731:
732: cursor get_root_name(p_menu_id number) is
733: select user_menu_name
734: from fnd_menus_vl
735: where menu_id = p_menu_id;
736:
737: BEGIN
738: open get_root_name(p_menu_id);