select 
  * 
from 
  (
    SELECT 
      gb.currency_code, 
      gcc.concatenated_segments "Chart_Of_Accounts", 
      SUM(
        nvl(gb.begin_balance_dr, 0) - nvl(gb.begin_balance_cr, 0)
      ) o...

DECLARE
l_program VARCHAR2 (200);
l_application VARCHAR2 (200);
l_enabled VARCHAR2 (200);
l_short_name VARCHAR2 (200);
l_description VARCHAR2 (200);
l_executable_short_name VARCHAR2 (200);
l_executabl...

--Supervisor Hierarchy of the employee
SELECT LEVEL,
       e.*
FROM
  (SELECT DISTINCT papf.person_id,
                   papf.employee_number,
                   papf.full_name "EMPLOYEE_FULL_NAME",...

--Sales order line status query
SELECT CASE
          WHEN     flow_status_code <> 'AWAITING_SHIPPING'
               AND flow_status_code <> 'PRODUCTION_COMPLETE'
               AND flow_status_code ...

--Query to find all Expense report entry delegations(unimportant columns are commented)
  SELECT -- dsa.web_user_id,
         -- dsa.attribute_code,
         -- dsa.attribute_application_id,
         ...

--Query to find delegate rules for APEXP workflow. change the workflow type in the query to find related delegate rules.(Unimportant columns are commented in the select statement)
SELECT routingrulese...

SELECT pha.segment1                            "PO#",
       pla.line_num || '.' || pll.shipment_num "Line-Ship#",
       pod.distribution_num                    "Distribution#",
       pll.quantity  ...

--approval limits
SELECT d.full_name,
       e.job_id,
       g.control_group_name,
       h.object_code,
       h.amount_limit,
       h.*
  FROM per_all_people_f          d,
       per_all_assignmen...

SELECT xe.event_id,
       xe.application_id,
       xe.event_type_code,
       xe.event_date,
       xe.event_number
  FROM xla.xla_transaction_entities xte, xla.xla_events xe
 WHERE     xte.source_i...

--Query to get AR invoice SLA and GL details

SELECT rct.trx_number,
       b.name        batch_name,
       h.name        journal_name,
       b.description batch_description,
       h.je_category,
 ...