If user select "ALL" from the lov no need to append the above condition in the where clause.
current_req_status = :block1.req_status
Edited by: roots on Apr 10, 2012 9:31 AM
select request_id,doc_name,doc_code,part_id,current_req_status from test_table where req_type = 'I' and doc_code = :BLOCK1.doc_code and -- Here is the condition is changed based on the :BLOCK1.req_status(LOV). -- If user select other then "All" option from this LOV the query append the below condition current_req_status = :block1.req_status -- Else no need append the above condition in the query where clause.
If user select "ALL" option then no need for above condition in the where clause so that query returns all the rows from the database column.
select.... where nvl(database_column,'X')= nvl(:Block1.LOV_value)