1367: ood.ship_qty2,
1368: ood.alloc_qty
1369: from
1370: op_ordr_hdr ooh, 1371: op_ordr_dtl ood 1372: where
1373: ooh.order_id = ood.order_id
1374: and (c_from_shipdate is NULL or
1375: ( (ood.sched_shipdate between c_from_shipdate and c_to_shipdate)