Query to Find Form Responsibility in Oracle E-Business Suite (EBS)

query-to-find-form-responsibility-in-oracle-e-business-suite-ebs

Query 1:

SELECT function_id,USER_FUNCTION_NAME, FUNCTION_NAME, form_name

FROM fnd_form_functions_vl fff, fnd_form ff

WHERE fff.form_id = ff.form_id

and form_name=’OEXOEORD’

Query 2:

SELECT responsibility_name, menu_structure.PATH navigation

FROM (           SELECT LEVEL padding,

menu_id,

RTRIM (reverse (SYS_CONNECT_BY_PATH (reverse (prompt), ‘>’)),

‘>’)

PATH,

(SELECT menu_name

FROM fnd_menus fm

WHERE fm.menu_id = fme.menu_id)

menu_name,

entry_sequence,

sub_menu_id,

(SELECT menu_name

FROM fnd_menus fm

WHERE fm.menu_id = fme.sub_menu_id)

submenu_name,

function_id

FROM fnd_menu_entries_vl fme

CONNECT BY sub_menu_id = PRIOR menu_id

START WITH function_id = :function_id

ORDER SIBLINGS BY entry_sequence) menu_structure,

fnd_responsibility_vl fr

WHERE menu_structure.menu_id = fr.menu_id

order by 1;