GML Ship Picklist

Description
Categories: BI Publisher, Manufacturing
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
loct
 
user
 
Number
orgn
 
Sort Order 1
 
LOV Oracle
To Sched. to Ship
 
Date
From Sched. to Ship
 
Date
To Warehouse
 
LOV Oracle
From Warehouse
 
LOV Oracle
To Ship Customer
 
LOV Oracle
From Ship Customer
 
LOV Oracle
To order Number
 
LOV Oracle
From order Number
 
LOV Oracle
To Shipping No
 
LOV Oracle
From Shipping No
 
LOV Oracle
Ask a question