SQL query to fetch item structure and component details

Hi,

There is a requirement to fetch item structure and component details from oracle cloud. We're using below SQL query for our requirement, but it is fetching data for current as well as old and disabled components of the structure. We only need current structure data as it appears at fusion front end. Please help us with modifying below query or the new query which can help with the requirement.

SELECT DISTINCT
item.item_number Struct_Item,
item.ORGANIZATION_ID,
structb.ALTERNATE_BOM_DESIGNATOR,
compb.item_num CompSEQ,
complist.item_number Components,
compb.EFFECTIVITY_DATE
FROM
FUSION.EGP_SYSTEM_ITEMS_B item