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 NameSQL textValidation
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™