[Home] [Help]
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
Name |
SNAPSHOT_ID |
APP_SHORT_NAME |
DIRECTORY |
FILENAME |
VERSION |
IS_FLAGGED_FILE |