Application Object Library

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",...

--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...

--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...

SELECT SUBSTR (a.OWNER, 1, 20),
         SUBSTR (a.NAME, 1, 30),
         SUBSTR (a.TYPE, 1, 20),
         SUBSTR (u.status, 1, 10) Stat,
         u.last_ddl_time,
         SUBSTR (text, 1, 80)   Desc...

--Query to list all pages under any top/directory
set serveroutput on;
DECLARE
BEGIN
   jdr_utils.listdocuments ('/oracle/apps/per', TRUE);
END;



Query to list all customizations on a OAF page



--...

SELECT rs.user_request_set_name        "Set Name",
       rs.request_set_name             "Set code",
       rs.description                  "Description",
       rss.display_sequence            stage...

SELECT LPAD (' ', 10 * (LEVEL - 1)) || org.name hierarchy,
                  org.organization_id
             FROM hr_all_organization_units org, per_org_structure_elements pose
            WHERE 1 = ...

SELECT fsrn.program,
       fsrn.request_id, -- fstr.concurrent_program_id,
fstr.program incompatible_program,
                                                      fstr.request_id incompatible_prog_r...

SELECT DISTINCT rtl.responsibility_name,
                ff.function_name,
                ffl.user_function_name,
                usr.user_name
  FROM fnd_compiled_menu_functions cmf,
       fnd_form...

SELECT fu.user_name            "User Name",
         frt.responsibility_name "Responsibility Name",
         furg.start_date         "Start Date",
         furg.end_date           "End Date",
        ...