Application Process

DECLARE
  l_sql VARCHAR2(4000);
BEGIN
  l_sql :=  ' SELECT a.column_group, a.report_label'
          ||'    FROM'
          ||'   (SELECT c.column_group, c.report_label, c.column_alias, c.application_id'
          ||'         , c.page_id, c.interactive_report_id'
          ||'      FROM APEX_APPLICATION_PAGE_IR_COL c'
          ||'     WHERE c.application_id    = ' || wwv_flow.g_x01
          ||'       AND c.interactive_report_id = ' || wwv_flow.g_x02
          ||'   ) a                                                     ,'
          ||'   (SELECT REGEXP_SUBSTR(col, ''[^:]+'', 1, LEVEL) AS column_alias ,'
          ||'           LEVEL                                 AS element_no   ,'
          ||'           application_id, page_id, interactive_report_id, application_user'
          ||'      FROM'
          ||'     (SELECT ROWNUM AS id, r.REPORT_COLUMNS AS col, r.application_id, r.page_id'
          ||'           , r.interactive_report_id, r.application_user'
          ||'        FROM APEX_APPLICATION_PAGE_IR_RPT r'
          ||'       WHERE r.REPORT_TYPE                    = ''SESSION'''
          ||'         AND r.application_id                     = ' || wwv_flow.g_x01
          ||'         AND r.interactive_report_id              = ' || wwv_flow.g_x02
          ||'         AND SESSION_ID                           = ' || wwv_flow.g_x03
          ||'     ) CONNECT BY INSTR(col, '':'', 1, LEVEL-1) > 0'
          ||'   ) b'
          ||'   WHERE a.column_alias      = b.column_alias'
          ||'     AND a.application_id        = b.application_id'
          ||'     AND a.page_id               = b.page_id'
          ||'     AND a.interactive_report_id = b.interactive_report_id'
          ||'   ORDER BY b.element_no';
  apex_util.JSON_FROM_SQL(l_sql);
END;

Page Header Text

Page Footer Text