Search Results csf_sr_tasks_v

Overview

APPS.CSF_SR_HIST_V is a service request history view in Oracle E-Business Suite, exposed under the APPS schema and available in both 12.1.1 and 12.2.2. It presents a denormalized, presentation-ready projection of service request (SR) incident data, joining the core incident tables with customer, contact, product, and reference-code lookups. As a view rather than a table, it holds no data of its own; it derives its result set at query time from the underlying incident, instance, party, and item objects.

The view exists primarily to support service request history reporting, inquiry screens, and integration extracts where a single flat structure covering incident number, summary, status, severity, product, and customer context is preferable to assembling the underlying joins manually. Because it resolves translated reference-code names dynamically using the session language, the view returns locale-appropriate type, severity, status, and urgency descriptions.

Underlying Base Objects

The view is defined over the following documented base objects:

• CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_TL — the incident header and its translation table, providing the driving rows and the language-dependent summary and text index.
• CS_INCIDENT_TYPES_TL, CS_INCIDENT_SEVERITIES_TL, CS_INCIDENT_STATUSES_TL, CS_INCIDENT_URGENCIES_TL — translation tables supplying the descriptive names for type, severity, status, and urgency.
• CSI_ITEM_INSTANCES — the installed base instance, supplying instance_number.
• MTL_SYSTEM_ITEMS_KFV — the key-flexfield item view, supplying product_name and product_description.
• HZ_PARTIES (aliased for both customer and contact), HZ_CONTACT_POINTS, and CS_HZ_SR_CONTACT_POINTS — supplying customer number, company name, contact name, phone, and email.
• HZ_TIMEZONES — supplying the time zone name for the incident.
• CSF_SR_TASKS_V — a further view referenced as part of the broader service request history surface.

Joins to the item instance, item flexfield, and product-related objects are outer joins, so incidents without a linked product or instance still return a row.

Key Columns

The projection includes identity, classification, and party attributes:

• row_id, incident_id, org_id — unique row locator, incident primary key, and operating unit.
• incident_number and incident_number_n — the displayed incident number and a second aliased copy of the same column. The alias incident_number_n is the exact term used in the search that led to this object; it is a duplicate projection of inc.incident_number.
• summary — the incident summary text from the translation table.
• incident_type, severity, status_code, urgency — descriptive names resolved from the translation tables in the session language.
• product_name, product_description, instance_number — item flexfield segments and installed base instance.
• company_name, customer_number, contact_name, phone, email, contact_number — customer and contact details from HZ_PARTIES and HZ_CONTACT_POINTS.
• time_zone_name, country, caller_type, group_type — supporting context attributes.

Common Use Cases and Queries

Typical usage retrieves history for a given incident or customer, or extracts SR data for reporting. A representative query filters on the aliased incident number:

SELECT incident_number_n, summary, status_code, severity, product_name, contact_name
FROM   apps.csf_sr_hist_v
WHERE  org_id = :p_org_id
AND    incident_number_n = :p_incident_number;

The view is also used for listing all service requests for a customer or installed instance, and for feeding service history into downstream dashboards or integration interfaces where the flattened structure reduces join complexity. Because the language-dependent lookups use USERENV('LANG'), results honor the querying session's language setting.