Application Object Library

SELECT NVL (s.username, 'Internal')            username,
         NVL (s.terminal, 'None')                terminal,
         l.SID || ',' || s.serial#               KILL,
         s.audsid            ...

SET SERVEROUTPUT ON

DECLARE
   -- Change the following two parameters
   var_templatecode    VARCHAR2 (100) := 'XXTEST';            -- Template Code
   boo_deletedatadef   BOOLEAN := FALSE;
   -- del...

SELECT DISTINCT
         ffv.form_name,
         user_form_name,
         fcr.function_name,
         fff.user_function_name,
         fcr.description per_description,
         trigger_event,
        ...

SELECT fa.application_name,
         fpov.level_id,
         fa.application_short_name,
         fpo.USER_PROFILE_OPTION_NAME,
         fpo.PROFILE_OPTION_NAME,
         DECODE (fpov.level_id,
       ...

SELECT fcpl.user_concurrent_program_name,
       fcp.concurrent_program_name,
       par.end_user_column_name,
       par.form_left_prompt prompt,
       par.enabled_flag,
       par.required_flag,
  ...

SET SERVEROUTPUT ON;

DECLARE
   CURSOR c_main
   IS
      SELECT DISTINCT a.menu_id, fm.MENU_NAME
        FROM fnd_responsibility_vl a, fnd_menus fm
       WHERE     responsibility_name LIKE 'Your Re...

SELECT ffvs.flex_value_set_id,
       ffvs.flex_value_set_name,
       ffvs.description set_description,
       ffvs.validation_type,
       ffv.flex_value_id,
       ffv.flex_value,
       ffvt.flex_...

SELECT DISTINCT fcpl.user_concurrent_program_name,
                fcp.concurrent_program_name,
                fapp.application_name,
                frg.request_group_name,
                fnrtl.res...

SELECT f.user_name,
         a.request_id                                 "Req Id",
         a.concurrent_program_id                      "Prg Id",
         a.RESPONSIBILITY_ID                        ...

SELECT fcr.request_id,
            fcpt.user_concurrent_program_name
         || NVL2 (fcr.description, ' (' || fcr.description || ')', NULL)
            conc_prog,
         fu.user_name              ...

SELECT ORACLE_SESSION_ID
  FROM fnd_concurrent_requests
 WHERE request_id IN (84780821)

--
SELECT ffv.descriptive_flexfield_name  "DFF Name",
         ffv.application_table_name      "Table Name",
         ffv.title                       "Title",
         ap.application_name             ...