I have 2 instances on the production server "PROD_A" & "PROD_B". I have a view on my PROD_A instance:

CREATE OR REPLACE VIEW SCOTT.ABC_DETAILS
(COMPANY, FREEQTY, ACTUALSTARTDATE)
AS
SELECT COMPANY, FREEQTY, ACTUALSTARTDATE
FROM TIM.ABCDETAILS@PROD_B;

So, realistically this view resides on PROD_A and gets populated with data from PROD_B.
At the same time I have another server that has the standby databases for both these environments.
The problem I am having is that instead of pulling the data from the primary PROD_B database it is pulling it from the standby PROD_B database.
I checked the tnsnames file on the server it is pointing to the correct server.

WHere else should I look?

Any input will be greatly appreciated.

Chintz