Description:
Query to find Custom objects , custom forms , custom form personalization , custom concurrent programs.
custom objects:
——————–
select * from dba_objects
where (upper(object_name) like ‘XX%’ or upper(OBJECT_NAME) like ‘%SICAL%’ or upper(OBJECT_NAME) like ‘%SMART%’)
and owner in (‘XXSC’)
SELECT * FROM DBA_OBJECTS WHERE OWNER=’APPS’
AND (OBJECT_NAME LIKE ‘%SICA%’
OR OBJECT_NAME LIKE ‘%XX%’)
custom forms:
—————–
select * from apps.fnd_form_vl
where form_name like ‘XX%’
custom form personalizations:
————————————
SELECT ffcr.form_name, ffft.user_function_name “User Form Name”, ffcr.SEQUENCE,
ffcr.description, ffcr.rule_type, ffcr.enabled, ffcr.trigger_event,
ffcr.trigger_object, ffcr.condition, ffcr.fire_in_enter_query,
(SELECT user_name
FROM apps.fnd_user fu
WHERE fu.user_id = ffcr.created_by) “Created By ”
FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_functions_vl ffft
WHERE ffcr.function_name = ffft.function_name
ORDER BY 1
custom concurrent programs:
————————————-
select a.APPLICATION_NAME,cgt.*,
ce.EXECUTION_FILE_NAME,DECODE(ce.EXECUTION_METHOD_CODE,’Q’,’SQLPLUS’,’P’,’Oracle Reports’,
‘I’,’PL/SQL Stored Procedure’,’L’,’SQLLOADER’,’H’,’HOST’,’A’,’SPAWNED’,’J’,’JAVA’,
‘R’,’SQLREPORT’,’X’,’Flexrpt’) EXECUTABLE_TYPE
from apps.fnd_application_tl a,
apps.fnd_concurrent_programs cg,apps.fnd_concurrent_programs_vl cgt,apps.fnd_executables ce
where
cg.CONCURRENT_PROGRAM_ID = cgt.CONCURRENT_PROGRAM_ID and
cg.APPLICATION_ID = cgt.APPLICATION_ID and
–cg.ENABLED_FLAG=’Y’ and
cg.APPLICATION_ID = a.APPLICATION_ID and
cg.EXECUTABLE_ID = ce.EXECUTABLE_ID and
a.APPLICATION_ID=50003;
