   SELECT  i.orno, i.oino, 
	to_char(i.quant)||' '||units Amount,
	rpad(i.dform,4) form, rest Restrict,status, 
	to_char(i.acted,'MM/DD/YYYY') When,
	c.coop Source, 
	i.cmt,
	i.userid, 
	to_char(i.created, 'MM/DD/YYYY') Created, 
	to_char(i.modified, 'MM/DD/YYYY') Modified 
	FROM prod.oi i, prod.coop c 
	WHERE i.ivid = '1868838' AND c.cno(+) = i.cno
	ORDER BY orno desc
