GML Bill Of Lading

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