Search Results cug_sr_task_type_dets_b




Overview
Explore in AI Chat

Overview

The CUG_SR_TASK_TYPE_DETS_B table is a core data object within the Oracle E-Business Suite (EBS) Citizen Interaction Center (CUG) module. It functions as a configuration table that defines and stores additional, operational details for task types associated with specific Service Request (SR) types. This table enables the systematic assignment of default attributes, such as priority, status, and ownership, to tasks that are automatically generated when a service request of a particular type is created or updated. Its role is critical for standardizing and automating task management workflows within the broader service request lifecycle.

Key Information Stored

The table's primary key is the SR_TASK_TYPE_DET_ID, which uniquely identifies each configuration record. Based on the documented foreign key relationships, the table stores several key foreign key references that define a task's default properties. These include the TASK_STATUS_ID (linking to JTF_TASK_STATUSES_B), the TASK_PRIORITY_ID (linking to JTF_TASK_PRIORITIES_B), and the OWNER_ID. The OWNER_ID is a polymorphic column that can reference a group (JTF_RS_GROUPS_B), a resource (JTF_RS_RESOURCE_EXTNS), or a team (JTF_RS_TEAMS_B) to define the default task owner. An additional foreign key, TSK_TYP_ATTR_DEP_ID, links to CUG_TSK_TYP_ATTR_DEPS_B, suggesting the table can also store dependencies or conditional attributes for task types.

Common Use Cases and Queries

A primary use case is the administrative setup of service request types, where an implementer configures which automatic tasks are generated and their default parameters. For reporting, this table is essential for analyzing the linkage between service request types and their associated task workflows. A common query pattern involves joining this table to its related lookup tables to retrieve a human-readable description of the configured task defaults.

SELECT sr_det.SR_TASK_TYPE_DET_ID,
       status.NAME TASK_STATUS,
       priority.NAME TASK_PRIORITY,
       grp.GROUP_NAME OWNER_GROUP
FROM CUG.CUG_SR_TASK_TYPE_DETS_B sr_det,
     JTF.JTF_TASK_STATUSES_B status,
     JTF.JTF_TASK_PRIORITIES_B priority,
     JTF.JTF_RS_GROUPS_B grp
WHERE sr_det.TASK_STATUS_ID = status.TASK_STATUS_ID
  AND sr_det.TASK_PRIORITY_ID = priority.TASK_PRIORITY_ID
  AND sr_det.OWNER_ID = grp.GROUP_ID;

Related Objects

The table maintains integral relationships with several other EBS objects. Its primary key is referenced by the translated description table, CUG_SR_TASK_TYPE_DETS_TL, via the SR_TASK_TYPE_DET_ID column. As documented, it has foreign key dependencies on the following tables:

  • CUG_TSK_TYP_ATTR_DEPS_B via TSK_TYP_ATTR_DEP_ID
  • JTF_TASK_STATUSES_B via TASK_STATUS_ID
  • JTF_RS_GROUPS_B via OWNER_ID
  • JTF_RS_RESOURCE_EXTNS via OWNER_ID
  • JTF_TASK_PRIORITIES_B via TASK_PRIORITY_ID
  • JTF_RS_TEAMS_B via OWNER_ID
These relationships position CUG_SR_TASK_TYPE_DETS_B as a central hub connecting service request configuration to the underlying task management (JTF) and resource management (JTF_RS) foundations of Oracle EBS.