Help with query to pull Spoke System Items for a given item

Hi,

I need to create a query to pull all "Spoke System" linked to a item.

A have tried the query below, however if won't work because the source_system_id on EGP_ITEM_RELATIONSHIPS_B is NULL.

Looking at the item in Fusion, I can see it has 3 Spoke System.

Would someone please advise?

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT esil.item_number item_num
     , SUBSTR(esil.description, 1, 30) item_descr
     , esil.item_type
     , hos.orig_system AS spoke_system
     , eir.cross_reference AS spoke_system_item
  FROM egp_system_items_vl       esil