以Vision Demo库的Assembly Item:75100021为例(这个Item为摩托车组装成品物料)
Query1:Sql query to print BOM hierarchy for a given assembly item
select level,bill_item_name,assembly_item_id,component_item_name, component_item_id
from apps.bomfg_bom_components
start with bill_item_name = '75100021' --Replace your assembly_item_id to here
connect by prior component_item_name = bill_item_name;
Output:
LEVEL |