GML Ship Picklist

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
Blitz Report™