SELECT C.BUG_NO , C.SNAPSHOT_ID , C.APP_SHORT_NAME , C.DIRECTORY , C.FILENAME , C.TYPEID , C.NEW_VERSION , C.OLD_VERSION , (SELECT COUNT(*) FROM JTF_IMP_SFILEDEP S WHERE S.DEP_FILENAME = C.FILENAME AND S.DEP_DIRECTORY = C.DIRECTORY AND S.DEP_APP_SHORT_NAME = C.APP_SHORT_NAME) FILES_AFFECTED FROM JTF_IMP_PSMASTER_VL C FROM JTF_IMP_SFILEDEP S