Reg AOL

[vamsioracle]

hi




I have few doubts in AOL. When we create a new form and attach it as a function to a menu in Apps, where are the details stored

for example, menu info is stored in fnd_menu_entrie s

how can we know where it is a custom menu or standard(IIy for functions and other objects)

Where can i get Schema, users, Privileges info from

Please help me

thanks in advance

[amitpatel66]

Forms - FND_FORM
Form/Functions - FND_FORM_FUNCTI ONS
Menus - FND_MENUS,FND_M ENU_ENTRIES
Responsibility - FND_RESPONSIBIL ITY_VL


The below query would give you fair idea:

[code=oracle]

SELECT ff.user_form_na me,
fff.function_na me,
fm.menu_name,
frv.responsibil ity_name
FROM
fnd_form ff,
fnd_form_functi ons fff,
fnd_menu_entrie s fme,
fnd_responsibil ity_vl frv,
fnd_menus fm
WHERE
ff.form_id = fff.form_id
AND fff.function_id = fme.function_id
AND fme.menu_id = frv.menu_id
AND fme.menu_id = fm.menu_id

[/code]

[vamsioracle]

Thank u very much

Please tell me also how to get users--their privileges
and how to differentiate , if a form--function -- menu is custom or standard
and directory structure related tables

thanks