APEX-AT-WORK no image
Tags:

Getting APEX views

Von Tobias Arnhold 7.03.2012
There is a easy way getting all APEX views just with a simple select:
select apex_view_name, comments
from apex_dictionary
where column_id = 0
order by 1;

select LPAD (' ', (LEVEL - 1) * 2) ||  apex_view_name s, comments
from (
  select 'ROOT' as apex_view_name, null as comments, null as parent_view
  from dual
  UNION
  select apex_view_name, comments, nvl(parent_view,'ROOT') as parent_view
  from apex_dictionary
  where column_id = 0
) 
  connect by prior apex_view_name = parent_view
  start with parent_view is null
order SIBLINGS by apex_view_name DESC; 
Current APEX views in version 4.2
APEX_VIEWS COMMENTS
*ROOT  
**APEX_WORKSPACES Available Application Express (APEX) workspaces
***APEX_WS_APPLICATIONS  
****APEX_WS_DATA_GRID Websheet Data Grid definition
*****APEX_WS_DATA_GRID_COL Report column definitions for Websheet Data Grid columns
****APEX_WS_APP_PAGES  
***APEX_WORKSPACE_UI_TYPES The UI Types identify the available user interface types of a workspace
***APEX_WORKSPACE_SQL_SCRIPTS Identifies SQL Scripts used to execute SQL and PL/SQL commands
***APEX_WORKSPACE_SESSIONS Application Express (APEX) sessions by workspace and APEX user
***APEX_WORKSPACE_SCHEMAS Database Schemas mapped to APEX workspaces
***APEX_WORKSPACE_GROUP_USERS Application Express (APEX) users and groups relationship
***APEX_WORKSPACE_GROUPS Application Express (APEX) users and groups relationship
***APEX_WORKSPACE_FILES Identifies uploaded files belonging to the workspace in the modplsql or EPG documents table
***APEX_WORKSPACE_DEVELOPERS Application Express (APEX) developers, APEX users with privilege to develop applications
***APEX_WORKSPACE_CLICKS Clicks in Application Express that are tracked by using APEX_UTIL.COUNT_CLICKS
***APEX_WORKSPACE_APEX_USERS Application Express (APEX) users
***APEX_WORKSPACE_ACTIVITY_LOG Page view activity log detail.  One row is logged for each page view for application with logging enabled.
****APEX_WORKSPACE_LOG_SUMMARY_USR Page view activity log summarized by user for the last two weeks
****APEX_WORKSPACE_LOG_SUMMARY Page view activity log summarized by application for the last 14 days
****APEX_WORKSPACE_LOG_ARCHIVE Page view activity is a daily summary of workspace acitivity that is retained until physically purged
***APEX_WORKSPACE_ACCESS_LOG One row is logged for each login attempt.
***APEX_TEAM_TODOS Items that need to get done - i.e. to dos.
***APEX_TEAM_MILESTONES Identifies bugs, also known as software defects.
***APEX_TEAM_FEEDBACK Identifies user feedback.
****APEX_TEAM_FEEDBACK_FOLLOWUP Identifies user feedback followup.
***APEX_TEAM_FEATURES Items that need to get done - i.e. to dos.
***APEX_TEAM_BUGS Identifies bugs, also known as software defects.
***APEX_APPLICATIONS Applications defined in the current workspace or database user.
****APEX_APPL_USER_INTERFACES  
****APEX_APPL_PLUGIN_SETTINGS Stores the values of custom attribute of scope "application" of a plug-in.
****APEX_APPL_PLUGINS Stores the meta data for the plug-ins of an application.
*****APEX_APPL_PLUGIN_FILES Stores the files like CSS, images, javascript files, ... of a plug-in.
*****APEX_APPL_PLUGIN_EVENTS Stores which events can be triggered by this plug-in. This events are used for binding dynamic actions.
*****APEX_APPL_PLUGIN_ATTRIBUTES Stores the meta data for the dynamic attributes of a plug-in.
******APEX_APPL_PLUGIN_ATTR_VALUES Stores the possible values of a plug-in attribute if it's of type selectlist.
****APEX_APPL_LOAD_TABLE_RULES Identifies a collection of transformation rules that are to be used on the load tables.
****APEX_APPL_LOAD_TABLE_LOOKUPS Identifies a the collection of key lookups of the data loading tables
****APEX_APPL_LOAD_TABLES Identifies a named collection of Application Data loding tables which are used to store the metadata information of the data loading tables
****APEX_APPLICATION_WEB_SERVICES Web Services referenceable from this Application
****APEX_APPLICATION_TREES Identifies a tree control which can be referenced and displayed by creating a region with a source of this tree
****APEX_APPLICATION_TRANS_REPOS Repository of translation strings.  These are populated from the translation seeding process.
****APEX_APPLICATION_TRANS_MAP Application Groups defined per workspace.  Applications can be associated with an application group.
****APEX_APPLICATION_TRANS_DYNAMIC Application dynamic translations.  These are created in the Translation section of Shared Components, and referenced at runtime via the function APEX_LANG.LANG.
****APEX_APPLICATION_TRANSLATIONS Identifies message primary language text and translated text
****APEX_APPLICATION_THEMES Identifies a named collection of Templates
*****APEX_APPL_THEME_DISPLAY_POINTS The Theme Display Points identify the available display points in page and region templates
*****APEX_APPLICATION_THEME_STYLES The Theme Style identifies the CSS file URLs which should be used for a theme
*****APEX_APPLICATION_TEMP_REPORT Identifies the HTML template markup used to render a Report Headings and Rows
*****APEX_APPLICATION_TEMP_REGION Identifies a regions HTML template display attributes
*****APEX_APPLICATION_TEMP_POPUPLOV Identifies the HTML template markup and some functionality of all Popup List of Values controls for this application
*****APEX_APPLICATION_TEMP_PAGE The Page Template which identifies the HTML used to organized and render a page content
*****APEX_APPLICATION_TEMP_LIST Identifies HTML template markup used to render a List with List Elements
*****APEX_APPLICATION_TEMP_LABEL Identifies a Page Item Label HTML template display attributes
*****APEX_APPLICATION_TEMP_CALENDAR Identifies the HTML template markup used to display a Calendar
*****APEX_APPLICATION_TEMP_BUTTON Identifies the HTML template markup used to display a Button
*****APEX_APPLICATION_TEMP_BC Identifies the HTML template markup used to render a Breadcrumb
*****APEX_APPLICATION_TEMPLATES Identifies reference counts for templates of all types
****APEX_APPLICATION_TABS Identifies a set of tabs collected into tab sets which are associated with a Standard Tab Entry
****APEX_APPLICATION_SUPP_OBJECTS Identifies the Supporting Object installation messages
*****APEX_APPLICATION_SUPP_OBJ_SCR Identifies the Supporting Object installation SQL Scripts
*****APEX_APPLICATION_SUPP_OBJ_CHCK Identifies the Supporting Object pre-installation checks to ensure the database is compatible with the objects to be installed
*****APEX_APPLICATION_SUPP_OBJ_BOPT Identifies the Application Build Options that will be exposed to the Supporting Object installation
****APEX_APPLICATION_SUBSTITUTIONS Application level definitions of substitution strings.
****APEX_APPLICATION_SHORTCUTS Identifies Application Shortcuts which can be referenced "MY_SHORTCUT" syntax
****APEX_APPLICATION_PROCESSES Identifies Application Processes which can run for every page, on login or upon demand
****APEX_APPLICATION_PARENT_TABS Identifies a collection of tabs called a Tab Set.  Each tab is part of a tab set and can be current for one or more pages.  Each tab can also have a corresponding Parent Tab if two levels of Tabs are defined.
****APEX_APPLICATION_PAGES A Page definition is the basic building block of page. Page components including regions, items, buttons, computations, branches, validations, and processes further define the definition of a page.
*****APEX_APPLICATION_PAGE_VAL Identifies Validations associated with an Application Page
*****APEX_APPLICATION_PAGE_REGIONS Identifies a content container associated with a Page and displayed within a position defined by the Page Template
******APEX_APPLICATION_PAGE_TREES Identifies a tree control which can be referenced and displayed by creating a region with a source of this tree
******APEX_APPLICATION_PAGE_RPT Printing attributes for regions that are reports
*******APEX_APPLICATION_PAGE_RPT_COLS Report column definitions used for report regions
******APEX_APPLICATION_PAGE_ITEMS Identifies Page Items which are used to render HTML form content.  Items automatically maintain session state which can be accessed using bind variables or substitution stings.
******APEX_APPLICATION_PAGE_FLASH_CH Identifies a Flash chart associated with a Page and Region
*******APEX_APPLICATION_PAGE_FLASH_S Identifies the Flash chart series which comprise a Flash chart
******APEX_APPLICATION_PAGE_FLASH5 Identifies a Flash chart 5 chart associated with a Page and Region
*******APEX_APPLICATION_PAGE_FLASH5_S Identifies the Flash chart series which comprise a Flash chart
******APEX_APPLICATION_PAGE_BUTTONS Identifies buttons associated with a Page and Region
*****APEX_APPLICATION_PAGE_PROC Identifies SQL or PL/SQL processing associated with a page
*****APEX_APPLICATION_PAGE_MAP Identifies the full breadcrumb path for each page with a breadcrumb entry
*****APEX_APPLICATION_PAGE_GROUPS Identifies page groups
*****APEX_APPLICATION_PAGE_DB_ITEMS Identifies Page Items which are associated with Database Table Columns.  This view represents a subset of the items in the APEX_APPLICATION_PAGE_ITEMS view.
*****APEX_APPLICATION_PAGE_DA Identifies Dynamic Actions associated with a Page
******APEX_APPLICATION_PAGE_DA_ACTS Identifies the Actions of a Dynamic Action associated with a Page
*****APEX_APPLICATION_PAGE_COMP Identifies the computation of Item Session State
*****APEX_APPLICATION_PAGE_BRANCHES Identifies branch processing associated with a page.  A branch is a directive to navigate to a page or URL which is run at the conclusion of page accept processing.
****APEX_APPLICATION_NAV_BAR Identifies navigation bar entries displayed on pages that use a Page Template that include a #NAVIGATION_BAR# substitution string
****APEX_APPLICATION_LOVS Identifies a shared list of values that can be referenced by a Page Item or Report Column
*****APEX_APPLICATION_LOV_ENTRIES Identifies the List of Values Entries which comprise a shared List of Values
****APEX_APPLICATION_LISTS Identifies a named collection of Application List Entries which can be included on any page using a region of type List.  Display attributes are controlled using a List Template.
*****APEX_APPLICATION_LIST_ENTRIES Identifies the List Entries which define a List.  List Entries can be hierarchical or flat.
****APEX_APPLICATION_ITEMS Identifies Application Items used to maintain session state that are not associated with a page
****APEX_APPLICATION_GROUPS Application Groups defined per workspace.  Applications can be associated with an application group.
****APEX_APPLICATION_COMPUTATIONS Identifies Application Computations which can run for every page or on login
****APEX_APPLICATION_CACHING Applications defined in the current workspace or database user.
****APEX_APPLICATION_BUILD_OPTIONS Identifies Build Options available to an application
****APEX_APPLICATION_BREADCRUMBS Identifies the definition of a collection of Breadcrumb Entries which are used to identify a page Hierarchy
****APEX_APPLICATION_BC_ENTRIES Identifies Breadcrumb Entries which map to a Page and identify a pages parent
****APEX_APPLICATION_AUTHORIZATION Identifies Authorization Schemes which can be applied at the application, page or component level
****APEX_APPLICATION_AUTH Identifies the available Authentication Schemes defined for an Application
****APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application
**APEX_UI_DEFAULTS_TABLES The User Interface Defaults for the tables within this schema.  Used by the wizards when generating applications.
**APEX_UI_DEFAULTS_LOV_DATA If you create a form, report, or tabular form that includes this column and if the appropriate Display As Type is set to use a list of values (Radio Group or Select List) then a Named List of Values will be created within the application and will be referenced by the resulting item or report column.
**APEX_UI_DEFAULTS_GROUPS The User Interface Defaults for the groups within the tables in this schema.  Used by the wizards when generating applications.
**APEX_UI_DEFAULTS_COLUMNS The User Interface Defaults for the columns within this schema.
**APEX_UI_DEFAULTS_ATTR_DICT The Attribute Dictionary is specific to a workspace.  It is part of User Interface Defaults and can be used in report and form creation.
**APEX_THEMES List of APEX built-in, public and workspace themes

Post Tags: