Search Results ams_tasks_v




Overview
Explore in AI Chat

Overview

AMS_TASKS_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Marketing (AMS) module. Its documented purpose is to return task and task assignment details, allowing concurrent programs, forms, OBIEE reports, and custom integrations to consume a flattened, marketing-filtered projection of Oracle's generic task infrastructure without joining the underlying task, assignment, resource, and lookup objects independently.

The view is delivered as VALID in both EBS 12.1.1 and 12.2.2 and is classified within the ETRM reference for AMS – Marketing. It is not a base table and therefore carries no indexes, constraints, or DML privileges of its own; all performance characteristics are inherited from the objects in its FROM clause. Because the definition embeds hard-coded filter predicates against task type rules and lookup types, the view behaves as a curated marketing dataset rather than a general-purpose task listing.

Underlying Base Objects

The documented definition joins five primary sources with two supporting packages:

Contractual filters include A.DELETED_FLAG != 'Y', A.OWNER_TYPE_CODE = 'RS_EMPLOYEE', and a DECODE mapping that converts AMS_CAMP, AMS_EVEO, AMS_EVEH, and AMS_DELV source object type codes into CAMP, EVEO, EVEH, and DELV. The documented metadata also lists JTF_TASK_UTL and JTF_TASK_WORKFLOW_PKG as referenced packages, reflecting the workflow and task utility logic that governs task state transitions.

Key Columns

Common Use Cases and Queries

Typical usage includes marketing task dashboards, assignment workload reports, and integration extracts feeding external CRM or BI platforms. A representative query is:

SELECT TASK_ID, TASK_NAME, TASK_STATUS, TASK_OWNER, FULL_NAME, SOURCE_OBJECT_NAME, PLANNED_END_DATE FROM APPS.AMS_TASKS_V WHERE TASK_STATUS = 'OPEN' ORDER BY PLANNED_END_DATE;

For assignment workload by resource:

SELECT RESOURCE_ID, FULL_NAME, COUNT(*) ASSIGNED FROM APPS.AMS_TASKS_V GROUP BY RESOURCE_ID, FULL_NAME;

Because the view filters on RULE = 'ORACLE_MARKETING', results are limited to Marketing-owned tasks; queries outside that scope must access JTF_TASKS_V directly.