Skip to Main Content

Apex View

Info

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.

Code

Item

Identification
Sequence
Name
Display As
User Interface
Region
List Of Values
Display Extra Values
Display Null Value
List of values definition
Source
Source Used
Source Type

Item

Identification
Sequence
Name
Display As
User Interface
Region
List Of Values
Display Extra Values
Display Null Value
Cascading LOV Parent Item(s)
List of values definition
Source
Source Used
Source Type
Default
Default Value
Default Value Type

Item

Identification
Sequence
Name
Display As
User Interface
Region
List Of Values
Display Extra Values
Display Null Value
Source
Source Used
Source Type

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source
Conditions
Condition Type
Expression 1