FND Form Functions

➜ Back to Library
Description
Categories: Application, Enginatics, Setup
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
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
Download
 
Related Blitz Reports
FND Attachment Functions FND Access Control FND User Login Page Favorites FND User Login History FND Responsibility Menu Exclusions FND Menu Entries FND Forms Personalizations FND Descriptive Flexfields FND Key Flexfields
Blitz Report In Action