DBA Data[Home] [Help]

APPS.JTF_MENU_PUB dependencies on FND_MENU_ENTRIES_TL

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 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 664: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B

660: -- from fnd_menu_entries_vl
661: -- where rowid = chartorowid(p_row_id);
662: cursor get_menu_name(p_row_id varchar2, pp_lang varchar2) is
663: SELECT T.PROMPT
664: FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B
665: WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
666: AND T.LANGUAGE = pp_lang and
667: b.rowid = chartorowid(p_row_id);
668: begin