流程卡的生成
流程卡在制造业中是一个被技术多年采用的一种管理与描述生产技术过程的一种表现形式，通过流程卡，可以很明了地体现了技术的过程，在mrpiik中，可以通过多层bom表提取通过处理后，由数据库自动生成流程卡，以下为流程卡的生成的数据库过程
create procedure pro_card
as
select parent,max(parnt_desc) as parnt_desc,
max(case component when 'wc[r]101' then comp_desc else null end) as 'wc[r]101',
max(case component when 'wc[r]102' then comp_desc else null end) as 'wc[r]102',
max(case component when 'wc[r]103' then comp_desc else null end) as 'wc[r]103',
max(case component when 'wc[r]104' then comp_desc else null end) as 'wc[r]104',
max(case component when 'wc[r]105' then comp_desc else null end) as 'wc[r]105',
max(case component when 'wc[r]106' then comp_desc else null end) as 'wc[r]106',
max(case component when 'wc[r]107' then comp_desc else null end) as 'wc[r]107',
max(case component when 'wc[r]108' then comp_desc else null end) as 'wc[r]108',
max(case component when 'wc[r]109' then comp_desc else null end) as 'wc[r]109',
max(case component when 'wc[r]10b' then comp_desc else null end) as 'wc[r]10b',
max(case component when 'wc[r]10c' then comp_desc else null end) as 'wc[r]10c',
max(case component when 'wc[r]10d' then comp_desc else null end) as 'wc[r]10d'
max(case component when 'wc[r]10e' then comp_desc else null end) as 'wc[r]10e',
