VIEW: APPS.FND_IMP_PSNEW_VL

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)