VIEW: APPS.FND_IMP_SFILEINFO_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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