Reports2017-11-18T12:27:27+00:00

GML Bill Of Lading

Description
Categories: BI Publisher, Manufacturing
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
user
 
Number
orgn
 
Sort Order
 
LOV Oracle
To Shipment No
 
LOV Oracle
From Shipment No
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept