Wednesday, 20 August 2014

To Find The Path Of FORMS AND REPORTS

 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;