Monday, June 20, 2016

Query to find Oracle Form Name and associated function

select
fnf.application_id,
fa.APPLICATION_NAME,
ff.FUNCTION_NAME ,
ffl.USER_FUNCTION_NAME ,
ffl.description ,
fnf.form_name,
ff.parameters,
ff.type
from fnd_form_functions_tl ffl,
fnd_form_functions ff,
fnd_form fnf,
fnd_application_tl fa
where
–ff.function_name like ‘******’
ffl.FUNCTION_ID=ff.FUNCTION_ID
–and ff.type=’FORM
and fnf.form_id=ff.form_id
and fa.application_id=fnf.application_id
–and fa.APPLICATION_ID=******

1 comment:

  1. 25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students

    Please Check https://www.oracleappstechnical.com for details

    ReplyDelete