Search This Blog

Wednesday, April 20, 2016

Query find Custom Reports/Programs and Custom Forms registered in the EBS



1.
Query find Custom Reports/Programs

SELECT CONCURRENT_PROGRAM_ID,CONCURRENT_PROGRAM_NAME,
USER_CONCURRENT_PROGRAM_NAME,DESCRIPTION, APPLICATION_ID
 FROM FND_CONCURRENT_PROGRAMS_VL
  WHERE CREATED_BY NOT IN ( -1,1,2,120,121,0)
--('AUTOINSTALL','INITIAL SETUP','ORACLE12.0.0','SYSADMIN','ANONYMOUS','ORACLE12.1.0')
 AND ENABLED_FLAG = 'Y'
 AND SRS_FLAG = 'Y'


2.
Query to find Custom Forms

 SELECT APPLICATION_ID, FORM_ID, FORM_NAME,DESCRIPTION FROM FND_FORM_VL
 WHERE CREATED_BY NOT IN ( -1,1,2,120,121,0)





2 comments: