FND Form Functions

Description

Categories
Enginatics
Repository
GitHub

SQL 25 lines

Parameters 9

ParameterTypeList of values SQL
Function NameLOV
fffv.function_name=:function_name
User Function Name likeLOV
upper(fffv.user_function_name) like upper(:user_function_name)
Function TypeLOV
fffv.type=xxen_util.lookup_code(:function_type,'FORM_FUNCTION_TYPE',0)
Form Application NameLOV
fav.application_name=:application_name
Form Application Short NameLOV
fav.application_short_name=:short_name
Form NameLOV
ffv.form_name=:form_name
User Form NameLOV
ffv.user_form_name=:user_form_name
Responsibility NameLOV
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'
)
HTML Call containsChar
lower(fffv.web_html_call) like '%'||lower(:html_call)||'%'