Use below queries to get all programs with specific default value, set as parameter value. i.e. You know default value and need to search programs using it
This is useful to find programs having paths defaulted
--- Query to get default parameters for all concurrent programs
SELECT fcp.user_concurrent_program_name, fcp.concurrent_program_name,
fdfcu.end_user_column_name, fdfcu.DEFAULT_VALUE
FROM fnd_descr_flex_column_usages fdfcu, fnd_concurrent_programs_vl fcp
WHERE fcp.concurrent_program_name =
REPLACE (fdfcu.descriptive_flexfield_name, '$SRS$.')
AND fdfcu.DEFAULT_VALUE LIKE '/opt/apps%'
-- Query to get default parameters for all concurrent request sets
SELECT frsv.user_request_set_name, frspa.descriptive_flexfield_name,
fdfcu.end_user_column_name, frspa.DEFAULT_VALUE
FROM fnd_request_set_program_args frspa,
fnd_request_sets_vl frsv,
fnd_descr_flex_column_usages fdfcu
WHERE 1 = 1
AND frspa.DEFAULT_VALUE LIKE '/opt%'
AND frspa.request_set_id = frsv.request_set_id
AND fdfcu.descriptive_flexfield_name = frspa.descriptive_flexfield_name
AND frspa.application_column_name = fdfcu.application_column_name
This is useful to find programs having paths defaulted
--- Query to get default parameters for all concurrent programs
SELECT fcp.user_concurrent_program_name, fcp.concurrent_program_name,
fdfcu.end_user_column_name, fdfcu.DEFAULT_VALUE
FROM fnd_descr_flex_column_usages fdfcu, fnd_concurrent_programs_vl fcp
WHERE fcp.concurrent_program_name =
REPLACE (fdfcu.descriptive_flexfield_name, '$SRS$.')
AND fdfcu.DEFAULT_VALUE LIKE '/opt/apps%'
-- Query to get default parameters for all concurrent request sets
SELECT frsv.user_request_set_name, frspa.descriptive_flexfield_name,
fdfcu.end_user_column_name, frspa.DEFAULT_VALUE
FROM fnd_request_set_program_args frspa,
fnd_request_sets_vl frsv,
fnd_descr_flex_column_usages fdfcu
WHERE 1 = 1
AND frspa.DEFAULT_VALUE LIKE '/opt%'
AND frspa.request_set_id = frsv.request_set_id
AND fdfcu.descriptive_flexfield_name = frspa.descriptive_flexfield_name
AND frspa.application_column_name = fdfcu.application_column_name
No comments:
Post a Comment