Help with the SQL to find the responsibility and user details assigned to particular function

Hello Gurus,

   Can you please help me to correct the below SQL query. This query is to find responsibility details by the functions (by function_id) and which users are assigned to these responsibilities.

here is the sql i am using...:

select distinct

fff.function_id,

fff.function_name,

                 v.PROMPT, 

                 v.DESCRIPTION Prompt_Discription,

                 ff.form_id,

               --  ff.application_id,

                ff.form_name,

                fm.menu_id,

                fm.menu_name,

                frv.RESPONSIBILITY_ID,

                 frv.responsibility_name,

                 frv.END_DATE,

                fu.user_name,

                fu.email_address,

                frv.END_DATE responsibility_end_date

  FROM apps.FND_FORM_FUNCTIONS          fff,

       apps.fnd_form                    ff,