SELECT af.app_short_name "Application" ,
af.filename "File Name" ,
afv.VERSION "File Version" ,
NVL (aap.patch_name, 'Default Installation') "Patch Number",
'$'
|| fa.basepath
|| '/'
|| af.subdir "Location"
FROM apps.ad_files af ,
apps.ad_patch_run_bug_actions apa,
apps.ad_patch_run_bugs aprb ,
apps.ad_patch_runs apr ,
apps.ad_patch_drivers apd ,
apps.ad_applied_patches aap ,
apps.ad_file_versions afv ,
apps.fnd_application fa
WHERE af.filename = 'INVTOMAI.fmb' -- 'OEXWFASG.rdf'
AND af.file_id = apa.file_id(+)
--AND apa.common_action_id(+) = 4042
AND apa.patch_run_bug_id = aprb.patch_run_bug_id(+)
AND aprb.patch_run_id = apr.patch_run_id(+)
AND apr.patch_driver_id = apd.patch_driver_id(+)
AND apd.applied_patch_id = aap.applied_patch_id(+)
AND af.file_id = afv.file_id
AND af.app_short_name = fa.application_short_name
GROUP BY aap.patch_name,
af.filename ,
afv.VERSION ,
af.app_short_name ,
af.file_id ,
af.subdir ,
fa.basepath;
af.filename "File Name" ,
afv.VERSION "File Version" ,
NVL (aap.patch_name, 'Default Installation') "Patch Number",
'$'
|| fa.basepath
|| '/'
|| af.subdir "Location"
FROM apps.ad_files af ,
apps.ad_patch_run_bug_actions apa,
apps.ad_patch_run_bugs aprb ,
apps.ad_patch_runs apr ,
apps.ad_patch_drivers apd ,
apps.ad_applied_patches aap ,
apps.ad_file_versions afv ,
apps.fnd_application fa
WHERE af.filename = 'INVTOMAI.fmb' -- 'OEXWFASG.rdf'
AND af.file_id = apa.file_id(+)
--AND apa.common_action_id(+) = 4042
AND apa.patch_run_bug_id = aprb.patch_run_bug_id(+)
AND aprb.patch_run_id = apr.patch_run_id(+)
AND apr.patch_driver_id = apd.patch_driver_id(+)
AND apd.applied_patch_id = aap.applied_patch_id(+)
AND af.file_id = afv.file_id
AND af.app_short_name = fa.application_short_name
GROUP BY aap.patch_name,
af.filename ,
afv.VERSION ,
af.app_short_name ,
af.file_id ,
af.subdir ,
fa.basepath;