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 the AUTO_MANUAL lookup code into a meaningful display value using lookup type CSP_PRODUCT_TASK.
  • MTL_SYSTEM_ITEMS_KFV (SYNONYM) — the key flexfield item view, aliased as MSI, providing CONCATENATED_SEGMENTS and ORGANIZATION_ID for the product.
  • CS_STD (PACKAGE) — used in the predicate MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID to 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

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.