Cancel PO修复

PO#1202019 Line 2 已被cancel  需要 退出3000pcs

 

------------1 line
insert into apps.BMC_PO_LINE_LOCATIONS_ALL_BAK1
select * from apps.po_line_locations_all where po_header_id= 363750  and po_line_id=1375835 and  LINE_LOCATION_ID= 3226781
 
update apps.po_line_locations_all set CANCEL_FLAG=null ,CANCEL_DATE=null, CANCELLED_BY=null,CANCEL_REASON=null,QUANTITY_CANCELLED=0
where po_header_id= 363750  and po_line_id=1375835 and  LINE_LOCATION_ID= 3226781

 

------------1 line
insert into apps.BMC_PO_DISTRIBUTIONS_ALL_BAK1
select * from apps.PO_DISTRIBUTIONS_ALL where po_header_id= 363750  and po_line_id=1375835 and  LINE_LOCATION_ID= 3226781 and PO_DISTRIBUTION_ID= 3187583

 

update apps.PO_DISTRIBUTIONS_ALL set QUANTITY_CANCELLED=0,GL_CANCELLED_DATE=null
where po_header_id= 363750  and po_line_id=1375835 and  LINE_LOCATION_ID= 3226781 and PO_DISTRIBUTION_ID= 3187583