View: FND_IMP_AFFECTEDFILES_VL

Product:	FND - Application Object Library
Description:	FND_IMP_AFFECTEDFILES_VL
Implementation/DBA Data:	APPS.FND_IMP_AFFECTEDFILES_VL

View Text

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'

Columns