Intiation of views to retrive the data in sql tools (Oracle Apps)

execute dbms_application_info.set_client_info(<your org_id here>);

OR

begin
 fnd_client_info.SET_ORG_CONTEXT(<your org_id here>);

end;

OR

execute fnd_client_info.SET_ORG_CONTEXT(<your org_id here>);

OR

execute fnd_global.APPS_INITIALIZE(5,50272,201);