8.5 Public SQL Views

APEX_WORKSPACE_AI_SERVICES

create or replace view apex_workspace_ai_services
as
select w.workspace,
       w.workspace_display_name,
       --
       rs.id                            remote_server_id,
       rs.name                          remote_server_name,
       rs.static_id                     remote_server_static_id,
       rs.base_url                      base_url,
       --
       decode (
            rs.ai_provider_type,
            'OPENAI', 'Open AI',
            'COHERE', 'Cohere',
            'OCI_GENAI', 'OCI Generative AI',
            rs.ai_provider_type )       provider_type,
       rs.ai_provider_type           as provider_type_code,
       decode (
            rs.ai_is_builder_service,
            'Y', 'Yes',
            'N', 'No',
            rs.ai_is_builder_service )  is_builder_service,
       rs.ai_model_name                 model_name,
       rs.ai_http_headers               http_headers,
       rs.ai_attributes                 attributes,
       --
       rs.server_comment                comments,
       rs.last_updated_by,
       rs.last_updated_on,
       --
       substr(rs.name, 1, 30) || '.' || length(rs.name) ||
       ' url=' || substr(rs.base_url,1,30) || length(rs.base_url) component_signature
  from wwv_remote_servers rs,
       wwv_companies_auth_restricted w
 where w.workspace_id = rs.security_group_id
   and rs.server_type = 'GENERATIVE_AI'
/