GML Bill Of Lading
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Bills Of Lading Report of OPM OP
Application: Process Manufacturing Logistics
Source: Bill Of Lading Report (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
Description: Bills Of Lading Report of OPM OP
Application: Process Manufacturing Logistics
Source: Bill Of Lading Report (XML)
Short Name: RIBOL_XML
DB package: GML_RIBOL_XMLP_PKG
select distinct lad.bol_no, hdr.orgn_code, cust.cust_name, RPAD(sy.addr1,40)|| RPAD(sy.addr2,40)|| RPAD(sy.addr3,40)|| RPAD(sy.addr4,40), sy.state_code, sy.postal_code, lad.bolship_wt, ship.shipper_name, lad.bol_um, dtl.ship_mthd from op_bill_lad lad, op_ordr_hdr hdr, op_ordr_dtl dtl, op_cust_mst cust, op_ship_mst ship, sy_addr_mst sy, ic_item_mst item, op_hold_cds hold where lad.shipper_code = ship.shipper_code and lad.bol_id = dtl.bol_id and dtl.bol_id !=0 and hdr.shipcust_id = cust.cust_id and dtl.shipaddr_id = sy.addr_id and hdr.order_id = dtl.order_id and item.item_id = dtl.item_id and hold.holdreas_code = dtl.holdreas_code and hold.shipping_ind != 1 and lad.orgn_code=:p_default_orgn &PARAM_WHERE_CLAUSE GROUP BY lad.bol_no, hdr.orgn_code, cust.cust_name, sy.addr1, sy.addr2, sy.addr3, sy.addr4, sy.state_code, sy.postal_code, lad.bolship_wt, lad.bol_um, ship.shipper_name, dtl.ship_mthd ORDER BY LAD.BOL_NO &P_SORT |
Parameter Name | SQL text | Validation | |
---|---|---|---|
From Shipment No |
|
LOV Oracle | |
To Shipment No |
|
LOV Oracle | |
Sort Order |
|
LOV Oracle |