1120 1140 1160 工厂上imes

/*车间初始化*/

delete work_shop where site in ('1120', '1140', '1160');

insert into imes.work_shop

(site, work_shop, description)

select site, work_center, description

from wipdba.time_workcenter@jymes x

where wc_category = 'LEVEL4'

and site in ('1120', '1140', '1160')

order by 1, 2;

/*产线数据导入*/

delete imes.work_center where site in ('1120', '1140', '1160');

insert into imes.work_center

(site, work_center, description, cost_center, work_shop)

with a as /*产线车间关系*/

(select x.work_center, work_center_or_resource_gbo

from time_workcenter@jymes x, work_center_member@jymes wcm

where wc_category = 'LEVEL4'

and wcm.work_center_bo = x.handle),

b as

(select site

,x.work_center

,description

,nvl(value, x.work_center) costcenter_code

,nvl(a.work_center, 'NULL') work_shop

from wipdba.time_workcenter@jymes x, custom_fields@jymes cf, a

where wc_category = 'LEVEL3'

and cf.handle(+) = x.handle

and "ATTRIBUTE"(+) = 'COSTCENTER_CODE'

and x.handle = a.work_center_or_resource_gbo(+)

order by 1, 2)

select * from b where site in ('1120', '1140', '1160');