select seq_usc_jit_stock.nextval,
       '1000',
       flow.wh_to_id,
       flow.material_id,
       flow.material_name,
       flow.package_units_code,
       flow.package_units_name,
       flow.material_spec,
       flow.manufacture_name,
       flow.manufacture_code,
       (select m.material_units_code from tb_usc_material m where m.material_id =  flow.material_id),
         (select material_units_name from tb_usc_material m where m.material_id =  flow.material_id),
         (select amount_per_package from tb_usc_material m where m.material_id =  flow.material_id),
       flow.batch_no,
       flow.valid_date,
       flow.barcode,
       flow.xbarcode,
       flow.quantity,
       0,
        flow.quantity,
         flow.trade_price,
       flow.location_id,
       flow.sterilized_date,
       flow.remarks,
       flow.create_date,
       'SYSTEM'
  from tb_usc_material_flow flow
  where flow_id in (

select flow.flow_id
  from tb_usc_material_flow flow
 where flow.barcode in ('17520170000015899',
                        '74920170000011069',
                        '88920170000019737',
                        '88920170000019738',
                        '04820170000015276',
                        '88920170000019739') and (flow.wh_to_id = '100441' or flow.wh_to_id = '100454' ）
  
  
  ）
/*  and flow.create_date>=to_date('01-05-2017 00:00:00', 'dd-mm-yyyy hh24:mi:ss')*/

  
  
insert into tb_usc_jit_stock (stock_id,org_id,wh_id,material_id,material_name,package_units_code,package_units_name,material_spec,manufacture_name,manufacture_code,units_code,units_name,amount_per_package,batch_no,valid_date,barcode,xbarcode,jit_stock_sum_qty,picking_qty,jit_stock_available_qty,unite_price,location_id,sterilized_date,remarks,create_date,create_by)
替换
insert into tb_usc_material_flow (NEXTVAL, '1000', WH_TO_ID, MATERIAL_ID, MATERIAL_NAME, PACKAGE_UNITS_CODE, PACKAGE_UNITS_NAME, MATERIAL_SPEC, MANUFACTURE_NAME, MANUFACTURE_CODE, (SELECTM.MATERIAL_UNITS_CODEFR, (SELECTMATERIAL_UNITS_NAMEFROM, (SELECTAMOUNT_PER_PACKAGEFROMT, BATCH_NO, VALID_DATE, BARCODE, XBARCODE, QUANTITY, 0, QUANTITY, TRADE_PRICE, LOCATION_ID, STERILIZED_DATE, REMARKS, CREATE_DATE, 'SYSTEM')