custom forms:
select COUNT(*) from apps.fnd_form_vl
where form_name like ‘XX%’
custom form personalization:
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
