VIEW: APPS.BIS_WWPOB_PAGES_V

Source

View Text - Preformatted

SELECT distinct b.object_owner, b.object_name, f.user_function_name, BIS_SUBMIT_REQUESTSET.get_last_refreshtime('PAGE',null,b.object_name) last_refresh_time, sysdate, 1234, 1234, sysdate, 1234 from fnd_form_functions_vl f, bis_obj_dependency b WHERE upper(f.web_html_call) = 'ORACLESSWA.SWITCHPAGE' and b.object_name= substr(f.parameters,10) and b.object_type='PAGE'

View Text - HTML Formatted

SELECT DISTINCT B.OBJECT_OWNER
, B.OBJECT_NAME
, F.USER_FUNCTION_NAME
, BIS_SUBMIT_REQUESTSET.GET_LAST_REFRESHTIME('PAGE'
, NULL
, B.OBJECT_NAME) LAST_REFRESH_TIME
, SYSDATE
, 1234
, 1234
, SYSDATE
, 1234
FROM FND_FORM_FUNCTIONS_VL F
, BIS_OBJ_DEPENDENCY B
WHERE UPPER(F.WEB_HTML_CALL) = 'ORACLESSWA.SWITCHPAGE'
AND B.OBJECT_NAME= SUBSTR(F.PARAMETERS
, 10)
AND B.OBJECT_TYPE='PAGE'