This dictionary view allows access to this information, which you can use to source APEX components.
select application_id, page_id, item_name, display_as, item_help_text
How would I make it 'active' and put the SQL statement into the Column Attribute Help Text field. I tried adding the fields to the Attribute Dictionary but don't see a way to map Displayed Items to Displayed Report Columns. I added the help on the DML form and want it to appear on the Report page of the interactive report.
Such as ## select item_help_text from APEX_APPLICATION_PAGE_ITEMS where application_id = 10242 and page_id = 2 and item_name = 'P2_APP_MNM_CD'##