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_entries

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_FUNCTIONS
Menus - FND_MENUS,FND_MENU_ENTRIES
Responsibility - FND_RESPONSIBILITY_VL


The below query would give you fair idea:

 
SELECT ff.user_form_name,
       fff.function_name,
       fm.menu_name,
       frv.responsibility_name
FROM
       fnd_form ff,
       fnd_form_functions fff,
       fnd_menu_entries fme,
       fnd_responsibility_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              
 
 

[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