GML Bill Of Lading

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Download
 
Related Blitz Reports
GML Ship Picklist GML Sales Order Acknowledgement GML Unallocated Orders GML Sales Order Audit Trail GML PO/Stock Return History ECC Process Manufacturing, Outside Processing Batch GML Items Received Avalara VAT listing ECC Discrete Manufacturing, Work Orders
Blitz Report™

Blitz Report™ provides multiple benefits: