[Home] [Help]
View: JTF_IMP_PSCOMMON_VL
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PATCH_FILES.BUG_NO
, SNAP_FILES.SNAPSHOT_ID
, PATCH_FILES.APP_SHORT_NAME
, PATCH_FILES.DIRECTORY DIRECTORY
, PATCH_FILES.FILENAME FILENAME
, PATCH_FILES.VERSION NEW_VERSION
, SNAP_FILES.VERSION OLD_VERSION FROM JTF_IMP_PFILEINFO2 PATCH_FILES
, JTF_IMP_SFILEINFO_VL SNAP_FILES
FROM JTF_IMP_SFILEINFO_VL SNAP_FILES
WHERE PATCH_FILES.APP_SHORT_NAME = SNAP_FILES.APP_SHORT_NAME
AND PATCH_FILES.DIRECTORY = SNAP_FILES.DIRECTORY
AND PATCH_FILES.FILENAME = SNAP_FILES.FILENAME
Columns
Name |
BUG_NO |
SNAPSHOT_ID |
APP_SHORT_NAME |
DIRECTORY |
FILENAME |
NEW_VERSION |
OLD_VERSION |