Search Results task_workflow




Overview
Explore in AI Chat

Overview

CS_SR_TYPES_SELECT_SEC is a Service (CS) module view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the definition of service request types and subtypes. The view is defined over the CS_INCIDENT_TYPES_B base table and presents a security-oriented projection of incident type configuration, including workflow routing attributes, web channel flags, and descriptive flexfield context columns. In the ETRM metadata for 12.2.2 the object is recorded with no documented dependent base objects, and its description notes that the view is "not implemented in this database" in the captured environment — meaning it is a seeded dictionary object whose presence and population depend on whether Service request types have been configured.

Because service request types drive incident classification, workflow selection, and self-service portal behaviour, the view functions as a reporting surface for administrators, implementers, and integration developers who need a read-only, queryable representation of request type configuration without joining directly to the transactional base table.

Underlying Base Objects

The view is defined over a single base object, CS_INCIDENT_TYPES_B. The SELECT list projects nearly every column from that table's business-layer record, including audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER), effective-dating columns (START_DATE_ACTIVE, END_DATE_ACTIVE), and the extensive set of workflow and channel attributes. Column aliases follow the base table names; for example B.WEB_WORKFLOW and B.WEB_ENTRY_FLAG pass through unchanged. The user's search term "web_workflow" resolves directly to the WEB_WORKFLOW column exposed here. The accompanying column list also references ROW_ID, NAME, and DESCRIPTION, which are characteristic of the table's primary key and descriptive translation structures.

Key Columns

Common Use Cases and Queries

Typical uses include auditing workflow configuration for web-enabled request types, validating flexfield usage, and feeding integration or migration routines. A representative query lists active web workflow types:

  • SELECT INCIDENT_TYPE_ID, INCIDENT_SUBTYPE, WORKFLOW, WEB_WORKFLOW FROM CS_SR_TYPES_SELECT_SEC WHERE WEB_ENTRY_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE;
  • Join to CS_INCIDENT_TYPES_TL on INCIDENT_TYPE_ID for the NAME/DESCRIPTION translation when reporting in a specific language.

Because the view is read-only and mirrors the base table structure, it is safe for ad-hoc reporting and secured query exposure without risk of mutating configuration.