When you query Multi-Org tables in SQL*Plus or any tool (like TOAD), we get zero rows, though actually those tables got data? What is the reason? What do you do then?

Nee to set org context to the current user session.

Single-org:

Execute mo_global.set_policy_context('S',&org_id);

Multi-org:

Begin

FND_GLOBAL.apps_initialize(

   l_user_id,    -- User id

   l_resp_id,    -- Responsibility Id

   200);           -- Application Id

MO_GLOBAL.init('SQLAP');

End;