This content has been marked as final. Show 2 replies
You will need to set Multi Org context without which you will not be able to query data form tables like HZ_CUST_ACCT_SITES.
you will still be able to query data from HZ_CUST_ACCT_SITES_ALL.
Just execute following block from sql, and then you should be able to query form HZ_CUST_ACCT_SITES.
fnd_global.apps_initialize(&user_id, &resp_id, &application_id);
you can user AR Super User's responsibility id.
p_org_id is the OU's org_id
the HZ_CUST_ACCT_SITES it's a synonym of AR.HZ_CUST_ACCT_SITES_ALL.
HZ_CUST_ACCT_SITES is synonym with security
as you is not initialize then you anonymous so you haven't data
SQL Queries and Multi-Org Architecture in Release 12 [ID 462383.1]
R12: How to Set the ORG_ID (org context) Before Running a Statement in SQL*Plus? [ID 753178.1]
Could you please help me to understand the reason why the first query not retrieved any rows or something i missed?
you missed security