View: FND_IMP_SFILEINFO_VL

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

View Text

SELECT S.SNAPSHOT_ID
, F.APP_SHORT_NAME
, F.SUBDIR DIRECTORY
, F.FILENAME FILENAME
, V.VERSION
, F.IS_FLAGGED_FILE
FROM AD_SNAPSHOT_FILES S
, AD_FILES F
, AD_FILE_VERSIONS V
WHERE S.FILE_ID = F.FILE_ID
AND S.FILE_VERSION_ID = V.FILE_VERSION_ID

Columns