Value Set Query

select  ffvv.flex_value
  from  fnd_flex_values_vl ffvv,fnd_flex_value_sets ffvs
 where  ffvs.flex_value_set_name = :p_value_set_name
   and  ffvv.flex_value_set_id   = ffvs.flex_value_set_id
   and  ffvv.enabled_flag        = 'Y'
 order by 1

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