Find Patching details on OEM 12c [12.1.05] for all targets

Find Patching details on OEM 12c [12.1.05] for all targets:-

select a.HOST_NAME,
c.target_name,
a.HOME_NAME,
a.HOME_LOCATION,
a.COMPONENT_EXTERNAL_NAME,
a.COMPONENT_VERSION,
a.PATCH,
b.Installation_time
from
(
select HOST_NAME,
HOME_NAME,
HOME_LOCATION,
COMPONENT_EXTERNAL_NAME,
COMPONENT_VERSION,
MAX(PATCH_ID) PATCH,
SNAPSHOT_GUID
from
MGMT$SOFTWARE_COMPONENT_PATCH
where
component_name='oracle.rdbms' AND
HOST_NAME='co01mhf0025'
GROUP BY HOST_NAME,
HOME_NAME,
HOME_LOCATION,
COMPONENT_EXTERNAL_NAME,
COMPONENT_VERSION,
SNAPSHOT_GUID
) a,
MGMT$APPLIED_PATCHES b,
mgmt$target_components c,
MGMT$OH_PATCH d
where 
a.host_name=b.HOST and
a.PATCH = b.PATCH  and
a.HOME_LOCATION=b.HOME_LOCATION and
a.patch=d.patch_id and 
a.host_name=d.host_name and
a.snapshot_guid=c.snapshot_guid(+) and
a.HOME_LOCATION=c.HOME_LOCATION(+) and
a.host_name=c.host_name(+)
ORDER BY 1,7;