[Home] [Help]
View: FND_IMP_PSNEW_VL
Product: | FND - Application Object Library |
Description: | FND_IMP_PSNEW_VL |
Implementation/DBA Data: |
APPS.FND_IMP_PSNEW_VL
|
View Text
SELECT PATCH_FILES.BUG_NO
, SNAP_IDS.SNAPSHOT_ID
, PATCH_FILES.APP_SHORT_NAME
, PATCH_FILES.DIRECTORY
, PATCH_FILES.FILENAME
, PATCH_FILES.VERSION NEW_VERSION
, NULL IS_FLAGGED_FILE
, PATCH_FILES.PATCH_ID
FROM FND_IMP_PFILEINFO2 PATCH_FILES
, (SELECT DISTINCT SNAPSHOT_ID
FROM AD_SNAPSHOTS) SNAP_IDS
WHERE (PATCH_FILES.APP_SHORT_NAME
, PATCH_FILES.DIRECTORY
, PATCH_FILES.FILENAME) NOT IN (SELECT SNAP_FILES.APP_SHORT_NAME
, SNAP_FILES.DIRECTORY
, SNAP_FILES.FILENAME
FROM FND_IMP_SFILEINFO_VL SNAP_FILES
WHERE SNAP_FILES.SNAPSHOT_ID = SNAP_IDS.SNAPSHOT_ID)
Columns
Name |
BUG_NO |
SNAPSHOT_ID |
APP_SHORT_NAME |
DIRECTORY |
FILENAME |
NEW_VERSION |
IS_FLAGGED_FILE |
PATCH_ID |