Reports2017-11-18T12:27:27+00:00

FND Form Functions

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