FND Form Functions

Description

Categories: Application, Enginatics, Setup

Copy

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

Ask a question

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