[Home] [Help]
View: FND_IMP_PSCOMMON_VL
Product: | FND - Application Object Library |
Description: | FND_IMP_PSCOMMON_VL |
Implementation/DBA Data: |
APPS.FND_IMP_PSCOMMON_VL
|
View Text
SELECT PATCH_FILES.BUG_NO
, SNAP_FILES.SNAPSHOT_ID
, PATCH_FILES.APP_SHORT_NAME
, PATCH_FILES.DIRECTORY
, PATCH_FILES.FILENAME
, PATCH_FILES.VERSION NEW_VERSION
, SNAP_FILES.VERSION OLD_VERSION
, SNAP_FILES.IS_FLAGGED_FILE
, PATCH_FILES.PATCH_ID
FROM FND_IMP_PFILEINFO2 PATCH_FILES
, FND_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 |
IS_FLAGGED_FILE |
PATCH_ID |