Posts

Showing posts from June, 2016

Query to get profile options details from backend

Image
SELECT   fpov.profile_option_name ,   fpov.user_profile_option_name,   DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002', 'APP', '10003',   'RESP', '10005', 'SERVER', '10006', 'ORG', '10004', 'USER', 'NA' )   profile_Level,   DECODE (TO_CHAR (fpo.level_id), '10001', '', '10002',   fa.application_short_name, '10003', fr.responsibility_key, '10005',   fn.node_name, '10006', hou.NAME, '10004', fu.user_name, 'NA' ) Context_value,   fpo.profile_option_value value,   fr.RESPONSIBILITY_KEY,   fr.RESPONSIBILITY_NAME FROM   apps.fnd_profile_options_vl fpov,   apps.fnd_profile_option_values fpo,   apps.fnd_user fu,   apps.fnd_application fa,   apps.fnd_responsibility_vl fr,   apps.fnd_nodes fn,   apps.hr_operating_units hou WHERE   1                         = 1 AND fpo.application_id      = fpov.appl...
Post a Comment
Read more

Query for responsibility list attached to user in oracle apps

SELECT fu.user_name, frt.responsibility_name, furg.start_date, furg.end_date, fr.responsibility_key, fa.application_short_name FROM apps.fnd_user_resp_groups_direct furg, applsys.fnd_user fu, applsys.fnd_responsibility_tl frt, applsys.fnd_responsibility fr, applsys.fnd_application_tl fat, applsys.fnd_application fa WHERE 1 = 1 AND furg.user_id = fu.user_id AND furg.responsibility_id = frt.responsibility_id AND fr.responsibility_id = frt.responsibility_id AND fa.application_id = fat.application_id AND fr.application_id = fat.application_id AND frt.language = userenv('LANG') AND upper(fu.user_name) = upper(&P_USER_NAME) AND SYSDATE BETWEEN nvl(furg.start_date,SYSDATE) AND nvl(furg.end_date,SYSDATE + 1) ORDER BY 1,2;
Post a Comment
Read more

JQuery With PHP

Image
how to add  jQuery  to Your Web Pages ?: There are several ways to start using jQuery on your web site. You can: (1)Download the jQuery library from jQuery.com (2)Include jQuery from a CDN, like Google Downloading jQuery : There are two versions of jQuery available for downloading: ·           Production version - this is for your live website because it has been minified and compressed ·           Development version - this is for testing and development (uncompressed  and readable code) Both versions can be downloaded from jQuery.com. The jQuery  library is a single JavaScript file, and you reference it with the HTML <script> tag (notice that the  <script>   tag should be inside the <head> section): <head> <script  src="jquery-1.12.2.min.js"></script> </head> Tip: Place...
Post a Comment
Read more