各位大哥幫我看看這個展開BOM的存礎過程為什么只能展開一層

wh991327

定義個變量v_seq
加個cursor
cursor c_1(p_itemid number) select bom.bill_sequence_id from BOM_BILL_OF_MATERIALS BOM
where bom.assembly_item_id = p_itemid and organization_id = p_org_id;
在
LCTQ_WIP003_PROC(
CI.BILL_SEQUENCE_ID,
P_ORG_ID,
CI.COMPONENT_ITEM_ID,
CI.COMPONENT_QUANTITY,
P_LEVEL_TO_TOP+1);
前面加入以下代碼
open c_1;
FETCH c_1 into v_seq;
close c_q;
if v_seq is not null then
LCTQ_WIP003_PROC(
v_seq,
P_ORG_ID,
CI.COMPONENT_ITEM_ID,
CI.COMPONENT_QUANTITY,
P_LEVEL_TO_TOP+1);
end if;

試試看 沒調試過的瞎寫的