Select application_id, application_short_name from fnd_application where application_short_name='CE';
If you are using toad or sqldeveloper, after connecting as apps
MO_GLOBAL.SET_POLICY_CONTEXT('S',:P_ORG_ID); -- pass in the organization id
Once the above bits are executed, you should get the data through a simple select statement.
if this does not work check the tables in the view and see if all the tables return data