Quick tip: List all tabular forms

I needed to get a list of all the tabular forms in my application along with which table they were based on. This query did the trick:

select page_id
      ,attribute_02 as data_source
      ,page_name
      ,region_name
      ,attribute_03 as key_column
from   apex_application_page_proc
where  application_id = ...my app id...
and    process_type_code = 'MULTI_ROW_UPDATE'
order by 1, 2;

Comments

  1. Andreas Wismann
    21 October 2019 - 7:54 pm

    Hi Jeff,

    thanks a lot!
    However, if the “Multi Row Update” Processing was replaced with some custom PL/SQL (e.g. in a database package), the query on APEX_APPLICATION_PAGE_PROC alone would miss out on some of your Tabular Forms – in our case, all of them 🙂

    This query would find the Tabular Forms along with their base tables – if applicable:

    SELECT -- * or this essential column suggestion:
       r.workspace
      ,r.application_id
      ,r.application_name
      ,r.page_id
      ,r.page_name
      ,r.region_name
      ,r.static_id
      ,region_source
      ,p.attribute_02     AS data_source
      ,p.attribute_03     AS key_column
  FROM APEX_APPLICATION_PAGE_REGIONS r
  LEFT JOIN apex_application_page_proc p
    ON (p.workspace = r.workspace AND 
        p.application_id = r.application_id AND
        p.page_id = r.page_id AND 
        p.region_id = r.region_id AND
        p.process_type_code = 'MULTI_ROW_UPDATE')
 WHERE r.source_type = 'Tabular Form'
 ORDER BY p.application_id, p.page_id;

Leave a Reply

Your email address will not be published / Required fields are marked *