Thursday, December 6, 2012

Oracle Apps: Query to fetch Responsibility associated with Function

SELECT fr.RESPONSIBILITY_NAME
  FROM fnd_responsibility_vl fr,
       fnd_menus fm,
       fnd_compiled_menu_functions fmf,
       fnd_form_functions_vl ff
 WHERE fr.menu_id = fm.menu_id
   AND ff.function_id = fmf.function_id
   AND fmf.menu_id = fm.menu_id
   AND ff.user_function_name = :function_name
   AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
   order by responsibility_name



oracleapps

4 comments:

Unknown said...

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

Susan said...

Eminem is an American rapper and one of the most successful artists in hip-hop. As of 2020, Eminem net worth is now estimated to be $230 million.

Anonymous said...

As we talked about, reviews and testimonials can be bought at relatively cheap costs whereas negative reviews can be moderated or deleted. One of the important thing} features of any popular crypto playing website is its provably honest mechanism. The encryption on these web sites ensures that the house can by no means cheat you, and that you'll at all times have a good sport. Preferences can differ, and due to this 1xbet korea fact want to} examine your favorite kinds of video games are available.