select order_name from order_table
where order_name=:Block.order_no;
But no data with that block(no data in the Base Block Table)

if i select order_number from LOV , need to display the order_name automatically

create table test2(order_no varchar2(6),order_name varchar2(20));

insert into test2 values('1001','CARS');
insert into test2 values('1002','PHONES');

-----WHEN-MOUSE-DOUBLECLICK--------

declare 
	a boolean;
begin
	a:=show_lov('lov71');
Select order_name into :block_name.order_name from test2 where order_no=:test2.order_no;
END;

IN LOV "Column Mapping properties" >>
                               column Names: order_no 
                               return item : test2.order_no
and in Record Group>>>
                "Record Group Query"
                    SELECT ALL test2.order_no FROM test2 ;

WHEN-VALIDATE-ITEM trigger on ORDER_NUMBER 

select ORDER_NAME  into :block.ORDER_NAME  from table
where ORDER_NUMBER=:=:block.ORDER_NUMBER;

and post-query at block level also