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 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
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