INV - Inventory Cross Referencing

SELECT 
     esit.inventory_item_id, 
     esit.organization_id, 
     esib.item_number, 
     eirb.cross_reference, 
     eirb.sub_type, 
     eirb.Item_Relationship_Type, 
     eirb.item_relationship_id, 
     esit.description, 
     EIRB.UOM_CODE 
 FROM 
     egp_item_relationships_b EIRB, 
     egp_system_items_tl ESIT, 
     egp_system_items_b ESIB 
 WHERE 
     EIRB.ITEM_RELATIONSHIP_TYPE IN ('ITEM_XREF','SYS_ITEM_XREF') 
     AND ESIT.INVENTORY_ITEM_ID = EIRB.INVENTORY_ITEM_ID 
     AND ESIT.INVENTORY_ITEM_ID = ESIB.INVENTORY_ITEM_ID 
     AND ESIT.ORGANIZATION_ID = ESIB.ORGANIZATION_ID 
     AND esit.inventory_item_id = 300000001590006 
 ORDER BY 
     1,2,3,6,7;