Software Deployment

I can get all patches loaded on a device from ORG1.Software

SELECT MACHINE.NAME, SOFTWARE.DISPLAY_NAME
FROM ORG1.SOFTWARE 
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE IS_PATCH = 1 AND YEAR(ORG1.SOFTWARE.CREATED) = '2016' AND MACHINE.NAME = ‘device_name’
ORDER BY INSTALL_DATE DESC


I can get recent patches from KBSYS.PATCHLINK_PATCH

SELECT M.NAME, PP.TITLE
FROM ORG1.PATCHLINK_MACHINE_STATUS MS
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID 
WHERE M.NAME = 'device_name'
ORDER BY PP.TITLE

But how can they be associated or they are just in different scope ?