Skip to Main Content

Hierarchy

Path SortPath TextEntry TextDisplay SequenceEntry TargetPage Id
00010HomeHome10#-
00010 ^ 00011Home ^ Ted Struik - OracleTed Struik - Oracle11f?p=&APP_ID.:1:&SESSION.::&DEBUG.::::1
00010 ^ 00012Home ^ SearchSearch12f?p=&APP_ID.:2:&SESSION.::&DEBUG.:RP,RIR,CIR:::2
00010 ^ 00013Home ^ Site MapSite Map13f?p=&APP_ID.:3:&SESSION.::&DEBUG.::::3
00010 ^ 00014Home ^ StatisticsStatistics14f?p=&APP_ID.:1113:&SESSION.::&DEBUG.::::1113
00010 ^ 00015Home ^ Page ErrorsPage Errors15f?p=&APP_ID.:4:&SESSION.::&DEBUG.::::4
01000ApexApex1000#-
01000 ^ 01050Apex ^ GeneralGeneral1050#-
01000 ^ 01050 ^ 01051Apex ^ General ^ AutocompleteAutocomplete1051f?p=&APP_ID.:1011:&SESSION.::&DEBUG.::::1011
01000 ^ 01050 ^ 01052Apex ^ General ^ ConditionsConditions1052f?p=&APP_ID.:1008:&SESSION.::&DEBUG.::::1008
01000 ^ 01050 ^ 01053Apex ^ General ^ ErrorsErrors1053f?p=&APP_ID.:1012:&SESSION.::&DEBUG.::::1012
01000 ^ 01050 ^ 01054Apex ^ General ^ Items used in PL/SQLItems used in PL/SQL1054f?p=&APP_ID.:1013:&SESSION.::&DEBUG.::::1013
01000 ^ 01050 ^ 01055Apex ^ General ^ ValidationsValidations1055f?p=&APP_ID.:1019:&SESSION.::&DEBUG.::::1019
01000 ^ 01050 ^ 01057Apex ^ General ^ Dynamic ActionsDynamic Actions1057f?p=&APP_ID.:1030:&SESSION.::&DEBUG.::::1030
01000 ^ 01050 ^ 01058Apex ^ General ^ LogsLogs1058f?p=&APP_ID.:1031:&SESSION.::&DEBUG.::::1031
  • 1 - 15 of 199

Info

Query to get a sorted list of the complete (root to child) path of an Apex list.

The case statement to determine the menu_target is not bulletproof, but it works.
Even though it should resolve to a page_id, the entry_target might contain other (javascript) code which I have not dealt with here.
Therefore I left it as a varchar2, and then outer joined it to the application_pages view.
It handles these types of targets:
  f?p=&APP_ID.:1000:&SESSION.::NO::::
and
  javascript:window.open('f?p=1234:1000:&APP_SESSION.::', '_blank')

Note that the query does not take the application_id into account - shouldn't be a problem in most cases.

Code

Page

Identification
Page ID
Name

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source