Query: ons_notification_topic_subscription

select
  endpoint as "Endpoint",
  s.lifecycle_state as "State",
  protocol as "Protocol"
from
  oci_ons_notification_topic t
  left join oci_ons_subscription as s on s.topic_id = t.topic_id
where
  t.topic_id = $1;