GML Ship Picklist

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Ship Picklist Report of OPM OP
Application: Process Manufacturing Logistics
Source: Ship Picklist Report (XML)
Short Name: ORPLRPJ_XML
DB package: GML_ORPLRPJ_XMLP_PKG
Run GML Ship Picklist and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
GML Bill Of Lading GML Unallocated Orders GML Sales Order Audit Trail GML Sales Order Acknowledgement GML PO/Stock Return History GML Items Received ECC Process Manufacturing, Outside Processing Batch GML Unallocated Orders Report (OPM - OM) Avalara VAT listing
Blitz Report™

Blitz Report™ provides multiple benefits: