View: FND_IMP_PFILEINFO2_VL

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

View Text

SELECT PATCH.BUG_NO
, ALL_FILES.APP_SHORT_NAME
, ALL_FILES.DIRECTORY
, ALL_FILES.FILENAME FILENAME
, ALL_FILES.VERSION
, PATCH.PATCH_ID
FROM FND_IMP_PFILEINFO PATCH
, (SELECT F.APPLICATION_SHORT_NAME APP_SHORT_NAME
, F.LOCATION DIRECTORY
, F.NAME FILENAME
, V.VERSION VERSION
, V.FILE_VERSION_GUID FILEID
FROM FND_UMS_FILES F
, FND_UMS_FILE_VERSIONS V
WHERE F.FILE_GUID = V.FILE_GUID) ALL_FILES
WHERE PATCH.FILEID = ALL_FILES.FILEID

Columns