The following lines contain the word 'select', 'insert', 'update' or 'delete':
select a.sub_menu_id , prompt,description,function_id,menu_name
from fnd_menu_entries_vl a, fnd_menus b
where a.menu_id = p_menuid and b.menu_id(+) = a.sub_menu_id ;
select web_host_name, web_agent_name,web_html_call,
web_encrypt_parameters, web_secured,
web_icon,function_id, function_name,application_id, creation_date,type,
user_function_name, description
from fnd_form_functions_vl
where function_id = p_functionid;
select rule_type from fnd_resp_functions where
application_id = pp_appid and responsibility_id = pp_respid and
action_id = pp_action_id and rule_type = pp_rule_type;
select userenv('lang') into t_lang from dual;
select b.menu_id, b.menu_name , t.user_menu_name, t.description
from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
where b.menu_id = t.menu_id and
t.language = pp_lang and
b.menu_id = r.menu_id and
r.responsibility_id = pp_respid and
r.application_id = pp_appid;
select userenv('lang') into t_lang from dual;
select t.responsibility_name into l_resp_name
from fnd_responsibility_tl t, fnd_responsibility b
where b.responsibility_id = t.responsibility_id and
b.application_id = t.application_id and
t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;
select b.menu_id, b.menu_name , t.user_menu_name, t.description
from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
where b.menu_id = t.menu_id and
t.language = pp_lang and
b.menu_id = r.menu_id and
r.responsibility_id = pp_respid and
r.application_id = pp_appid;
select userenv('lang') into t_lang from dual;
select t.responsibility_name into l_resp_name
from fnd_responsibility_tl t, fnd_responsibility b
where b.responsibility_id = t.responsibility_id and
b.application_id = t.application_id and
t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;
select a.menu_id, a.menu_name , a.user_menu_name, a.description
from fnd_menus_vl a , fnd_responsibility b
where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
and b.application_id = pp_appid;
select a.responsibility_name into l_resp_name
from fnd_responsibility_vl a
where a.responsibility_id = p_respid and a.application_id = p_appid;
SELECT
rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,
B.SUB_MENU_ID, B.FUNCTION_ID,
B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN,
B.CREATION_DATE , B.CREATED_BY , T.PROMPT, T.DESCRIPTION, fm.menu_name
FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm
WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
and b.menu_id = p_mid and fm.menu_id(+) = b.sub_menu_id
AND T.LANGUAGE = pp_lang
order by b.entry_sequence;
select userenv('lang') into t_lang from dual;
SELECT
rowidtochar(B.ROWID) menu_entry_rowid, B.MENU_ID, B.ENTRY_SEQUENCE,
B.SUB_MENU_ID, B.FUNCTION_ID,
B.GRANT_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN,
B.CREATION_DATE , B.CREATED_BY , T.PROMPT, T.DESCRIPTION, fm.menu_name
FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B, fnd_menus fm
WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
and b.menu_id = p_mid and fm.menu_id(+) = b.sub_menu_id
AND T.LANGUAGE = pp_lang
order by b.entry_sequence;
select userenv('lang') into t_lang from dual;
select sub_menu_id, prompt, description, function_id, menu_name, rowidtochar(a.row_id) menu_entry_rowid
from fnd_menu_entries_vl a, fnd_menus b
where a.menu_id = p_mid and b.menu_id(+) = a.sub_menu_id
order by entry_sequence;
select sub_menu_id, prompt, description, function_id, '' menu_name, rowidtochar(row_id) menu_entry_rowid
from fnd_menu_entries_vl
where menu_id = p_mid
order by entry_sequence;
SELECT
T.USER_FUNCTION_NAME
FROM FND_FORM_FUNCTIONS_TL T, FND_FORM_FUNCTIONS B
WHERE B.FUNCTION_ID = T.FUNCTION_ID AND T.LANGUAGE = pp_lang and
b.function_id = p_func_id;
select userenv('lang') into t_lang from dual;
select user_function_name
from fnd_form_functions_vl
where function_id = p_func_id;
SELECT T.PROMPT
FROM FND_MENU_ENTRIES_TL T, FND_MENU_ENTRIES B
WHERE B.MENU_ID = T.MENU_ID AND B.ENTRY_SEQUENCE = T.ENTRY_SEQUENCE
AND T.LANGUAGE = pp_lang and
b.rowid = chartorowid(p_row_id);
select userenv('lang') into t_lang from dual;
select prompt
from fnd_menu_entries_vl
--where rowid = chartorowid(p_row_id);
SELECT T.USER_MENU_NAME
FROM FND_MENUS_TL T, FND_MENUS B
WHERE B.MENU_ID = T.MENU_ID AND T.LANGUAGE = pp_lang and
b.menu_id = p_menu_id;
select user_menu_name
from fnd_menus_vl
where menu_id = p_menu_id;