FND Forms Personalizations

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Forms personalizations and actions
Run FND Forms Personalizations and other Oracle EBS reports with Blitz Report™ on our demo environment
select
fav.application_name,
decode(ffcr.rule_type,'A','Function','F','Form',ffcr.rule_type) level_,
decode(ffcr.enabled,'Y','Y') enabled,
ffcr.form_name,
ffv.user_form_name,
decode(ffcr.rule_type,'A',ffcr.function_name) function_name,
decode(ffcr.rule_type,'A',fffv.user_function_name) user_function_name,
ffcr.sequence,
ffcr.description,
ffcr.trigger_event,
ffcr.trigger_object,
ffcr.condition,
decode(ffcr.fire_in_enter_query,'Y','Both','N','Not in Enter-Query Mode','O','Only in Enter-Query Mode') processing_mode,
xxen_util.user_name(nvl(ffca.last_updated_by,ffcr.last_updated_by)) last_updated_by,
xxen_util.client_time(nvl(ffca.last_update_date,ffcr.last_update_date)) last_update_date,
&context_columns
ffca.sequence action_sequence,
decode(ffca.action_type,'P','Property','M','Message','B','Builtin','S','Menu') action_type,
ffca.summary action_desc,
decode(ffca.language,'*','All',flv.description) language,
decode(ffca.enabled,'Y','Y') action_enabled,
decode(ffca.action_type,'P',decode(ffca.object_type,'VAR','Local Variable','LOV','LOV','GLOBAL','Global Variable','TAB','Tab Page',initcap(ffca.object_type))) property_object_type,
decode(ffca.action_type,'P',ffca.target_object) property_target_object,
decode(ffca.action_type,'P',ffcpl.property_name) property_name,
decode(ffca.action_type,'P',decode(ffcpl.argument_type,
'B',decode(ffca.property_value,'4','True','5','False'),
'L',(select ffcpv.property_value from fnd_form_custom_prop_values ffcpv where ffcpl.property_name=ffcpv.property_name and ffca.property_value=ffcpv.property_id),
ffca.property_value)
) property_value,
--decode(ffcpl.argument_type,'B','Boolean','C','Character','N','Number','L','LOV','T','Block','I','Item') argument_type
decode(ffca.action_type,'M',decode(ffca.message_type,'S','Show','H','Hint','E','Error','D','Debug','W','Warn')) message_type,
decode(ffca.action_type,'M',ffca.message_text) message_text,
decode(ffca.action_type,'B',decode(ffca.builtin_type,
'C','Launch SRS Form',
'E','Launch a Function',
'U','Launch a URL',
'D','DO_KEY',
'P','Execute a Procedure',
'G','GO_ITEM',
'B','GO_BLOCK',
'F','FORMS_DDL',
'R','RAISE FORM_TRIGGER_FAILURE',
'T','EXECUTE_TRIGGER',
'S','SYNCHRONIZE',
'L','Call Custom Library',
'Q','Create Record Group from Query',
'X','Set Profile Value in Cache'
)) builtin_type,
decode(ffca.action_type,'B',case
when ffca.builtin_type='C' then (select fcpv.user_concurrent_program_name from fnd_concurrent_programs_vl fcpv, fnd_application fa where substr(ffca.builtin_arguments,1,instr(ffca.builtin_arguments,':')-1)=fa.application_short_name and fa.application_id=fcpv.application_id and substr(ffca.builtin_arguments,instr(ffca.builtin_arguments,':')+1)=fcpv.concurrent_program_name)
when ffca.builtin_type='E' then (select fffv.user_function_name from fnd_form_functions_vl fffv where ffca.menu_argument_short=fffv.function_name)
when ffca.builtin_type in ('Q','X') then ffca.builtin_arguments
when ffca.builtin_type in ('U','D','P','G','B','F','T','L') then ffca.builtin_arguments
end) builtin_value,
decode(ffca.action_type,'B',case
when ffca.builtin_type in ('U','Q') then ffca.menu_argument_short
when ffca.builtin_type in ('E','X') then ffca.menu_argument_long
end)
builtin_value2,
ffca.menu_entry,
ffca.menu_label,
decode(ffca.menu_seperator,'Y','Y') render_line_before_menu,
ffca.menu_argument_short icon_name,
ffca.menu_enabled_in enabled_in_block,
ffcr.id
from
fnd_form_custom_rules ffcr,
fnd_form_functions_vl fffv,
fnd_form_vl ffv,
fnd_application_vl fav,
(select ffcs.* from fnd_form_custom_scopes ffcs where '&show_scope'='Y') ffcs,
fnd_industries fi,
fnd_responsibility_vl frv,
fnd_user fu,
fnd_form_custom_actions ffca,
fnd_languages_vl flv,
fnd_form_custom_prop_list ffcpl
where
1=1 and
ffcr.rule_key is null and
ffcr.function_name=fffv.function_name(+) and
fffv.application_id=ffv.application_id(+) and
fffv.form_id=ffv.form_id(+) and
fffv.application_id=fav.application_id(+) and
ffcr.id=ffcs.rule_id(+) and
decode(ffcs.level_id,10,ffcs.level_value)=fi.industry_id(+) and
fi.language(+)=userenv('lang') and
decode(ffcs.level_id,30,ffcs.level_value_application_id)=frv.application_id(+) and
decode(ffcs.level_id,30,ffcs.level_value)=frv.responsibility_id(+) and
decode(ffcs.level_id,40,ffcs.level_value)=fu.user_id(+) and
ffcr.id=ffca.rule_id(+) and
ffca.language=flv.language_code(+) and
decode(ffca.action_type,'P',ffca.object_type)=ffcpl.field_type(+) and
ffca.property_name=ffcpl.property_id(+)
order by
fav.application_name,
ffv.form_name,
level_,
function_name,
decode(ffcr.rule_type,'A',ffcr.function_name),
ffcr.sequence,
ffca.sequence
Parameter Name SQL text Validation
Form Name 
ffcr.form_name=:form_name
 LOV
Function Name 
fffv.function_name=:function_name
 LOV
Application Name 
fav.application_name=:application_name
 LOV
Description like 
lower(ffcr.description) like lower(:description)
 LOV
Last Updated By 
nvl(ffca.last_updated_by,ffcr.last_updated_by)=xxen_util.user_id(:last_updated_by)
 LOV
Last Update within Days 
greatest(nvl(ffca.last_update_date,ffcr.last_update_date),ffcr.last_update_date)>sysdate-:days
 Number
Last Update Date From 
greatest(nvl(ffca.last_update_date,ffcr.last_update_date),ffcr.last_update_date)>=:last_update_date_from
 DateTime
Show Context 
Y
 LOV
Download
 
Related Blitz Reports
FND User Login Page Favorites FND Access Control 11i FND Access Control FND FNDLOAD Object Transfer FND Attachment Functions FND Flex Value Sets, Usages and Values FND User Login History XXEN: FND User Login History with Geolocation FND Responsibility Menu Exclusions
Blitz Report™

Blitz Report™ provides multiple benefits: