Oracle Apps – Application Short Names

select   fa.application_id "Application ID",
            fat.application_name "Application Name",
            fa.application_short_name "Application Short Name",
            fa.basepath "Basepath"
   from fnd_application fa, fnd_application_tl fat
 where fa.application_id  = fat.application_id
     and fat.language         = userenv ('LANG')
order by fat.application_name;

Comments

Post a Comment

Popular posts from this blog

Indian Finance Year

create or replace function fin_year(date1 date) return varchar2 as fin_yr varchar2(200) :=null; begin   if (to_char(date1,'MM')<=3)    then fin_yr :=' APR '||to_char(to_char(date1,'YYYY')-1)||' - '||' MAR '||to_char(to_char(date1,'YYYY'));   else         fin_yr := ' APR '||to_char(to_char(date1,'YYYY'))||' - '||' MAR '||to_char(to_char(date1,'YYYY')+1);     end if;   return(fin_yr); end fin_year; / select fin_year(sysdate) from dual;
Read more

FND_GLOBAL.APPS_INITIALIZE for initializing session in Oracle Apps R12

 select organization_id   from hr_operating_units where name = :p_name; exec mo_global.set_policy_context('S',:p_org_id); select u.user_id user_id, r.responsibility_id resp_id,        r.application_id resp_appl_id, r.responsibility_key,        sg.security_group_id security_group_id   from fnd_user u,        fnd_user_resp_groups ur,        fnd_responsibility r,        fnd_security_groups sg  where u.user_name          = :p_user_name    and r.responsibility_key = :p_responsibility_name    and ur.responsibility_id = r.responsibility_id    and ur.user_id           = u.user_id    and ur.security_group_id = sg.security_group_id; begin   fnd_global.apps_initialize     (  user_id                ...
Read more