Untitled
unknown
plain_text
a year ago
1.8 kB
2
Indexable
Never
select * , case when tbldash.pallet_number <> '' then tbldash.overall_weight else fg.weight_per_lot end as 'weight' , case when tbldash.pallet_number <> '' then tbldash.overall_volume else fg.width_per_lot * fg.length_per_lot * fg.height_per_lot end as 'volume' , fgkr.criteria from ( select plt.pallet_number, plt.overall_weight, plt.overall_volume, temp.part_supply, temp.part_demand, temp.warehouse_code from artemis_temporary.wo_req_temporaries as temp left join pallets plt on plt.id = temp.pallet_id ) tbldash left join artemis_prd.finished_goods fg on fg.part_supply = tbldash.part_supply and fg.part_demand = tbldash.part_demand and tbldash.pallet_number = '' left join warehouses ware on ware.warehouse_code = tbldash.warehouse_code and ware.start_effective <= '2023/05/11' and (ware.end_effective >= '2023/05/11' or ware.end_effective is null) left join artemis_prd.finished_goods fgkr on fgkr.part_supply = tbldash.part_supply and fgkr.part_demand = tbldash.part_demand