create or replace view fnd_form_v as
select ff.form_name,
       ff.user_form_name,
       ff.form_id,
       fff.user_function_name,
       fff.parameters,
       fff.function_name,
       fff.function_id,
       '1' level_num,
       fme.prompt level1_prompt,
       fm.user_menu_name level1_user_menu_name,
       fm.menu_name level1_menu_name,
       fm.menu_id level1_menu_id,
       null level2_prompt,
       null level2_user_menu_name,
       null level2_menu_name,
       null level2_menu_id,
       null level3_prompt,
       null level3_user_menu_name,
       null level3_menu_name,
       null level3_menu_id,
       null level4_prompt,
       null level4_user_menu_name,
       null level4_menu_name,
       null level4_menu_id,
       fr.responsibility_name,
       fr.responsibility_key,
       fr.responsibility_id
from fnd_form_vl           ff,
       fnd_form_functions_vl fff,
       fnd_menu_entries_vl fme,
       fnd_menus_vl          fm,
       fnd_responsibility_vl fr
where fff.form_id = ff.form_id
   and fme.function_id = fff.function_id
   and fm.menu_id = fme.menu_id
   and fr.menu_id(+) = fm.menu_id
   and fme.grant_flag = 'Y'
union
select ff.form_name,
       ff.user_form_name,
       ff.form_id,
       fff.user_function_name,
       fff.parameters,
       fff.function_name,
       fff.function_id,
       '2' level_num,
       fme.prompt level1_prompt,
       fm.user_menu_name level1_user_menu_name,
       fm.menu_name level1_menu_name,
       fm.menu_id level1_menu_id,
       up11.prompt level2_prompt,
       up12.user_menu_name level2_user_menu_name,
       up12.menu_name level2_menu_name,
       up12.menu_id level2_menu_id,
       null level3_prompt,
       null level3_user_menu_name,
       null level3_menu_name,
       null level3_menu_id,
       null level4_prompt,
       null level4_user_menu_name,
       null level4_menu_name,
       null level4_menu_id,
       fr.responsibility_name,
       fr.responsibility_key,
       fr.responsibility_id
from fnd_form_vl           ff,
       fnd_form_functions_vl fff,
       fnd_menu_entries_vl fme,
       fnd_menus_vl          fm,
       fnd_menu_entries_vl   up11,
       fnd_menus_vl          up12,
       fnd_responsibility_vl fr
where fff.form_id = ff.form_id
   and fme.function_id = fff.function_id
   and fm.menu_id = fme.menu_id
   and up11.sub_menu_id = fm.menu_id
   and up12.menu_id = up11.menu_id
   and fr.menu_id(+) = up12.menu_id
   and fme.grant_flag = 'Y'
   and up11.grant_flag = 'Y'
union
select ff.form_name,
       ff.user_form_name,
       ff.form_id,
       fff.user_function_name,
       fff.parameters,
       fff.function_name,
       fff.function_id,
       '3' level_num,
       fme.prompt level1_prompt,
       fm.user_menu_name level1_user_menu_name,
       fm.menu_name level1_menu_name,
       fm.menu_id level1_menu_id,
       up11.prompt level2_prompt,
       up12.user_menu_name level2_user_menu_name,
       up12.menu_name level2_menu_name,
       up12.menu_id level2_menu_id,
       up21.prompt level3_prompt,
       up22.user_menu_name level3_user_menu_name,
       up22.menu_name level3_menu_name,
       up22.menu_id level3_menu_id,
       null level4_prompt,
       null level4_user_menu_name,
       null level4_menu_name,
       null level4_menu_id,
       fr.responsibility_name,
       fr.responsibility_key,
       fr.responsibility_id
from fnd_form_vl           ff,
       fnd_form_functions_vl fff,
       fnd_menu_entries_vl   fme,
       fnd_menus_vl          fm,
       fnd_menu_entries_vl   up11,
       fnd_menus_vl          up12,
       fnd_menu_entries_vl   up21,
       fnd_menus_vl          up22,
       fnd_responsibility_vl fr
where fff.form_id = ff.form_id
   and fme.function_id = fff.function_id
   and fm.menu_id = fme.menu_id
   and up11.sub_menu_id = fm.menu_id
   and up12.menu_id = up11.menu_id
   and up21.sub_menu_id = up12.menu_id
   and up22.menu_id = up21.menu_id
   and fr.menu_id(+) = up22.menu_id
   and fme.grant_flag = 'Y'
   and up11.grant_flag = 'Y'
   and up21.grant_flag = 'Y'
union
select ff.form_name,
       ff.user_form_name,
       ff.form_id,
       fff.user_function_name,
       fff.parameters,
       fff.function_name,
       fff.function_id,
       '4' level_num,
       fme.prompt level1_prompt,
       fm.user_menu_name level1_user_menu_name,
       fm.menu_name level1_menu_name,
       fm.menu_id level1_menu_id,
       up11.prompt level2_prompt,
       up12.user_menu_name level2_user_menu_name,
       up12.menu_name level2_menu_name,
       up12.menu_id level2_menu_id,
       up21.prompt level3_prompt,
       up22.user_menu_name level3_user_menu_name,
       up22.menu_name level3_menu_name,
       up22.menu_id level3_menu_id,
       up31.prompt level4_prompt,
       up32.user_menu_name level4_user_menu_name,
       up32.menu_name level4_menu_name,
       up32.menu_id level4_menu_id,
       fr.responsibility_name,
       fr.responsibility_key,
       fr.responsibility_id
from fnd_form_vl           ff,
       fnd_form_functions_vl fff,
       fnd_menu_entries_vl   fme,
       fnd_menus_vl          fm,
       fnd_menu_entries_vl   up11,
       fnd_menus_vl          up12,
       fnd_menu_entries_vl   up21,
       fnd_menus_vl          up22,
       fnd_menu_entries_vl   up31,
       fnd_menus_vl          up32,
       fnd_responsibility_vl fr
where fff.form_id = ff.form_id
   and fme.function_id = fff.function_id
   and fm.menu_id = fme.menu_id
   and up11.sub_menu_id = fm.menu_id
   and up12.menu_id = up11.menu_id
   and up21.sub_menu_id = up12.menu_id
   and up22.menu_id = up21.menu_id
   and up31.sub_menu_id = up22.menu_id
   and up32.menu_id = up31.menu_id
   and fr.menu_id(+) = up32.menu_id
   and fme.grant_flag = 'Y'
   and up11.grant_flag = 'Y'
   and up21.grant_flag = 'Y'
   and up31.grant_flag = 'Y';