FND Form Functions

➜ Back to Library
Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Function, User Function Name, Type, Form Application, Form Name, User Form Name, Parameters, Html Call, Created By, Creation Date ... 
select
fffv.function_name function,
fffv.user_function_name,
nvl(xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0),fffv.type) type,
fav.application_name form_application,
ffv.form_name,
ffv.user_form_name,
fffv.parameters,
fffv.web_html_call html_call,
xxen_util.user_name(fffv.created_by) created_by,
xxen_util.client_time(fffv.creation_date) creation_date,
xxen_util.user_name(fffv.last_updated_by) last_updated_by,
xxen_util.client_time(fffv.last_update_date) last_update_date
from
fnd_application_vl fav,
fnd_form_functions_vl fffv,
fnd_form_vl ffv
where
1=1 and
fffv.application_id=ffv.application_id(+) and
fffv.form_id=ffv.form_id(+) and
ffv.application_id=fav.application_id(+)
order by
ffv.form_name,
fffv.function_name
Parameter Name SQL text Validation
Form Application Name 
fav.application_name=:application_name
 LOV
Responsibility Name 
fffv.function_id in (
select
fcmf.function_id
from
fnd_responsibility_vl frv,
fnd_compiled_menu_functions fcmf
where
frv.responsibility_name=:responsibility_name and
frv.menu_id=fcmf.menu_id and
nvl(fcmf.grant_flag,'Y')='Y'
)
 LOV
Form Name 
ffv.form_name=:form_name
 LOV
User Function Name 
upper(fffv.user_function_name) like upper(:user_function_name)
 LOV
Function Name 
fffv.function_name=:function_name
 LOV
User Form Name 
ffv.user_form_name=:user_form_name
 LOV
Form Application Short Name 
fav.application_short_name=:short_name
 LOV
HTML Call like 
fffv.web_html_call like :html_call
Download
 
Related Blitz Reports
FND Access Control 11i FND Menu Entries FND Forms Personalizations FND Access Control FND Attachment Functions FND User Login History FND FNDLOAD Object Transfer FND Responsibility Menu Exclusions FND User Login History with Geolocation
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: