1. Tables and Views for Sales and Fusion Service
  2. SVC_QUEUE_AGENTS_V

SVC_QUEUE_AGENTS_V

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: VIEW

Columns

Name

QUEUE_ID

PARTY_ID

PARTY_NAME

USER_GUID

Query

SQL_Statement

SELECT QueueResources.QUEUE_ID, Parties.PARTY_ID, Parties.PARTY_NAME, Parties.USER_GUID

FROM fusion.SVC_QUEUE_RESOURCES QueueResources, fusion.JTF_RS_TEAM_MEMBERS ResourceTeamMembers, fusion.HZ_PARTIES Parties

WHERE

(QueueResources.OBJECT_TYPE_CD = 'ORA_SVC_RESOURCE_TEAM' AND QueueResources.ENABLED_FLAG = 'Y' AND UPPER(QueueResources.DELETED_FLAG) = 'N')

AND QueueResources.OBJECT_ID = ResourceTeamMembers.TEAM_ID AND ResourceTeamMembers.DELETE_FLAG = 'N'

AND ResourceTeamMembers.TEAM_RESOURCE_ID = Parties.PARTY_ID AND Parties.PARTY_TYPE = 'PERSON'

UNION

SELECT QueueResources.QUEUE_ID, Parties.PARTY_ID, Parties.PARTY_NAME, Parties.USER_GUID

FROM fusion.SVC_QUEUE_RESOURCES QueueResources, fusion.HZ_PARTIES Parties

WHERE

(QueueResources.OBJECT_TYPE_CD = 'ORA_SVC_RESOURCE' AND QueueResources.ENABLED_FLAG = 'Y' AND UPPER(QueueResources.DELETED_FLAG) = 'N')

AND QueueResources.OBJECT_ID = Parties.PARTY_ID AND Parties.PARTY_TYPE = 'PERSON'