select
fav.application_name view_application,
flv.lookup_type,
fltv.description type_description,
flv.lookup_code code,
flv.language,
flv.source_lang source_language,
flv.meaning,
flv.description,
flv.tag,
xxen_util.meaning(flv.enabled_flag,'YES_NO',0) enabled_flag,
flv.start_date_active,
flv.end_date_active,
xxen_util.user_name(flv.created_by) created_by,
xxen_util.client_time(flv.creation_date) creation_date,
xxen_util.user_name(flv.last_updated_by) last_updated_by,
xxen_util.client_time(flv.last_update_date) last_update_date,
'xxen_util.meaning(x.'||lower(flv.lookup_type)||','''||flv.lookup_type||''','||flv.view_application_id||') '||lower(flv.lookup_type)||',' sql_text,
'select
flvv.lookup_code,
flvv.meaning,
flvv.description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type(+)='''||flv.lookup_type||''' and
flvv.view_application_id(+)='||flv.view_application_id||' and
flvv.security_group_id(+)=0
order by
flvv.lookup_code' lookup_values
from
fnd_application_vl fav0,
fnd_application_vl fav,
fnd_lookup_types_vl fltv,
fnd_lookup_values flv,
fnd_languages fl
where
1=1 and
fav0.application_id=fltv.application_id and
fav.application_id=flv.view_application_id and
fltv.lookup_type=flv.lookup_type and
fltv.view_application_id=flv.view_application_id and
flv.security_group_id=0 and
flv.language=fl.language_code
order by
flv.lookup_type,
flv.lookup_code,
fl.installed_flag,
flv.language |