Results for “csp_product_task”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view APPS.CSP_PRODUCT_TASKS_V is a reporting and integration object within the Oracle E-Business Suite customer service and field service module (CSP / CS). It presents product-level task associations, exposing the relationship between a service product (inventory item) and the task templates that may be performed against it. As a denormalized read-only view, it consolidates data from the transactional product-task table with descriptive information drawn from the task template, lookup, and item master entities, presenting a single coherent row per product-task definition.
Because it is owned by the APPS schema and combines multiple lookup-validated and joined entities, the view is intended primarily for concurrent programs, forms, OAF pages, and diagnostic or custom reporting queries rather than for direct DML. In the context of ETRM 12.1.1 and 12.2.2 documentation, the object supports the field service task generation process, where task templates attached to a product can be instantiated automatically or manually when a service work order references that product.
Underlying Base Objects
The documented view definition joins four referenced entities, with two additional schema objects implied by dependencies:
- CSP_PRODUCT_TASKS (SYNONYM) — the primary transactional base table, aliased as
CPT, holding product-task definitions and descriptive flexfield (DFF) attributes. - JTF_TASK_TEMPLATES_VL (VIEW) — the task template source, aliased as
JTF, supplying task name and description across language installations. - FND_LOOKUPS (VIEW) — the lookup source, aliased as
FND, translating theAUTO_MANUALlookup code into a meaningful display value using lookup typeCSP_PRODUCT_TASK. - MTL_SYSTEM_ITEMS_KFV (SYNONYM) — the key flexfield item view, aliased as
MSI, providingCONCATENATED_SEGMENTSandORGANIZATION_IDfor the product. - CS_STD (PACKAGE) — used in the predicate
MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_IDto restrict the item join to the standard validation organization. - FND_GLOBAL (PACKAGE) — referenced in ETRM metadata as a dependency, typically supplying the runtime organization/validation context.
Key Columns
PRODUCT_TASK_ID— unique identifier of the product-task association (primary key from the base table).PRODUCT_ID,CONCATENATED_SEGMENTS,ORGANIZATION_ID— the product's inventory item ID, its display name from the item key flexfield, and the owning organization.TASK_TEMPLATE_ID,TASK_NAME,DESCRIPTION— the linked task template and its descriptive text.AUTO_MANUAL,MEANING— the lookup code indicating whether the task is generated automatically or manually, and its display meaning.ACTUAL_TIMES_USED,TASK_PERCENTAGE— usage counters and weighting values used in task scheduling or costing.ATTRIBUTE_CATEGORY,ATTRIBUTE1–ATTRIBUTE15— descriptive flexfield context and segments.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard WHO audit columns.
Common Use Cases and Queries
Typical scenarios include identifying which tasks are bound to a product, auditing automatic versus manual task generation, and extracting task metadata for interfaces or diagnostics.
- List all tasks for a product:
SELECT product_id, task_name, meaning, task_percentage FROM apps.csp_product_tasks_v WHERE product_id = :p_product_id; - Find automatic tasks:
SELECT product_id, concatenated_segments, task_name FROM apps.csp_product_tasks_v WHERE auto_manual = 'AUTO'; - Report usage:
SELECT task_name, actual_times_used, task_percentage FROM apps.csp_product_tasks_v ORDER BY actual_times_used DESC;
Because the view filters on the standard validation organization, queries return only items valid in that context, which should be understood when reconciling against direct queries on CSP_PRODUCT_TASKS.
-
Product-Task relation created type
-
Product-Task relation created type
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
View: CSP_PRODUCT_TASKS_V 12.2.2
Product Task information
APPS.CSP_PRODUCT_TASKS_V·↳ CSP_PRODUCT_TASKS·↳ CS_STD·↳ FND_GLOBAL·Explore CSP module →
-
View: CSP_PRODUCT_TASKS_V 12.1.1
Product Task information
APPS.CSP_PRODUCT_TASKS_V·↳ CSP_PRODUCT_TASKS·↳ CS_STD·↳ FND_GLOBAL·Explore CSP module →