标准展BOM语句

 SELECT distinct LEVEL, bprod, bchld, bqreq
  FROM mbm
  START WITH bprod = '9J.J1B77.B5A'
  AND bid = 'BM'
  AND bdeff <= 20061230
  AND bddis >= 20061230
  CONNECT BY PRIOR bchld = bprod
  and bid = 'BM'
  AND bdeff <= 20061230
  AND bddis >= 20061230
  ORDER BY LEVEL, bprod, bchld