Query to know form attached to which responsibility
SELECT
d.responsibility_name,
bb.FORM_NAME fmx_name,
c.FUNCTION_NAME function_name
FROM
fnd_menu_entries a ,
fnd_menu_entries_vl b ,
fnd_form_functions c ,
fnd_responsibility_vl d,
fnd_form bb
WHERE
a.menu_id = b.menu_id
AND a.function_id = b.function_id
AND b.function_id = c.function_id
AND a.menu_id = d.menu_id
and bb.FORM_ID =c.FORM_ID
AND c.function_name = :function_name
and bb.FORM_NAME=:fmx_name
No comments:
Post a Comment