ORA-00942 while creating a view.

Hello Experts,

I have below issue.Please look in to it and provide us your valuable suggestions.

In 11gR2 RAC database,while creating a viw I am getting below errors.

CREATE OR REPLACE VIEW API_IF_ACTIVATE.ACTIVATE_ACCOUNT_DETAILS

  2  AS

  3  SELECT

  4     APPLICATION_NUMBER,

  5     CURRENT_CREDIT_LIMIT,

  6     RECOMMENDED_CREDIT_LIMIT,

  7     BEHAVIOUR_SCORE,

  8     ACCOUNT_OPENED_DATE,

20     'ACTIVATE' AS DATA_SOURCE

21  FROM ACTIVATE.ACTIVATE_ACCOUNT_DETAILS

22* WITH READ ONLY

17:18:25 API_IF_ACTIVATE@dwhc1 > select count(*) from API_IF_ACTIVATE.ACTIVATE_ACCOUNT_DETAILS;

select count(*) from API_IF_ACTIVATE.ACTIVATE_ACCOUNT_DETAILS

                                     *

ERROR at line 1:

ORA-00942: table or view does not exist<<<<<<<<<<<<<<<

Where as when I grant select then it works fine.