Search Results ast_task_assignments_v




Overview
Explore in AI Chat

Overview

The AST_TASK_ASSIGNMENTS_V view is a predefined, VALID database object owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the AST – TeleSales product family and exposes task assignment information maintained by the common task infrastructure shared across Oracle CRM applications. Functionally, the view presents one row per task assignment record, denormalizing the assignment against descriptive names for the assigned resource type, the assignment status, and the assignee role. It is the standard read-only interface through which TeleSales and downstream reporting components retrieve assignment-level detail without querying the underlying transactional tables directly.

Because the view is defined in the APPS schema and joins translation and lookup tables, it is intended for reporting, concurrent program extracts, form-based queries, and integration payloads where human-readable assignment data is required. The view is registered as a valid object at the listed releases and references only supported base objects.

Underlying Base Objects

The view text is built over the following documented objects:

Key Columns

Common Use Cases and Queries

Typical scenarios include producing assignment worklists by role, validating role usage against the lookup, and extracting assignment detail for CRM integrations. Because the view is language-aware, queries return translated names automatically.

List assignments filtered by assignee role:

  • SELECT TASK_ID, TASK_ASSIGNMENT_ID, RESOURCE_NAME, ASSIGNEE_ROLE, MEANING, ASSIGNMENT_STATUS
  • FROM APPS.AST_TASK_ASSIGNMENTS_V
  • WHERE ASSIGNEE_ROLE = :p_role
  • ORDER BY ACTUAL_START_DATE DESC;

Aggregate effort by role and status:

  • SELECT ASSIGNEE_ROLE, ASSIGNMENT_STATUS, SUM(ACTUAL_EFFORT) TOTAL_EFFORT
  • FROM APPS.AST_TASK_ASSIGNMENTS_V
  • GROUP BY ASSIGNEE_ROLE, ASSIGNMENT_STATUS;

Identify assignments whose role does not resolve to a lookup meaning:

  • SELECT TASK_ASSIGNMENT_ID, ASSIGNEE_ROLE
  • FROM APPS.AST_TASK_ASSIGNMENTS_V
  • WHERE MEANING IS NULL;