(SELECT DISTINCT F.FUNCTION_NAME ID , F.USER_FUNCTION_NAME VALUE , OBJECT_TYPE TYPE FROM
FND_FORM_FUNCTIONS_VL F , BIS_OBJ_PROPERTIES O
WHERE (UPPER(F.WEB_HTML_CALL)
LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
AND BIS_IMPL_DEV_PKG.GET_FUNCTION_BY_PAGE(O.OBJECT_NAME) = F.FUNCTION_NAME
AND O.OBJECT_TYPE = 'PAGE')
OR
(TYPE IN ('WWW' , 'JSP')
AND ( UPPER(WEB_HTML_CALL) LIKE '%BISVIEWER.SHOWREPORT%'
OR WEB_HTML_CALL LIKE '%OA.JSP?PAGE=/ORACLE/APPS/BIS/REPORT/WEBUI/BISREPORTPG%')
AND F.FUNCTION_NAME=O.OBJECT_NAME
AND O.OBJECT_TYPE = 'REPORT')) ORDER BY USER_FUNCTION_NAME