VIEW: APPS.BIS_BIA_RSG_PAGE_STATUS_V

Source

View Text - Preformatted

(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

View Text - HTML Formatted

(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