GML PO/Stock Return History

SELECT
	rh.orgn_code, 
	rh.return_no,
	rh.return_date,
	vm.vendor_no,
	rh.shipper_code, 
	rd.line_no,
	rd.item_id,
	LTRIM(RTRIM(rd.RMA)) RMA1,
	rd.return_code,
	reas.reason_desc1,
	rd.reorder_ind, 
	rd.return_qty1,
	rd.return_qty2, 
	rd.return_um1,
	rd.return_um2, 
	rcvh.recv_no, 
	rcvd.line_no  recvline_no,
	rcvd.recv_qty1, 
	rcvd.recv_qty2, 
	rcvd.recv_um1,
	rcvd.recv_um2, 
	ordh.po_no,
	ordd.line_no  poline_no,
	ordd.order_qty1,
	ordd.order_qty2,
	ordd.order_um1,
	ordd.order_um2,
	tp.lot_id,
	tp.whse_code, 
	tp.location,
	tp.trans_qty*(-1)  trans_qty, 
	tp.trans_qty2*(-1)  trans_qty2,
	tp.trans_um, 
	tp.trans_um2,
	im.item_no, 
	rd.line_id,
	lm.lot_no,
	lm.sublot_no
FROM
	po_rtrn_hdr      rh,
	po_rtrn_dtl       rd, 
	ic_tran_pnd     tp, 
	ic_item_mst      im, 
	po_vend_mst   vm,                  
	ic_lots_mst       lm,
	po_recv_hdr     rcvh,
	po_recv_dtl      rcvd,
	po_ordr_hdr      ordh,
	po_ordr_dtl       ordd	,
	sy_reas_cds     reas 
WHERE        	
		rh.return_id = rd.return_id     
	and	lm.lot_id(+) = tp.lot_id
	and 	lm.item_id(+)  =  tp.item_id
	and	rh.delete_mark = 0 
	and	tp.doc_type = 'RTRN' 
	and	tp.delete_mark = 0 
	and	rd.return_id = tp.doc_id 
	and	rd.line_id = tp.line_id 
	and	rd.item_id = im.item_id 
	and	rh.return_vendor_id = vm.vendor_id (+) 
	and	rcvd.line_id = rd.recvline_id
	and	rcvh.recv_id  =  rd.recv_id
	and 	reas.reason_code(+)  =  rd.return_code 
	and	ordd.line_id(+)  =   rd.poline_id
	and	ordh.po_id(+)  =  rd.po_id
	&PARAM_WHERE_CLAUSE
ORDER BY
	rh.return_no,rd.line_no