You are using 'USER_...' views. Are you sure that those 3-4 tables that certainly have STORE_CODE column are owned by the user through which you firing this query ?