Results for “active_wf_process”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JTF_TASKS_V is a common view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the JTF – CRM Foundation product. It is classified in ETRM as a VIEW with VALID status, and its documented purpose is to expose all task attributes in a single, denormalized structure. In Oracle EBS 12.1.1 and 12.2.2, the object is not a transactional interface but a read-optimized consolidation layer over the task entity model. Tasks in CRM Foundation represent activities, to-dos, appointments, and similar work items that can be associated with parties, accounts, resources, and source objects.
Because JTF_TASKS_V joins the base task definition to lookup translation tables, owner resolution utilities, customer and address data, timezone metadata, workflow information, and source object attributes, it serves as the primary reporting surface for task-oriented inquiries. Reports, dashboards, and integrations use it to avoid reimplementing the complex joins and package calls required to present a task with human-readable status, type, priority, owner, and customer names.
Underlying Base Objects
The view is defined over a set of CRM Foundation and Trading Community Architecture objects. Documented referenced objects include JTF_TASKS_VL (VIEW), JTF_TASK_STATUSES_B and JTF_TASK_STATUSES_TL, JTF_TASK_TYPES_B and JTF_TASK_TYPES_TL, JTF_TASK_PRIORITIES_TL, JTF_OBJECTS_B and JTF_OBJECTS_TL, HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_LOCATIONS, HZ_PARTY_SITES, and FND_TIMEZONES_VL.
Two PL/SQL components are also referenced: JTF_TASK_UTL, used for owner and user name resolution, and JTF_TASK_WORKFLOW_PKG, used to determine workflow activity and display names. The task header data itself is sourced from JTF_TASKS_VL, while the _TL tables supply translated lookup names and the _B tables supply base lookup identifiers. The HZ tables provide party, account, and address attributes, and FND_TIMEZONES_VL supplies timezone name and GMT offset. This combination makes the view dependent on both CRM Foundation and TCA data, which is important for performance and security assessment in reporting environments.
Key Columns
The view exposes identifiers and audit columns such as ROW_ID, TASK_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. Descriptive attributes include TASK_NUMBER, TASK_NAME, and DESCRIPTION.
- Task classification: TASK_TYPE_ID and TASK_TYPE, TASK_STATUS_ID and TASK_STATUS, and CLOSED, derived through NVL(JTSB.CLOSED_FLAG, 'N'). TASK_PRIORITY_ID and TASK_PRIORITY provide priority lookup values.
- Ownership and assignment: OWNER_ID, OWNER_TYPE_CODE, OWNER_TYPE, OWNER, ASSIGNED_BY_ID, and ASSIGNED_BY_NAME. The OWNER and ASSIGNED_BY_NAME columns are populated via JTF_TASK_UTL package functions.
- Customer and address: CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_NUMBER, CUST_ACCOUNT_ID, CUST_ACCOUNT_NUMBER, ADDRESS_ID, ADDRESS1, ADDRESS2, and ADDRESS3, where address lines are concatenated from HZ_LOCATIONS attributes.
- Dates and scheduling: PLANNED_START_DATE, PLANNED_END_DATE, SCHEDULED_START_DATE, SCHEDULED_END_DATE, ACTUAL_START_DATE, ACTUAL_END_DATE, and DURATION with DURATION_UOM.
- Timezone and workflow: TIMEZONE_ID with name and GMT_OFFSET, plus WORKFLOW_PROCESS_ID, ACTIVE_WF_PROCESS, WORKFLOW_PROCESS_NAME, and WORKFLOW_DISPLAY_NAME.
- Source object: SOURCE_OBJECT_TYPE_CODE, SOURCE_OBJECT_TYPE, SOURCE_OBJECT_ID, SOURCE_OBJECT_NAME, OBJECT_FUNCTION, and OBJECT_PARAMETERS link the task to its originating business object.
Common Use Cases and Queries
Typical usage includes open task listings, owner workload analysis, customer activity reports, and workflow status checks. The following query returns open tasks for a given owner with customer and status information:
SELECT task_number, task_name, task_status, task_priority, owner, customer_name, planned_start_date FROM jtf_tasks_v WHERE closed = 'N' AND owner_id = :owner_id ORDER BY planned_start_date;
For customer-facing reporting, the CUSTOMER_NAME and CUST_ACCOUNT_NUMBER columns allow tasks to be grouped by party without joining HZ tables manually:
SELECT customer_name, task_status, COUNT(*) task_count FROM jtf_tasks_v WHERE customer_id IS NOT NULL GROUP BY customer_name, task_status;
Because the view invokes PL/SQL functions during row retrieval, queries should be filtered by indexed columns such as TASK_ID, TASK_NUMBER, OWNER_ID, or date ranges to limit the number of function executions. The view is suitable for ad hoc reporting and integration extracts, but high-volume or high-frequency processing should consider targeted joins to the base tables instead.
-
View: JTF_TASKS_V 12.2.2
Common View with all the task attributes.
APPS.JTF_TASKS_V·↳ FND_TIMEZONES_VL·↳ HZ_CUST_ACCOUNTS·↳ HZ_LOCATIONS·Explore JTF module →
-
View: JTF_TASKS_V 12.1.1
Common View with all the task attributes.
APPS.JTF_TASKS_V·↳ FND_TIMEZONES_VL·↳ HZ_CUST_ACCOUNTS·↳ HZ_LOCATIONS·Explore JTF module →
-
VIEW: APPS.JTF_TASKS_V 12.1.1
-
VIEW: APPS.JTF_TASKS_V 12.2.2
-
VIEW: APPS.JTF_TASKS_V 12.2.2
-
VIEW: APPS.JTF_TASKS_V 12.1.1
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel