Command to set default org id

Within SQL developer or other database tools, if you run the query on many of EBS tables or views, you may not get any result. In this case, you need to run the below command to set the default organization_id first before running the query.

execute dbms_application_info.set_client_info(112);

where 112 is the org_id.

If you need to extract the information within all organization, you need to query on XXXX_all tables.