R12 AR : Table AR.RA_ADDRESSES_ALL is obsolete in Oracle r12. ??

Hi there,

We have recently upgraded from 11.5.10.2 to R12.1.3 ?

 Table AR.RA_ADDRESSES_ALL is obsolete in Oracle r12.

 Synonym APPS.RA_ADDRESSES_ALL points to view APPS.RA_ADDRESSES_MORG in Oracle 11i and points to table AR.RA_ADDRESSES_ALL in Oracle r12

We have queries like :

SELECT COUNT(XXXXXX)
FROM ra_addresses_all raa,
hz_cust_accounts hca,
HZ_CUST_SITE_USES_ALL hpsWHERE hca.account_number = ????AND hca.party_id = raa.party_id
AND raa.org_id =fn_get_profile_value('ORGANIZATION_ID',resp_id)
AND raa.status = '?'
AND raa.bill_to_flag IN