Unable to see the child inventory org in EGP_COMPONENTS_B table

We are not able to fetch the parent items for a child item using EGP_COMPONENTS_B table because it is having Master_Org_Id in PK2_VALUE instead of specific child_org_id. we are using the below query to fetch the details. Is it a data issue or we are following the wrong logic?

 

 

Query:

 

SELECT
ESIB_Parent.ITEM_NUMBER
from

EGP_COMPONENTS_B ECB,
EGP_SYSTEM_ITEMS_B ESIB_child,
EGP_STRUCTURES_B ESB1,
EGP_SYSTEM_ITEMS_B ESIB_Parent

where
ECB.PK1_VALUE = ESIB_child.INVENTORY_ITEM_ID
and ECB.PK2_VALUE = ESIB_child.ORGANIZATION_ID