Application Express :: Adding All Records In Report Parameter

I am trying to create a report parameter using an lov. You be able to pick one item or return All

The source for my lov is

SELECT l.extkey||' - '||l.longdescr a,  l.clocid b
from udm_cloc l, udm_cust c, udm_lde lde
where l.custid = c.custid
and c.ldeid = lde.ldeid
[code].......  

But I keep getting an error
'LOV query is invalid, a display and a return value are needed, the column names need to be different. If your query contains an in-line query, the first FROM clause in the SQL statement must not belong to the in-line query.