Column Actions

Searching for javaScript in Apex applications is not difficult; there are multiple ways to do that - for example:

• Use the Search function of the Apex Builder. The best option but not complete and not easy to use/export.
• Search through an application export. Not very easy to read.
• Use the report under Utilities - Embedded Code in the Apex Builder. Nice but also incomplete.

So, to find all JavaScript in the entire application, I created a view.
I'm quite sure it is not complete either, but extending this view would be quite easy.

The Apex views contain all the information we need here; we just have to find it.
So I combined the views/columns I knew about, with all the views/columns that have JS or JAVASCRIPT in their column names and/or comments.
This results in quite a large list - see the query of the view below - of both actual JavaScript code and references to files that contain JavaScript.

This is the query I used to create the SQL statements for the Apex views, for use in my own view:
select '-- ' || tc.table_name || ' - ' || tc.column_name || chr(13) || chr(10) || 'select t.workspace, t.application_id' || ', ' || ( case when exists(select 1 from all_tab_cols tc2 where tc2.table_name = tc.table_name and tc2.column_name = 'PAGE_ID') then 't.page_id' else 'to_number(null) as page_id' end ) || ', ''' || lower(tc.table_name)|| ''' as object_type' -- || ', ''' || lower(tc.column_name) || ( case when tc.table_name like 'APEX_APPLICATION_TEMP_%' then ' ('' || lower(t.template_name) || '')' else null end ) || ''' as object_name' -- || ', ' || ( case when tc.data_type = 'CLOB' then 't.' || tc.column_name else 'to_clob(t.' || lower(tc.column_name) || ')' end ) || ' as code' || ' from iv_app' || ' join ' || lower(tc.table_name) || ' t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id)' || ' where length(' || lower(tc.column_name) || ') > 1' || ( case when tc.table_name like 'APEX_APPLICATION_TEMP_%' then ' and t.theme_number = iv_app.theme_number' else null end ) || chr(13) || chr(10) || 'union all' || chr(13) || chr(10) as s from all_tab_cols tc join apex_dictionary ady on ady.apex_view_name = tc.table_name and ady.column_name = tc.column_name where ( tc.column_name like '%JS\_%' escape '\' --' or tc.column_name like '%JAVASCRIPT%' or lower(ady.comments) like '%javascript%' ) and tc.data_length >= 4000 -- ignore small columns for classes, styles, y/n, prefixes, ids, urls, etc. order by 1
This approach also works for finding CSS - same idea, just using different Apex views.
To find CSS, the first part of the where-clause should be changed to this: where ( tc.column_name like '%CSS\_%' escape '\' --' or tc.column_name like '%CSS%' or lower(ady.comments) like '%css%' )

Page

Identification
	Page ID	1176
	Name	Apex - HTML / CSS / JavaScript - Find JavaScript (or CSS)

Region

Identification
	Sequence	10
	Title	Find JavaScript
	Type	Interactive Report
Source
	Location	Local Database
	Query Type	Table
	Table Name	TED_P1176_V

View

View
	Name	ted_p1176_v
	DDL	with iv_app as ( -- Applications select app.workspace , app.application_id , app.application_name , app.theme_number from apex_applications app where app.application_id = nvl(nv('APP_ID'), 25384) ) -- Dynamic Actions (Javascript Code) select dan.workspace , dan.application_id , dan.page_id , 'Dynamic Action (Javascript Code)' as object_type , dan.dynamic_action_name || ' (' || daa.dynamic_action_event_result || ')' as object_name , to_clob(daa.attribute_01) as code from iv_app join apex_application_page_da dan on (dan.workspace = iv_app.workspace and dan.application_id = iv_app.application_id) join apex_application_page_da_acts daa on daa.dynamic_action_id = dan.dynamic_action_id where daa.action_code = 'NATIVE_JAVASCRIPT_CODE' union all -- Dynamic Actions (Set Value) select dan.workspace , dan.application_id , dan.page_id , 'Dynamic Action (Set Value)' as object_type , dan.dynamic_action_name || ' (' || daa.dynamic_action_event_result || ')' as object_name , to_clob(daa.attribute_05) as code from iv_app join apex_application_page_da dan on (dan.workspace = iv_app.workspace and dan.application_id = iv_app.application_id) join apex_application_page_da_acts daa on daa.dynamic_action_id = dan.dynamic_action_id where daa.action_code = 'NATIVE_SET_VALUE' and daa.attribute_01 = 'JAVASCRIPT_EXPRESSION' union all -- APEX_APPLICATIONS - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_applications' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_applications t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPLICATIONS - PWA_SERVICE_WORKER_HOOKS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_applications' as object_type, 'pwa_service_worker_hooks' as object_name, t.PWA_SERVICE_WORKER_HOOKS as code from iv_app join apex_applications t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(pwa_service_worker_hooks) > 1 union all -- APEX_APPLICATION_NAV_BAR - ONCLICK_JAVASCRIPT select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_nav_bar' as object_type, 'onclick_javascript' as object_name, to_clob(t.onclick_javascript) as code from iv_app join apex_application_nav_bar t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(onclick_javascript) > 1 union all -- APEX_APPLICATION_PAGES - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'javascript_code' as object_name, t.JAVASCRIPT_CODE as code from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPLICATION_PAGES - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'javascript_code_onload' as object_name, t.JAVASCRIPT_CODE_ONLOAD as code from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 union all -- APEX_APPLICATION_PAGES - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPLICATION_PAGES - PAGE_HTML_ONLOAD select t.workspace, t.application_id, t.page_id, 'apex_application_pages' as object_type, 'page_html_onload' as object_name, to_clob(t.page_html_onload) as code from iv_app join apex_application_pages t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(page_html_onload) > 1 union all -- APEX_APPLICATION_PAGE_CHARTS - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_charts' as object_type, 'javascript_code' as object_name, to_clob(t.javascript_code) as code from iv_app join apex_application_page_charts t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPLICATION_PAGE_DA_ACTS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_da_acts' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as code from iv_app join apex_application_page_da_acts t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPLICATION_PAGE_ITEMS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_items' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as code from iv_app join apex_application_page_items t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPLICATION_PAGE_REGIONS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_application_page_regions' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as code from iv_app join apex_application_page_regions t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPLICATION_TEMP_LIST - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_list' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_code_onload) as code from iv_app join apex_application_temp_list t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_LIST - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_list' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_application_temp_list t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - DIALOG_JS_CANCEL_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'dialog_js_cancel_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.dialog_js_cancel_code) as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(dialog_js_cancel_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - DIALOG_JS_CLOSE_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'dialog_js_close_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.dialog_js_close_code) as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(dialog_js_close_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - DIALOG_JS_INIT_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'dialog_js_init_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.dialog_js_init_code) as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(dialog_js_init_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - GRID_JAVASCRIPT_DEBUG_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'grid_javascript_debug_code (' || lower(t.template_name) || ')' as object_name, to_clob(t.grid_javascript_debug_code) as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(grid_javascript_debug_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - JAVASCRIPT_CODE select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'javascript_code (' || lower(t.template_name) || ')' as object_name, t.JAVASCRIPT_CODE as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, t.JAVASCRIPT_CODE_ONLOAD as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_PAGE - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_page' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_application_temp_page t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REGION - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_region' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_code_onload) as code from iv_app join apex_application_temp_region t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REGION - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_region' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_application_temp_region t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REPORT - JAVASCRIPT_CODE_ONLOAD select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_report' as object_type, 'javascript_code_onload (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_code_onload) as code from iv_app join apex_application_temp_report t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code_onload) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_TEMP_REPORT - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_temp_report' as object_type, 'javascript_file_urls (' || lower(t.template_name) || ')' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_application_temp_report t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 and t.theme_number = iv_app.theme_number union all -- APEX_APPLICATION_THEMES - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_application_themes' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_application_themes t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPL_PAGE_IGS - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_appl_page_igs' as object_type, 'javascript_code' as object_name, to_clob(t.javascript_code) as code from iv_app join apex_appl_page_igs t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPL_PAGE_IG_COLUMNS - INIT_JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_appl_page_ig_columns' as object_type, 'init_javascript_code' as object_name, to_clob(t.init_javascript_code) as code from iv_app join apex_appl_page_ig_columns t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(init_javascript_code) > 1 union all -- APEX_APPL_PAGE_IG_COLUMNS - JAVASCRIPT_CODE select t.workspace, t.application_id, t.page_id, 'apex_appl_page_ig_columns' as object_type, 'javascript_code' as object_name, to_clob(t.javascript_code) as code from iv_app join apex_appl_page_ig_columns t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_code) > 1 union all -- APEX_APPL_PLUGINS - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_appl_plugins' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_appl_plugins t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1 union all -- APEX_APPL_USER_INTERFACES - JAVASCRIPT_FILE_URLS select t.workspace, t.application_id, to_number(null) as page_id, 'apex_appl_user_interfaces' as object_type, 'javascript_file_urls' as object_name, to_clob(t.javascript_file_urls) as code from iv_app join apex_appl_user_interfaces t on (t.workspace = iv_app.workspace and t.application_id = iv_app.application_id) where length(javascript_file_urls) > 1