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
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
|
|
|