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)
:O thanks a lots!!
ReplyDeleteGracias!!
Very Good
ReplyDelete