Skip to Main Content

APEX Views and PL/SQL API's

Learn about changes of APEX Views and API's between versions 19.2 and 22.1

Filters

Search Results

View19.220.120.221.1

APEX_APPLICATIONS

Applications defined in the current workspace or database user.

APEX_APPLICATION_ALL_AUTH

All authorization schemes for all components by Application

APEX_APPLICATION_AUTH

Identifies the available Authentication Schemes defined for an Application

APEX_APPLICATION_AUTHORIZATION

Identifies Authorization Schemes which can be applied at the application, page or component level

APEX_APPLICATION_BC_ENTRIES

Identifies Breadcrumb Entries which map to a Page and identify a pages parent

APEX_APPLICATION_BREADCRUMBS

Identifies the definition of a collection of Breadcrumb Entries which are used to identify a page Hierarchy

APEX_APPLICATION_BUILD_OPTIONS

Identifies Build Options available to an application

APEX_APPLICATION_CACHING

Applications defined in the current workspace or database user.

APEX_APPLICATION_COMPUTATIONS

Identifies Application Computations which can run for every page or on login

APEX_APPLICATION_GROUPS

Application Groups defined per workspace. Applications can be associated with an application group.

APEX_APPLICATION_ITEMS

Identifies Application Items used to maintain session state that are not associated with a page

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_LOCKED_PAGES

Locked pages of an application

APEX_APPLICATION_LOVS

Identifies a shared list of values that can be referenced by a Page Item or Report Column

APEX_APPLICATION_LOV_COLS

Identifies column metadata for a shared list of values.

APEX_APPLICATION_LOV_ENTRIES

Identifies the List of Values Entries which comprise a shared List of Values

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_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_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_PAGE_BUTTONS

Identifies buttons associated with a Page and Region

APEX_APPLICATION_PAGE_CHARTS

Identifies a chart associated with a Page and Region.

APEX_APPLICATION_PAGE_CHART_A

Identifies a chart axis associated with a chart on a Page and Region.

APEX_APPLICATION_PAGE_CHART_S

Identifies a chart series associated with a chart on a Page and Region.

APEX_APPLICATION_PAGE_COMP

Identifies the computation of Item Session State

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_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_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_GROUPS

Identifies page groups

APEX_APPLICATION_PAGE_IR

Identifies attributes of an interactive report

APEX_APPLICATION_PAGE_IR_CAT

Report column category definitions for interactive report columns

APEX_APPLICATION_PAGE_IR_CGRPS

Column group definitions for interactive report columns

APEX_APPLICATION_PAGE_IR_COL

Report column definitions for interactive report columns

APEX_APPLICATION_PAGE_IR_COMP

Identifies computations defined in user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_COND

Identifies filters and highlights defined in user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_GRPBY

Identifies group by view defined in user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_PIVOT

Identifies pivot view defined in user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_PVAGG

Identifies aggregates defined for a pivot view in user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_PVSRT

Identifies sorts defined for a pivot view in user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_RPT

Identifies user-level report settings for an interactive report

APEX_APPLICATION_PAGE_IR_SUB

Identifies subscriptions scheduled in saved reports for an interactive report

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_MAP

Identifies the full breadcrumb path for each page with a breadcrumb entry

APEX_APPLICATION_PAGE_PROC

Identifies SQL or PL/SQL processing associated with a 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_REG_COLS

Region column definitions used for regions

APEX_APPLICATION_PAGE_RPT

Printing attributes for regions that are reports

APEX_APPLICATION_PAGE_RPT_COLS

Report column definitions used for report regions