Reports2017-11-18T12:27:27+00:00

FND Lookup Values

Description
Categories: Application, Enginatics
Lookup types and values, for example to find a lookup type for a particular lookup code value or meaning.

select
fav.application_name view_application,
flvv.lookup_type,
fltv.description type_description,
flvv.lookup_code code,
flvv.meaning,
flvv.description,
xxen_util.meaning(flvv.enabled_flag,'YES_NO',0) enabled_flag,
xxen_util.user_name(flvv.created_by) created_by,
xxen_util.client_time(flvv.creation_date) creation_date,
'xxen_util.meaning(x.'||lower(flvv.lookup_type)||','''||flvv.lookup_type||''','||flvv.view_application_id||') '||lower(flvv.lookup_type)||',' sql_text,
'select
flv.lookup_code,
flv.meaning,
flv.description
from
fnd_lookup_values flv
where
flv.lookup_type(+)='''||flvv.lookup_type||''' and
flv.view_application_id(+)='||flvv.view_application_id||' and
flv.language(+)=userenv(''lang'') and
flv.security_group_id(+)=0
order by
flv.lookup_code' lookup_values
from
fnd_application_vl fav0,
fnd_application_vl fav,
fnd_lookup_types_vl fltv,
fnd_lookup_values_vl flvv
where
1=1 and
fav0.application_id=fltv.application_id and
fav.application_id=flvv.view_application_id and
fltv.lookup_type=flvv.lookup_type and
fltv.view_application_id=flvv.view_application_id and
flvv.security_group_id=0
order by
flvv.lookup_type,
flvv.lookup_code

Parameter Name SQL text Validation
Created By
flvv.created_by in (select fu.user_id from fnd_user fu where fu.user_name=:created_by)
LOV
Creation Date To
flvv.creation_date<:creation_date_to+1
Date
Creation Date From
flvv.creation_date>=:creation_date_from
Date
Description contains
upper(flvv.description) like '%'||upper(:description)||'%'
Meaning contains
upper(flvv.meaning) like '%'||upper(:meaning)||'%'
LOV
Code contains
upper(flvv.lookup_code) like '%'||upper(:lookup_code)||'%'
LOV
Type
flvv.lookup_type=:lookup_type
LOV