VIEW: APPS.BIS_WWPOB_PORTLETS_V

Source

View Text - Preformatted

SELECT distinct d.object_name page_name, c.function_name name, c.user_function_name longname, BIS_SUBMIT_REQUESTSET.get_last_refreshtime('PORTLET',null,c.function_name) last_refresh_time, 1234, sysdate, sysdate, 1234, 1234 from fnd_form_functions_vl c, bis_obj_dependency d WHERE c.function_name=d.depend_object_name and d.depend_object_type='PORTLET' and d.object_type='PAGE' and d.enabled_flag='Y'

View Text - HTML Formatted

SELECT DISTINCT D.OBJECT_NAME PAGE_NAME
, C.FUNCTION_NAME NAME
, C.USER_FUNCTION_NAME LONGNAME
, BIS_SUBMIT_REQUESTSET.GET_LAST_REFRESHTIME('PORTLET'
, NULL
, C.FUNCTION_NAME) LAST_REFRESH_TIME
, 1234
, SYSDATE
, SYSDATE
, 1234
, 1234
FROM FND_FORM_FUNCTIONS_VL C
, BIS_OBJ_DEPENDENCY D
WHERE C.FUNCTION_NAME=D.DEPEND_OBJECT_NAME
AND D.DEPEND_OBJECT_TYPE='PORTLET'
AND D.OBJECT_TYPE='PAGE'
AND D.ENABLED_FLAG='Y'