Results for “csp_product_tasks_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSP_PRODUCT_TASKS_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments. It belongs to the CSP – Spares Management product family and presents product task information used to associate task templates with inventory items. The view denormalizes several core EBS entities into a single reporting-friendly structure, resolving item identifiers into concatenated segment values, task identifiers into descriptive task names, and coded values into user-facing lookup meanings.

Because the CSP module supports field service and spares logistics, this view is typically referenced by concurrent programs, Oracle Reports, and custom SQL used to analyze how tasks are allocated to spare parts. It is a key integration point for administrators performing data extracts, ad-hoc diagnosis, or building business intelligence around task execution metrics such as actual times used and task percentages. The view is registered as VALID in the ETRM metadata, indicating it is a supported, active object in the EBS data dictionary.

Underlying Base Objects

The documented ETRM metadata lists the following referenced base objects on which CSP_PRODUCT_TASKS_V depends:

• CSP_PRODUCT_TASKS (SYNONYM) – The primary transactional table storing product task records, including foreign keys to product and task template, timing metrics, and descriptive flexfield attributes.
• JTF_TASK_TEMPLATES_VL (VIEW) – Supplies the task template name and description via a language-specific view over JTF task template data.
• FND_LOOKUPS (VIEW) – Provides the decoded meaning for the AUTO_MANUAL lookup code, restricted to the lookup type 'CSP_PRODUCT_TASK'.
• MTL_SYSTEM_ITEMS_KFV (SYNONYM) – Key Flexfield view that resolves the inventory item identifier into the CONCATENATED_SEGMENTS value and supplies ORGANIZATION_ID.
• CS_STD (PACKAGE) – Used to return the validation organization identifier via CS_STD.GET_ITEM_VALDN_ORGZN_ID for the item join.
• FND_GLOBAL (PACKAGE) – Standard EBS package that supplies session context such as user and responsibility information, supporting the audit columns and the operating environment.

The joins link CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID to JTF_TASK_TEMPLATES_VL.TASK_TEMPLATE_ID, CSP_PRODUCT_TASKS.AUTO_MANUAL to FND_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CSP_PRODUCT_TASK', and CSP_PRODUCT_TASKS.PRODUCT_ID to MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID for the validation organization. This design isolates base-table keys while presenting business-readable values.

Key Columns

• PRODUCT_TASK_ID – Primary key of the underlying product task record.
• PRODUCT_ID – Identifier of the inventory item (product) to which the task applies.
• CONCATENATED_SEGMENTS – Flexfield-derived display value of the inventory item, useful in reports.
• ORGANIZATION_ID – Inventory organization context associated with the product.
• TASK_TEMPLATE_ID – Foreign key to the task template; this is the column most frequently searched by users joining task definitions to products.
• AUTO_MANUAL – Code indicating whether the task is automatic or manual, decoded through MEANING.
• ACTUAL_TIMES_USED and TASK_PERCENTAGE – Quantitative metrics for task execution.
• TASK_NAME and DESCRIPTION – Descriptive attributes sourced from JTF_TASK_TEMPLATES_VL.
• MEANING – Decoded value of AUTO_MANUAL from FND_LOOKUPS.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 – Descriptive flexfield columns available for extensibility and custom reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns.

Common Use Cases and Queries

The view is commonly used to list all product tasks associated with a given task template or inventory item, to audit automatic versus manual task assignments, and to review flexfield attribute data. Because the join to MTL_SYSTEM_ITEMS_KFV relies on CS_STD.GET_ITEM_VALDN_ORGZN_ID, results reflect the validation organization context of the session.

A sample query retrieving tasks for a specific template follows:

• SELECT product_task_id, task_template_id, concatenated_segments, task_name, meaning, actual_times_used, task_percentage FROM csp_product_tasks_v WHERE task_template_id = :p_template_id;

To report automatic tasks across the validation organization:

• SELECT product_id, concatenated_segments, task_name, actual_times_used FROM csp_product_tasks_v WHERE auto_manual = 'AUTO';

Analysts frequently aggregate TASK_PERCENTAGE by product to identify high-effort items, and they extract ATTRIBUTE columns for downstream integration. Query performance depends on the efficiency of the joins to JTF_TASK_TEMPLATES_VL, FND_LOOKUPS, and the key flexfield view, so filtering on TASK_TEMPLATE_ID or PRODUCT_ID is recommended in high-volume environments.