Duplicate Legacy Sale order during launch daily plan (no duplicate in collection)
Example data
EOA : F91
TRS type : 0E297 ESS POLY SFSV-SPH GNSGYHCFG
OPC : 0054477294
Clo30 : 5547SZ1790H8000+0850C02+000
item:
5547SZ1790H8000+0850C02+000 |
—collection
select * FROM MSC_SALES_ORDERS
where inventory_ITEM_ID = 4104978
-- and plan_id = -1
and ORGANIZATION_ID = 4434
and SR_INSTANCE_ID = 1022
order by REQUIREMENT_DATE
DEMAND_ID | SR_INSTANCE_ID | INVENTORY_ITEM_ID | ORGANIZATION_ID | DEMAND_SOURCE_TYPE | DEMAND_SOURCE_HEADER_ID | DEMAND_SOURCE_LINE | DEMAND_SOURCE_DELIVERY | DEMAND_SOURCE_NAME | PRIMARY_UOM_QUANTITY | RESERVATION_TYPE | RESERVATION_QUANTITY | COMPLETED_QUANTITY | REQUIREMENT_DATE | SUBINVENTORY | DEMAND_CLASS | PARENT_DEMAND_ID | REFRESH_NUMBER | LAST_UPDATE_DATE | LAST_UPDATED_BY | CREATION_DATE | CREATED_BY |
---|