QUIERY TO FIND APPLICATION SHORT NAME AND RESPONSIBILITY KEY

SELECT fr.responsibility_key,fa.application_short_name

  FROM fnd_responsibility fr, fnd_responsibility_tl frt, fnd_application fa

 WHERE fr.responsibility_id = frt.responsibility_id

   AND fa.application_id = fr.application_id

   AND frt.responsibility_name = 'Purchasing, Vision Operations (USA)'