删除某个订单的某Item

renzhuoren

Insert into oe_lines_iface_all
  (org_id,
   line_id,
   ordered_quantity,
   orig_sys_document_ref,
   orig_sys_line_ref,
   order_source_id,
   change_sequence,
   created_by,
   creation_date,
   last_update_date,
   last_updated_by,
   operation_code,
   change_reason)
values
  (v_line.org_id,
   v_line.line_id,
   0,
   v_line.orig_sys_document_ref,
   v_line.orig_sys_line_ref,
   v_line.order_source_id,
   nvl(j.change_sequence, 0) + 1,
   vUserId,
   trunc(sysdate),
   trunc(sysdate),
   vUserId,
   'UPDATE',
   'CUSTOMER CHANGE');

Insert into oe_headers_iface_all
  (orig_sys_document_ref,
   org_id,
   header_id,
   order_source_id,
   change_sequence,
   operation_code,
   created_by,
   creation_date,
   last_update_date,
   last_updated_by)
values
  (i.orig_sys_document_ref,
   i.org_id,
   i.header_id,
   i.order_source_id,
   nvl(i.change_sequence, 0) + 1,
   'UPDATE',
   vUserId,
   trunc(sysdate),
   trunc(sysdate),
   vUserId);