Need your help to confirm the following R12.2 standard.
From a custom schema if we need to access a table present in APPS schema, the R12.2 standard is to access
it using the private synonym defined in that particular custom schema and use that synonym in the SQL\PL\SQL statements.
For example : If my custom schema is XXPO and has the Grant to access PO HEADERS_ALL present in APPS.
We will create a private synonym in XXPO and use the synonym directly from XXPO schema.
CREATE SYNONYM XXPO.PO_HEADERS_ALL for APPS.PO_HEADERS_ALL
Can you please let me know if my understanding is correct.