Apex - Reports - Column Usage

Skip to Main Content

Application Id	Page Id	Column Alias	Used By Column Alias	Column Link
25384	1047	EMPNO	EDIT	f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.::&DEBUG.::P1047_EMPNO:#EMPNO#
25384	1047	EMPNO	EDIT	f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.::&DEBUG.::P1047_EMPNO_CLASSIC:#EMPNO#
25384	1147	PRODUCT_ID	PK_ID	f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.::&DEBUG.::P1147_PRODUCT_ID:#PRODUCT_ID#

A simple method to find report colums that are used by other columns in that same report.
In the case of page 1047 in the example above, the EMPNO column is referenced by the EDIT column; it is used to fill page parameter P1047_EMPNO.

Page

Identification
	Page ID	1094
	Name	Apex - Reports - Column Usage

Region

Identification
	Sequence	10
	Title	IR
	Type	Interactive Report
Source
	Source Type	DYNAMIC_QUERY
	Region Source	select c.application_id , c.page_id , c.column_alias , c2.column_alias as used_by_column_alias , c2.column_link from apex_application_page_ir_col c , apex_application_page_ir_col c2 where c.application_id = c2.application_id and c.page_id = c2.page_id and c.column_alias <> c2.column_alias -- self-reference is OK and upper(c2.column_link) like '%#'\|\|upper(c.column_alias)\|\|'#%' union all select c.application_id , c.page_id , c.column_alias , c2.column_alias as used_by_column_alias , c2.column_link_url as column_link from apex_application_page_rpt_cols c , apex_application_page_rpt_cols c2 where c.application_id = c2.application_id and c.page_id = c2.page_id and c.column_alias <> c2.column_alias -- self-reference is OK and upper(c2.column_link_url) like '%#'\|\|upper(c.column_alias)\|\|'#%' order by 1,2,3,4