GML Ship Picklist

Description
Categories: BI Publisher
Columns: Line Id, Item Id, Order Id, Bol Id, Orgn Code, From Whse, Whse Name, Item Um, Item Um2, Item No ...
Application: Process Manufacturing Logistics
Source: Ship Picklist Report (XML)
Short Name: ORPLRPJ_XML
DB package: GML_ORPLRPJ_XMLP_PKG
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
Parameter Name SQL text Validation
From Shipping No
 
LOV Oracle
To Shipping No
 
LOV Oracle
From order Number
 
LOV Oracle
To order Number
 
LOV Oracle
From Ship Customer
 
LOV Oracle
To Ship Customer
 
LOV Oracle
From Warehouse
 
LOV Oracle
To Warehouse
 
LOV Oracle
From Sched. to Ship
 
Date
To Sched. to Ship
 
Date
Sort Order 1
 
LOV Oracle
orgn
 
user
 
Number
loct