These apps are any application (Mobile, Chrome Extension, Web, etc. ) running inside an organization's cloud service that asks for various permissions.
The user needs to grant the permissions then the cloud service creates an OAuth token for the application and basically allows it to access cloud service data according to the permissions approved by the user. Common permissions include Access your Contacts, Manage Your Drive, Send emails as you, etc.