----------------------------------------------------------------
--- for forms 7-3-12 .
----------------------------------------------------------------
SELECT application_name
,form_name
,fft.description
FROM fnd_form ff
,fnd_form_tl fft
,fnd_application_tl fat
WHERE 1=1
--
AND ff.application_id = fft.application_id
AND ff.form_id = fft.form_id
--
AND ff.application_id = fat.application_id
--
AND form_name like 'XX%'
----------------------------------------------------------------
--- for OA Forms 7-3-12 .
----------------------------------------------------------------
SELECT ff.function_name
,user_function_name
,description
,decode(type,'JSP','OA Form',type)
type
,web_host_name
,web_agent_name
,web_html_call
,context_dependence
FROM fnd_form_functions ff
,fnd_form_functions_tl ft
WHERE 1=1
AND ff.function_id =
ft.function_id
AND type ='JSP' AND function_name like
'XX%'
----------------------------------------------------------------
--- for XML Publisher Objects 7-3-12 .
----------------------------------------------------------------
SELECT executable_name
--,meaning--fe.execution_method_code
,execution_file_name
,fcpt.user_concurrent_program_name
concurrent_program_name
,xddb.data_source_code short_code
,xddb.data_source_code
data_definition_name
--
,template_id
,xtb.template_code
,xtt.template_name
FROM xdo_ds_definitions_b xddb
,xdo_templates_b xtb
,xdo_templates_tl xtt
,fnd_concurrent_programs fcp
,fnd_concurrent_programs_tl fcpt
,fnd_executables fe
-- ,fnd_lookups
WHERE 1=1
--
AND xddb.data_source_code =
xtb.data_source_code
--
AND xddb.data_source_code =
concurrent_program_name
AND xtb.application_id =
fcp.application_id
--
AND xtb.template_code = xtt.template_code
--
AND fcp.application_id =
fcpt.application_id
AND fcp.concurrent_program_id =
fcpt.concurrent_program_id
--
AND fcp.executable_id =
fe.executable_id
--
--AND lookup_code = fe.execution_method_code
--AND xtb.application_id = 20003 --
AND xddb.application_short_name like
'%BOB%'
AND OUTPUT_FILE_TYPE = 'XML'
--AND xddb.data_source_code =
'XXBOB_TCAINTLRPT'
----------------------------------------------------------------
--- for Work Flow Objects 7-3-12 .
----------------------------------------------------------------
SELECT DISTINCT process_item_type workflow_name
FROM wf_process_activities
WHERE process_item_type LIKE 'XX%'
----------------------------------------------------------------
--- for Alerts 7-3-12 .
----------------------------------------------------------------
SELECT -- aa.application_id
application_name
,alert_id
,alert_name
,aa.description
,table_name
,sql_statement_text
FROM alr_alerts aa
,fnd_application_tl fat
WHERE 1=1
AND aa.application_id = fat.application_id
AND alert_name like '%BOB%'
----------------------------------------------------------------
--- for Work Flow Objects 9-3-12 .
----------------------------------------------------------------
SELECT concurrent_program_name
,user_concurrent_program_name
,application_short_name
FROM fnd_concurrent_programs fcp
,fnd_concurrent_programs_tl fcpt
,fnd_application fa
WHERE 1=1
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcp.application_id = fa.application_id
AND fa.application_id = fcpt.application_id
AND fcp.concurrent_program_name LIKE 'XX%'
select * from all_objects
where object_name like 'XX%R12%'
------------------------------------------------------
--- QUERY TO GET THE PROFILE
OPTIONS APPLICATION WISE.
------------------------------------------------------
SELECT fpo.profile_option_name
-- ,fpo.hierarchy_type
-- ,fpo.start_date_Active
,fat.application_short_name
FROM fnd_profile_options fpo
,fnd_application fat
WHERE 1=1
AND fpo.application_id=fat.application_id
AND profile_option_name like 'XX%'
GROUP BY fpo.profile_option_name
-- ,fpo.hierarchy_type
--,fpo.start_date_Active
,fat.application_short_name
ORDER BY 2 DESC
-----------------------------------
-- cursor for lookups styles .
-----------------------------------
SELECT fl.lookup_type
,flt.description
,flt.meaning
,fa.application_short_name
FROM fnd_lookup_types fl
,fnd_lookup_types_tl flt
,fnd_application fa
WHERE 1=1
AND fl.lookup_type = flt.lookup_type
AND fl.application_id = fa.application_id
AND fl.lookup_type LIKE 'XX%'
select * from fnd_application
SELECT fat.application_short_name
,b.lookup_type
,t.description
,t.meaning
FROM fnd_lookup_types b
,fnd_lookup_types_tl t
,fnd_application fat
WHERE 1=1
AND b.application_id=fat.application_id
AND b.security_group_id=t.security_group_id
AND b.view_application_id =
t.view_application_id
AND t.description LIKE 'XX%'
GROUP BY
fat.application_short_name
,b.lookup_type
,t.description
,t.meaning;
-------------------------------------------------
--- Descrptive flex fields .
-------------------------------------------------
select * from all_objects
where object_name like 'FND%CONT%'
select * from
fnd_descriptive_flexs_tl where DESCRIPTIVE_FLEXFIELD_NAME like '%XX%'
select * from
FND_DESCR_FLEX_CONTEXTS where DESCRIPTIVE_FLEXFIELD_NAME like '%XX%'
select * from
FND_DESCR_FLEX_CONTEXTS_tl
--DESCRIPTIVE_FLEX_CONTEXT_CODE,DESCRIPTIVE_FLEX_CONTEXT_NAME
SELECT fdf.descriptive_flexfield_name
,fdft.description
,fdfc.descriptive_flex_context_name
,fa.application_short_name
FROM fnd_descriptive_flexs fdf
,fnd_descriptive_flexs_tl fdft
,fnd_descr_flex_contexts_tl fdfc
,fnd_application fa
WHERE 1=1
AND fdf.application_id =
fdft.application_id
AND fdft.application_id =
fdfc.application_id
--
AND fdf.application_id = fa.application_id
AND fa.application_id =
fdft.application_id
AND fa.application_id =
fdfc.application_id
--
AND fdf.descriptive_flexfield_name = fdft.descriptive_flexfield_name
AND fdft.descriptive_flexfield_name =
fdfc.descriptive_flexfield_name
AND fdf.descriptive_flexfield_name
LIKE '%XX%'
---------------------------------------------------
----key flex fields .
---------------------------------------------------
SELECT fi.id_flex_structure_code
,fi.id_flex_code
,fit.description
,fa.application_short_name
FROM fnd_id_flex_structures fi
,fnd_id_flex_structures_tl fit
,fnd_application fa
WHERE 1=1
AND fa.application_id = fi.application_id
AND fi.application_id =
fa.application_id
AND fi.id_flex_code =
fit.id_flex_code
AND fi.id_flex_num =
fit.id_flex_num
AND fi.id_flex_structure_code LIKE '%BOB%'
------------
-------------------------------------
-- Reference Code .
-------------------------------------
SELECT fi.id_flex_structure_code
,fit.id_flex_structure_name
,fit.description
,fs.application_column_name
,fs.segment_name
,fa.application_short_name
FROM fnd_id_flex_structures fi
,fnd_id_flex_structures_tl fit
,fnd_id_flex_segments fs
,fnd_application fa
WHERE 1=1
AND fi.application_id =
fit.application_id
AND fit.application_id = fs.application_id
AND fi.id_flex_code =
fit.id_flex_code
AND fit.id_flex_code =
fs.id_flex_code
AND fi.id_flex_num =
fit.id_flex_num
AND fit.id_flex_num =
fs.id_flex_num
--
AND fa.application_id =
fi.application_id
AND fa.application_id =
fit.application_id
AND fa.application_id =
fs.application_id
AND fi.id_flex_structure_code LIKE '%BOB%'
and fi.id_flex_code = 'JOB'
select * from all_objects
where object_name like 'FND%ID%'
select * from FND_ID_FLEXS--
where ID_FLEX_CODE LIKE '%XX%'
select * from
FND_ID_FLEX_STRUCTURES where
ID_FLEX_STRUCTURE_CODE like '%BOB%'
select * from
FND_ID_FLEX_STRUCTURES_tl --where
ID_FLEX_STRUCTURE_CODE like '%BOB%'
select distinct id_flex_code
,a.* from FND_ID_FLEX_SEGMENTS a where
id_flex_code = 'JOB'
---------------------------------------------------
--- Concurrent Program .
---------------------------------------------------
SELECT concurrent_program_name
,user_concurrent_program_name
,application_short_name
FROM fnd_concurrent_programs fcp
,fnd_concurrent_programs_tl fcpt
,fnd_application fa
WHERE 1=1
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcp.application_id = fa.application_id
AND fa.application_id = fcpt.application_id
AND fcp.concurrent_program_name LIKE
'XX%';
---------------------------------------------------
--- value set. .
---------------------------------------------------
SELECT flex_value_set_name
,description
FROM fnd_flex_value_sets
WHERE flex_value_set_name LIKE 'XX%'
select * from all_objects
where object_name like 'FND%VALUE%'
select * from
fnd_flex_value_sets where FLEX_VALUE_SET_NAME like 'XX%'
select * from
FND_FLEX_VALUES_VL-- where FLEX_VALUE_SET_NAME like 'XX%'
---------------------------------------------------
--- value set values .
---------------------------------------------------
SELECT flex_value_set_name
,ff.flex_value_set_id
,ff.description
,ffv.flex_value_id
,ffv.flex_value
,ffvt.description
,ffvt.flex_value_meaning
FROM fnd_flex_value_sets ff
,fnd_flex_values ffv
,fnd_flex_values_tl ffvt
WHERE 1=1
AND ff.flex_value_set_id = ffv.flex_value_set_id
AND ffv.flex_value_id = ffvt.flex_value_id
AND flex_value_set_name LIKE 'XX%'
select * from FND_FLEX_VALUES
select * from
FND_FLEX_VALUES_tl
--------------------------------------
---Request Group .
--------------------------------------
SELECT frg.request_group_name
,frg.description
,fa.application_short_name
FROM fnd_request_groups frg
,fnd_application fa
WHERE frg.application_id=fa.application_id
AND request_group_name LIKE'XX%'
select * from
fnd_request_groups where request_group_name like'XX%'
select * from fnd_application
-----------------------------------------
---Responsibility .
-----------------------------------------
SELECT responsibility_key
,responsibility_name
,description
FROM fnd_responsibility fr
,fnd_responsibility_tl frt
WHERE 1=1
AND fr.application_id =
frt.application_id
AND fr.responsibility_id =
frt.responsibility_id
AND responsibility_name LIKE '%BOB%'
select * from
fnd_responsibility where application_id='20003'
select * from fnd_responsibility_tl
where RESPONSIBILITY_NAME like '%BOB%'
--------------------------------------------------
---Request set info .
--------------------------------------------------
SELECT request_set_name
,frt.description
,fa.application_short_name
FROM fnd_request_sets fr
,fnd_request_sets_tl frt
,fnd_application fa
WHERE 1=1
AND fr.application_id = frt.application_id
AND frt.application_id = fa.application_id
AND fr.request_set_id = frt.request_set_id
AND request_set_name like '%BOB%'
select * from fnd_request_sets
where REQUEST_SET_NAME like '%BOB%'
select * from fnd_application
select * from
fnd_request_sets_tl
---------------------------------------------------
---PRINTER STYLE .
---------------------------------------------------
SELECT printer_style_name
,description
FROM fnd_printer_styles a
SELECT distinct fcpt.user_concurrent_program_name "CONCURRENT PGM NAME"
,fcp.output_print_style "PRINTER STYLE"
FROM fnd_concurrent_programs_tl fcpt
,fnd_concurrent_programs fcp
WHERE
fcpt.concurrent_program_id=fcp.concurrent_program_id
AND fcpt.user_concurrent_program_name LIKE
'BOB%GL%' --'BOB%' 'XXBOB%'
GROUP BY fcpt.user_concurrent_program_name
,fcp.output_print_style
ORDER BY 1
select * from all_objects
where object_name like '%PRINT%'
select * from all_tables where
table_name like '%PRINT%'
------------------------------------------
select * from dba_source where
name like 'XX%' and type = 'PACKAGE
BODY' order by type
XXBOBHR_UTIL2_PKG
-------------------------------------------------------------
--- GL Related queries .
-------------------------------------------------------------
select * from
fnd_product_groups
select * from
hrfv_business_groups
select * from gl_sets_of_books
select * from
hr_legal_entities
select * from
hr_operating_units
select * from
org_organization_definitions
select * from gl_period_types
where user_period_type like '%BOB%'
-----------------
---Calendar Types
-----------------
SELECT PERIOD_TYPE
,NUMBER_PER_FISCAL_YEAR
,YEAR_TYPE_IN_NAME
,USER_PERIOD_TYPE
,DESCRIPTION
,PERIOD_TYPE_ID
FROM gl_period_types
WHERE 1=1
AND user_period_type LIKE '%BOB%'
---------------------------
---Calendar Accounting infn
---------------------------
SELECT PERIOD_SET_NAME calendar_name
,DESCRIPTION
,PERIOD_SET_ID
FROM GL_PERIOD_SETS
WHERE 1=1
AND PERIOD_SET_NAME LIKE '%BOB%'
-----------------------------------
-- cursor for from
personalizations
-----------------------------------
SELECT ffcr.FUNCTION_NAME,
ffcr.DESCRIPTION
FROM FND_FORM_CUSTOM_RULES ffcr;
