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