GML Ship Picklist

SELECT
                dtl.line_id,
                dtl.item_id,
                hdr.order_id,
                dtl.bol_id,
                hdr.orgn_code,
                dtl.from_whse,
                whse.whse_name,
                ic.item_um,
                ic.item_um2,
                ic.item_no,
                dtl.line_desc,
                bol.bol_no,
                dtl.bolline_no,
                sc.cust_no,
                dtl.shipper_code,
                dtl.ship_mthd,
                dtl.sched_shipdate,
                hdr.order_no,
                dtl.line_no,
                dtl.qc_grade_wanted,
                dtl.ship_qty1,
                dtl.order_um1,
                dtl.ship_qty2,
                dtl.order_um2
            from_whse,
                whse.whse_name,
                ic.item_um,
                ic.item_um2,
                ic.item_no,
                dtl.line_desc,
                bol.bol_no,
                dtl.bolline_no,
                sc.cust_no,
                dtl.shipper_code,
                dtl.ship_mthd,
                dtl.sched_shipdate,
                hdr.order_no,
                dtl.line_no,
                dtl.qc_grade_wanted,
                dtl.ship_qty1,
                dtl.order_um1,
                dtl.ship_qty2,
                dtl.order_um2
            FROM
                op_ordr_hdr hdr,
                op_ordr_dtl dtl,
                ic_item_mst ic,
                op_cust_mst sc,
                op_bill_lad bol,
                op_hold_cds hld,
                ic_whse_mst whse
            WHERE
                 hdr.order_id = dtl.order_id
                AND hdr.order_status <> -1
                AND dtl.item_id = ic.item_id
                AND dtl.shipcust_id = sc.cust_id
                AND dtl.bol_id > 0
                AND dtl.bol_id = bol.bol_id
                AND dtl.ship_status <> 20
                AND dtl.completed_ind <> -1
                AND dtl.delete_mark = 0
                AND dtl.holdreas_code = hld.holdreas_code
                AND hld.picking_ind = 0
                AND whse.whse_code = dtl.from_whse
                &PARAM_WHERE_CLAUSE
            ORDER BY
                Hdr.order_no,
                dtl.line_no