Hi Lakshmi,

As far as I know, you cannot access list views via SOQL queries. It's built into the SObject. We created a method which might help you see how we use List Views in APEX. Our Task was to get a LIST VIEW URL based on the LABEL (view name). You cannot retrieve ID's based on the LIst View API Name as the describe sobject only returns a ListOption which is a value and label.

Requirement

Display a link on your own visualforce page. When clicked it will take a user to the the All Accounts List View for the Account Object.

    /********************************
    * VISUALFORCE
    ********************************/
    <apex:page controller="myListViewURLController" >
	<apex:form>
        	<apex:outputLink value="{!AllAccountsListViewURL}">All Accounts</apex:outputLink> 
        </apex:form>
    </apex:page>
    
    /*******************************
    * APEX
    *******************************/
    
    public class myListViewURLController {
    	Public AllAccountsListViewURL {get;set;}
    	public myListViewURLController (){
            /******************************
            * GET OBJECT PREFIX LIST
            ******************************/
            Map<String,String> PrefixList = PrefixList();
    
    	    /*****************************
            * SET OBJECT AND LIST VIEW LABEL NAME
            *****************************/
            AllAccountsListViewURL = 
            	ListViewURL(PrefixList,'Account','All Accounts');
        }
        Public Map<String,String> PrefixList(){
            Map<String,String> PrefixList = new Map<String,String>{};
            Map<String, Schema.SObjectType> gd = Schema.getGlobalDescribe(); 
            for(String sObj : gd.keySet()){
                Schema.DescribeSObjectResult r =  gd.get(sObj).getDescribe();
                PrefixList.put(r.getName(), r.getKeyPrefix());
            }
            return PrefixList;
        } 
        Public String ListViewURL(Map<String,String> PrefixList,String ObjectName,String ListViewLabel){
            String ListViewURL;
            String ListViewId;
            String q = 'SELECT Name FROM '+ ObjectName +' LIMIT 1';
            ApexPages.StandardSetController ACC = new ApexPages.StandardSetController(Database.getQueryLocator(q));
            List<SelectOption> ListViews = ACC.getListViewOptions();
            for(SelectOption w : ListViews ){
                if(w.getLabel()==ListViewLabel){
                    ListViewId = w.getValue().left(15);
                    ListViewURL='/'+PrefixList.get(ObjectName)+'?fcf='+ListViewId;
                }
            }
            return ListViewURL;
        }
    }

Zach