VIEW: APPS.FND_IMP_AFFECTEDFILES_VL

Source

View Text - Preformatted

SELECT a.bug_no, r.snapshot_id, p.app_short_name dep_app_short_name, p.file_directory dep_directory, p.filename dep_filename, a.app_short_name patched_app_short_name, a.directory patched_directory, a.filename patched_filename, a.typeid, 'Recompile' action_required, 0 objects_affected, 'null' object_type, a.patch_id from fnd_IMP_PSMaster2 a, fnd_IMP_depobjects p, fnd_IMP_deprelations r where a.snapshot_id = r.snapshot_id and r.dependency_type = 'JSP_INCLUDE' and r.child_object_name = a.directory || '/' || a.filename and r.child_app_short_name = a.app_short_name and p.object_id = r.parent_object_id and a.typeid <> 'not applied' and a.file_type = 'jsp'

View Text - HTML Formatted

SELECT A.BUG_NO
, R.SNAPSHOT_ID
, P.APP_SHORT_NAME DEP_APP_SHORT_NAME
, P.FILE_DIRECTORY DEP_DIRECTORY
, P.FILENAME DEP_FILENAME
, A.APP_SHORT_NAME PATCHED_APP_SHORT_NAME
, A.DIRECTORY PATCHED_DIRECTORY
, A.FILENAME PATCHED_FILENAME
, A.TYPEID
, 'RECOMPILE' ACTION_REQUIRED
, 0 OBJECTS_AFFECTED
, 'NULL' OBJECT_TYPE
, A.PATCH_ID
FROM FND_IMP_PSMASTER2 A
, FND_IMP_DEPOBJECTS P
, FND_IMP_DEPRELATIONS R
WHERE A.SNAPSHOT_ID = R.SNAPSHOT_ID
AND R.DEPENDENCY_TYPE = 'JSP_INCLUDE'
AND R.CHILD_OBJECT_NAME = A.DIRECTORY || '/' || A.FILENAME
AND R.CHILD_APP_SHORT_NAME = A.APP_SHORT_NAME
AND P.OBJECT_ID = R.PARENT_OBJECT_ID
AND A.TYPEID <> 'NOT APPLIED'
AND A.FILE_TYPE = 'JSP'