Favourites and Top Ten Lists

-- ##############################################################################
--      IPROC FAV CHARGE ACCOUNTS
-- ##############################################################################

    SELECT pfca.creation_date fav_added
         , fu.user_name
         , frt.responsibility_name
         , pfca.charge_account_id
         , gcc.concatenated_segments fav_charge_acct
      FROM applsys.fnd_user fu
      JOIN icx.por_fav_charge_accounts pfca ON fu.employee_id = pfca.employee_id
      JOIN applsys.fnd_responsibility_tl frt ON pfca.responsibility_id = frt.responsibility_id
      JOIN gl.gl_code_combinations_kfv gcc ON gcc.code_combination_id = pfca.charge_account_id
     WHERE pfca.creation_date > '01-JAN-2015'
  ORDER BY pfca.creation_date DESC;

-- ##############################################################################
--      R12 NAVIGATOR FAVORITES
-- ##############################################################################

SELECT fu.user_name
     , fu.description
     , iccme.display_sequence seq
     , iccme.prompt
     , iccme.function_type type
     , frt.responsibility_name
  FROM icx.icx_custom_menu_entries iccme
  JOIN applsys.fnd_user fu                ON iccme.user_id =           fu.user_id
  JOIN applsys.fnd_responsibility_tl frt  ON iccme.responsibility_id = frt.responsibility_id
  JOIN applsys.fnd_form_functions_tl ffft ON iccme.function_id =       ffft.function_id 
 WHERE fu.user_name = 'BOBHOPE'
ORDER BY 1,2,3;

-- ##############################################################################
--      CORE APPS TOP TEN LIST LINKED TO RESPS
-- ##############################################################################

  SELECT fu.description
       , fu.user_name
       , frt.responsibility_name resp
       , fudo.sequence seq
       , fffv.user_function_name
    FROM applsys.fnd_user_desktop_objects fudo
    JOIN applsys.fnd_user fu               ON fudo.user_id =           fu.user_id  
    JOIN applsys.fnd_responsibility_tl frt ON fudo.responsibility_id = frt.responsibility_id
    JOIN apps.fnd_form_functions_vl fffv   ON fudo.function_name =     fffv.function_name 
   WHERE fu.user_name = 'BOBHOPE'
ORDER BY 1, 2, 3, 4;

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*