Script to find components installed for database.

SELECT DISTINCT d.pack_display_label pack_name, NVL2(l.pack_name,'YES','NO') license FROM mgmt_admin_licenses l, mgmt_license_definitions d 
WHERE d.pack_label = l.pack_name(+) 
ORDER BY d.pack_display_label;