Custom Objects List Query in Oracle apps (CEMLI)

1. Query to get List of Custom Concurrent Programs 

SELECT   DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",
fa.application_name,
fcp.concurrent_program_name conc_short_name,
decode( fef.execution_method_code, 'H','Host',
'I', 'PLSQL Stored Procedure',
'P', 'Report',
'L', 'SQL Loader',
'Q','SQL*Plus',
'A','Spawned',
'K','Java Concurrent Program',
'B','Request Set Stage Function',
'S','Immediate',
'J','Java Stored Procedure',
'M','Multi-Language Function',
fef.execution_method_code) "execution method",
fef.executable_name,
fcp.description "Concurrent Program Description",
fef.executable_name"Executable Name",
fef.description "Executable Description",
fef.execution_file_name ,
fcp.enabled_flag
,FCP.CREATION_DATE
    FROM fnd_executables_form_v fef,
                fnd_concurrent_programs_VL fcp,
                fnd_application_tl fa
   WHERE fcp.application_id=fef.application_id
   and fa.application_id=fcp.application_id
   AND fef.executable_id=fcp.executable_id
  AND UPPER(fcp.user_concurrent_program_name) like 'XXCUST%'
  ORDER BY 4;

2. Query to get List of Custom Form List

SELECT  DISTINCT forms.form_name,
         formstl.user_form_name,
         func.function_name,
         func.user_function_name,
         fm.menu_name,
         menu.prompt menu_prompt,
         menu.description,
         restl.responsibility_name
        -- FORMSTL.language
  FROM   fnd_form FORMS,
         fnd_form_tl FORMSTL,
         fnd_form_functions_VL FUNC,
         fnd_menu_entries_VL MENU,
         FND_MENUS FM,
         fnd_responsibility RES,
         fnd_responsibility_tl RESTL
 WHERE     1=1
         and forms.form_id = formstl.form_id
         and func.form_id = forms.form_id
         and menu.function_id = func.function_id
         and menu.menu_id=fm.menu_id
         and res.menu_id = menu.menu_id
         and res.responsibility_id = restl.responsibility_id
         and UPPER(forms.form_name) like 'XXCUST%'      
         order by 1;

3) Query to get Custom Table List

select object_name,
 object_type
from all_objects
where 1=1
and object_type='TABLE'
and status='VALID'
and object_name like 'XXCUST%';
4) Query to get Custom View List

select object_name,
 object_type
from all_objects
where 1=1
and object_type='VIEW'
and status='VALID'
and object_name like 'XXCUST%';
5)Query to get Custom plsql List

select object_name,
  object_type
from all_objects
where 1=1
and object_type IN ('FUNCTION','PACKAGE','PROCEDURE')
and status='VALID'
and object_name like 'XXCUST%'
ORDER BY 2; 6) Query to get custom List for Value set.

SELECT FLEX_VALUE_SET_NAME,
DECODE (validation_type,
                 'Y',
                 'Translatable Dependent',
                 'X',
                 'Translatable Independent',
                 'F',
                 'Table',
                 'U',
                 'Special',
                 'D',
                 'Dependent',
                 'I',
                 'Independent',
                 'N',
                 'None',
                 'P',
                 'Pair')
            validation_type,
            DESCRIPTION
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME LIKE 'XXCUST%'
ORDER BY 2;

7) Query to get List of Form Personalization

Select Distinct
A.Id,
A.Form_Name ,
A.Enabled,
C.User_Form_Name,
 D.Application_Name ,
A.Description,
Ca.Action_Type,
Ca.Enabled,
Ca.Object_Type,
ca.message_type,
ca.message_text
from FND_FORM_CUSTOM_RULES a,
     FND_FORM b,
     FND_FORM_TL c,
     Fnd_Application_Tl D,
     Fnd_Form_Custom_Actions ca
where a.form_name = b.form_name
And B.Form_Id = C.Form_Id
And B.Application_Id = D.Application_Id
And C.User_Form_Name Like 'XXCUST%'
And A.Enabled ='Y'
and a.id = ca.rule_id;