递归查询T100的BOM

128 阅读 0 评论 85 点赞

我是靠谱客的博主洁净小懒虫，这篇文章主要介绍递归查询T100的BOM，现在分享给大家，希望可以做个参考。

举例鼎捷T100递归查询BOM

递归过程条件没有加完整，需要根据实际改一改用。

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
select DISTINCT
level L,
bmba001 主件,bmba003 元件,bmba011 元件数量,bmba010 单位，bmba012 主件底数,Z.imaa004 元件属性
,X.imaa004 主件属性,X.imaa003
from bmba_t
left join imaa_t Z on Z.imaa001=bmba003 and Z.imaaent=15
left join imaa_t
X on X.imaa001=bmba001 and X.imaaent=15
LEFT JOIN bmaa_t ON BMAA001=BMBA001 AND BMAAENT=BMBAENT AND BMBASITE=BMBASITE
WHERE BMBAENT=15
--据点 :ENT
AND BMBASITE='ALL' --:SITE
AND
(bmba006 is null or bmba006< to_date(to_char(sysdate,'yyyymmdd'),'yyyymmdd')) ---失效日
AND BMAASTUS='Y' ---
-- start with bmba003= '12354534AA'
connect by
bmba003=prior bmba001
----上展
start with bmba001= '12354534AA'
connect by
bmba001=prior bmba003
----下展
and
bmbaent=15 and bmbasite='ALL'
and bmaaent=15 and bmaasite='ALL'
order by L