A first attempt at recreating the Workspace Utilities -> Application Express Views available in the Apex IDE.
Can be useful when you only have an Apex Runtime enviroment available, and still want to use the Apex Views.

Not complete yet, but works for now.

Note that the "all_users" constructs in P1098_COLUMNS are needed to ensure we only get results for the most current apex version. If you upgraded Apex in the past, and did not remove the old APEX_0% schema(s), you would get multiple results here.

Item

Identification
	Sequence	20
	Name	P1098_VIEW_NAME
	Display As	Popup LOV
User Interface
	Region	Apex View
List Of Values
	Display Extra Values	No
	Display Null Value	No
	List of values definition	select apex_view_name || ' (' || comments || ')' as d , apex_view_name as r from apex_dictionary where column_id = 0 order by apex_view_name
Advanced
	Warn on Unsaved Changes	Page Default
Source
	Source Used	Only when current value in session state is null
	Source Type	Always Null

Item

Identification
	Sequence	30
	Name	P1098_COLUMNS
	Display As	Shuttle
User Interface
	Region	Apex View
List Of Values
	Display Extra Values	No
	Display Null Value	No
	Cascading LOV Parent Item(s)	P1098_VIEW_NAME
	List of values definition	select d.column_name as d , d.column_name as r from apex_dictionary d , all_tab_cols tc , ( select max(u1.username) as current_apex_user from all_users u1 where u1.username like 'APEX%' and regexp_like (substr(u1.username,'6',1), '^[0-9]*$') ) u where d.apex_view_name = tc.table_name and d.column_name = tc.column_name and tc.owner = u.current_apex_user and d.apex_view_name = :P1098_VIEW_NAME and d.column_id <> 0 order by d.column_id
Advanced
	Warn on Unsaved Changes	Page Default
Source
	Source Used	Only when current value in session state is null
	Source Type	Always Null
Default
	Default Value	declare v_result varchar2(32767); begin select listagg(d.column_name, ':') within group (order by d.column_id) as x into v_result from apex_dictionary d , all_tab_cols tc where d.apex_view_name = tc.table_name and d.column_name = tc.column_name and d.apex_view_name = :P1098_VIEW_NAME and d.column_id <> 0 and d.column_name in ( 'WORKSPACE' , 'WORKSPACE_DISPLAY_NAME' , 'APPLICATION_ID' , 'APPLICATION_NAME' , 'PAGE_ID' , 'PAGE_NAME' ) ; return v_result; end;
	Default Value Type	FUNCTION_BODY

Item

Identification
	Sequence	40
	Name	P1098_WHERE_CLAUSE
	Display As	Textarea
User Interface
	Region	Apex View
List Of Values
	Display Extra Values	Yes
	Display Null Value	No
Advanced
	Warn on Unsaved Changes	Page Default
Source
	Source Used	Only when current value in session state is null
	Source Type	Always Null

Item

Identification
	Sequence	10
	Name	P1098_QUERY
	Display As	Display Only
User Interface
	Region	Result
List Of Values
	Display Null Value	No
Advanced
	Warn on Unsaved Changes	Page Default
Source
	Source Used	Always, replacing any existing value in session state
	Source Type	Function Body
	Source value or expression	declare q varchar2(32767); l_lf varchar2(10) := chr(10); begin q:= 'select ' || replace(ltrim(rtrim(replace( :P1098_COLUMNS,':',',' || l_lf),','),','),',,',',' ) || l_lf || ' from ' || :P1098_VIEW_NAME || l_lf || ( case when :P1098_WHERE_CLAUSE is not null then ' where ' || :P1098_WHERE_CLAUSE else null end ) ; return q; end;

Region

Identification
	Sequence	20
	Title	Result
	Type	Report
Source
	Source Type	FUNCTION_RETURNING_SQL_QUERY
	Region Source	begin return :P1098_QUERY; end;
Conditions
	Condition Type	Expression
	Expression 1	:P1098_VIEW_NAME is not null and :P1098_COLUMNS is not null
	Expression 2	PLSQL