| | |
|---|
| | | process_number,work_center,department, |
|---|
| | | plan_start_day,plan_end_day,next_process_deparment, |
|---|
| | | is_suspended,is_outsourcing,account, |
|---|
| | | id,create_time,del_flag,plant,order_status,std_op,plan_type,op_status,next_op_name |
|---|
| | | id,create_time,del_flag,plant,order_status,std_op,op_status,next_op_name,plan_type |
|---|
| | | ) |
|---|
| | | select |
|---|
| | | doc_no,mainitem_code,mainitem_figure, |
|---|
| | |
|---|
| | | start_date,complete_date,next_dept, |
|---|
| | | is_hold_release,is_out_source,org_code, |
|---|
| | | order_id,now(),'0',org_code,doc_status,std_op,op_status,next_op_name, |
|---|
| | | case when substr(mainitem_code,3)='A65' then 'gas' else 'piping' end as plan_type |
|---|
| | | case when substr(mainitem_code,0,4)='A65' then 'gas' else 'piping' end as plan_type |
|---|
| | | from aps_work_order_job |
|---|
| | | where ( doc_status in (0,1,2,4) and is_hold_release='0' |
|---|
| | | and (mainitem_code like 'A65%' or mainitem_code like 'W%')); |
|---|
