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