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,
...---SLA entries not transferred to GL
SELECT h.ledger_id,
l.ae_header_id,
h.accounting_date,
h.period_name,
h.entity_id,
l.gl_sl_link_id,
l.gl_sl_link_table,
...--Run below query to check if the java class is compiled successfully and is valid.
SELECT *
FROM dba_objects
WHERE object_type IN ('JAVA SOURCE')
and object_name like '%TEST_JAVA_PKG%';
--Run belo...