Oracle EBS-SQL (OM-6):打开订单.sql
/*打开头*/update oe_order_headers_all t
set t.flow_status_code = 'BOOKED',
t.open_flag = 'Y'
where t.order_number in (530015, 530194);
-----------------------------------------------------------------
/*打开行*/：
update oe_order_lines_all t
set t.flow_status_code = 'BOOKED',
t.open_flag = 'Y'
where t.header_id in
(select header_id
from oe_order_headers_all
where order_number in (2730547, 2730617))
and t.flow_status_code <> 'CANCELLED'
--and t.line_number || '.' || t.shipment_number in (4.1, 5.1)
页:
[1]