X2-300电商平台订单表关联关系

--- Ec订单主表

SELECT * from  x3_ec_order_core  where platform_bills_id='894077742001259'

--- Ec订单明细表   core和core_sub 关联字段：platformType、platformBillsId

SELECT * from  x3_ec_order_core_sub  where platform_bills_id='894077742001259'

--- Ec订单数量控制表  关联字段: sub.systemId = control.systemId

SELECT * from  x3_order_nums_control  where system_id='Weimob.894077742001259.128826597156053.1'

--- Ec订单明细扩展表  关联字段: sub_ext.systemId = sub.systemId

SELECT * from  x3_ec_order_core_sub_ext where system_id='Weimob.894077742001259.128826597156053.1'

--- Ec订单明细履约计划扩展表  ext.systemId = sub.systemId

SELECT * from  x3_ec_order_core_sub_perf_ext where system_id='Weimob.894077742001259.128826597156053.1

--- 批量删除全部关联单据

--- 批量删除所有信息
declare
	var_bills_id varchar2(100);
begin

--- 定义要删除的订单编号
SELECT '894077742001259'  into  var_bills_id FROM dual;

--- 删除主单
execute immediate 'delete from x3_ec_order_core where platform_bills_id =:var_bills_id' using var_bills_id;

--- 删除数量控制
execute immediate 'delete from x3_order_nums_control where system_id in(  SELECT system_id from  x3_ec_order_core_sub  where platform_bills_id=:var_bills_id )' using var_bills_id;

--- 删除明细扩展表
execute immediate 'delete from x3_ec_order_core_sub_ext where system_id in(  SELECT system_id from  x3_ec_order_core_sub  where platform_bills_id=:var_bills_id )' using var_bills_id;

--- 删除明细履约计划扩展表
execute immediate 'delete from x3_ec_order_core_sub_perf_ext where system_id in(  SELECT system_id from  x3_ec_order_core_sub  where platform_bills_id=:var_bills_id )' using var_bills_id;

--- 删除明细表 
execute immediate 'delete from x3_ec_order_core_sub where platform_bills_id =:var_bills_id ' using var_bills_id;

end;
/