Validation Script For Migrated Objects - Oracle EBS

 DBA objects :
select * from dba_objects where object_name like '%XX_TEST%';

Lookup : 
SELECT * FROM apps.fnd_lookup_values
            WHERE lookup_type in( 'XX_LOOKUP_NAME')
            and enabled_flag = 'Y'
            AND language = 'US';

Value set (with table validation) :
 select *
from apps.fnd_flex_value_sets fs, apps.fnd_flex_validation_tables fv
where FLEX_VALUE_SET_NAME in ('XX_VALUESET_NAME')
-- and fv.FLEX_VALUE_ID = fvt.FLEX_VALUE_ID
-- and language = 'US'
and fv.FLEX_VALUE_SET_ID = fs.FLEX_VALUE_SET_ID
;    
  
Value set values:  
select fv.FLEX_VALUE, fvt.FLEX_VALUE_MEANING, fvt.DESCRIPTION
from apps.fnd_flex_value_sets fs,apps.fnd_flex_values fv  ,
  apps.fnd_flex_values_tl fvt
where FLEX_VALUE_SET_NAME in ('XX_VALUESET_NAME')
and fv.FLEX_VALUE_ID = fvt.FLEX_VALUE_ID
and language = 'US'
and fv.FLEX_VALUE_SET_ID = fs.FLEX_VALUE_SET_ID; 

Executables:
select * from apps.fnd_executables where EXECUTABLE_NAME like 'XXEXE_NAME';

Concurrent programs :
select * from APPS.fnd_concurrent_programs 
where CONCURRENT_PROGRAM_NAME in ('XX_CONC_PROG_NAME')
order by CONCURRENT_PROGRAM_ID desc;

Request group for conc prog : 
Select fcpt.CONCURRENT_PROGRAM_NAME ,
frg.request_group_name 
From
apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_concurrent_programs fcpt
Where  fcpt.concurrent_program_id = frgu.request_unit_id
and frgu.request_group_id = frg.request_group_id
and CONCURRENT_PROGRAM_NAME in ('XX_CONC_PROG_NAME')
Order By 2;

Conc. Programs parameters:
SELECT DISTINCT fcpl.user_concurrent_program_name "Concurrent Program Name",
  fcp.concurrent_program_name "Short Name"                                 ,
  fat.application_name                                                     ,
  fl.meaning execution_method                                              ,
  fe.execution_file_name                     ,
  fcp.output_file_type                                                     ,
  fdfcuv.column_seq_num "Column Seq Number"                                ,
  fdfcuv.end_user_column_name "Parameter Name"                             ,
  fdfcuv.form_left_prompt "Prompt"                                         ,
  fdfcuv.enabled_flag " Enabled Flag"                                      ,
  fdfcuv.required_flag "Required Flag"                                     ,
  fdfcuv.display_flag "Display Flag"                                       ,
  fdfcuv.flex_value_set_id "Value Set Id"                                  ,
  ffvs.flex_value_set_name "Value Set Name"                                ,
  flv.meaning "Default Type"                                               ,
  fdfcuv.default_value "Default Value"
FROM apps.fnd_concurrent_programs fcp ,
  apps.fnd_concurrent_programs_tl fcpl   ,
  apps.fnd_descr_flex_col_usage_vl fdfcuv,
  apps.fnd_flex_value_sets ffvs          ,
  apps.fnd_lookup_values flv             ,
  apps.fnd_lookups fl                    ,
  apps.fnd_executables fe                ,
  apps.fnd_executables_tl fet            ,
  apps.fnd_application_tl fat
  WHERE 1                     = 1
AND fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcp.enabled_flag          = 'Y'
AND  CONCURRENT_PROGRAM_NAME in ('XX_CONC_PROG_NAME')
AND fdfcuv.descriptive_flexfield_name = '$SRS$.'
  || fcp.concurrent_program_name
AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
AND flv.lookup_type(+)     = 'FLEX_DEFAULT_TYPE'
AND flv.lookup_code(+)     = fdfcuv.default_type
AND fcpl.language          = 'US'
AND flv.language(+)        = 'US'
AND fl.lookup_type         ='CP_EXECUTION_METHOD_CODE'
AND fl.lookup_code         =fcp.execution_method_code
AND fe.executable_id       = fcp.executable_id
AND fe.executable_id       =fet.executable_id
AND fet.language           = 'US'
AND fat.application_id     =fcp.application_id
AND fat.language           = 'US'
ORDER BY CONCURRENT_PROGRAM_NAME;

Executables :
select * from APPS.fnd_executables where EXECUTABLE_NAME in ('XX_EXE_NAME');

Templates :
select * from XDO.xdo_templates_tl where TEMPLATE_CODE = 'XX_TEMPLATE_CODE';

Data definition :
select * from XDO.xdo_ds_definitions_tl where DATA_SOURCE_CODE = 'XX_CODE'  ;

XDO attachments :
select * from apps.XDO_LOBS where file_name like 'XX_FILE_NAME%';

Form function :
select * from apps.fnd_form_functions_vl where USER_FUNCTION_NAME = 'XX_FORM_FUN' ;