Search Results csd_flow_status_rules_v




Overview
Explore in AI Chat

Overview

The view APPS.CSD_FLOW_STATUS_RULES_V belongs to the CSD — Depot Repair product module within Oracle E-Business Suite, and is valid in both the 12.1.1 and 12.2.2 releases. It exposes the configured workflow status transition rules that govern how a repair moves from one flow status to the next. In Depot Repair, repair lines advance through a defined lifecycle of flow statuses; each permitted transition is recorded as a transaction rule in the underlying CSD_FLWSTS_TRANS_B table and its translation table. This view denormalizes those rules by resolving internal foreign keys into lookup codes and meanings, and by joining workflow process metadata.

Because the view resolves identifiers into human-readable values — the current and next flow status codes and meanings, the workflow process display name, and the descriptive text — it is well suited for reporting, data extraction, and integration scenarios in which external systems or custom concurrent programs require a flattened, legible representation of Depot Repair status flow rules without performing their own multi-table joins.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects: CSD_FLOW_STATUSES_B (synonym), CSD_FLWSTS_TRANS_B (synonym), CSD_FLWSTS_TRANS_TL (synonym), FND_LOOKUPS (view), WF_RUNNABLE_PROCESSES_V (view), and the FND_GLOBAL package. The driving table is CSD_FLWSTS_TRANS_B, the base table of flow status transition rules. It is joined to CSD_FLWSTS_TRANS_TL on FLWSTS_TRAN_ID and filtered to the session language via USERENV('LANG'), which is how the translated DESCRIPTION column is obtained.

CSD_FLOW_STATUSES_B is joined twice — once as the current (from) status and once as the next (to) status — to obtain each status's lookup code. Two FND_LOOKUPS aliases then map those codes to their meanings using the lookup type CSD_REPAIR_FLOW_STATUS. Finally, WF_RUNNABLE_PROCESSES_V is outer-joined (WF_PROC.ITEM_TYPE(+) and WF_PROC.PROCESS_NAME(+)) to the transition's workflow item type and process name, supplying the workflow display name when a matching runnable process exists.

Key Columns

The view exposes sixteen columns. FLWSTS_TRAN_ID is the primary identifier of the transition rule. REPAIR_TYPE_ID identifies the repair type to which the rule applies — this is the column referenced in the user's search term repair_type_id, and it is the key filter for scoping rules to a specific repair type. The status pair is represented by CURRENT_FLOW_STATUS_ID, CURRENT_FLOW_STATUS_CODE, and CURRENT_FLOW_STATUS on one side, and NEXT_FLOW_STATUS_ID, NEXT_FLOW_STATUS_CODE, and NEXT_FLOW_STATUS on the other.

Workflow integration columns include WF_ITEM_TYPE, WF_PROCESS_NAME, and the resolved WF_DISPLAY_NAME. Behavioral flags include REASON_REQUIRED_FLAG, indicating whether a reason must be captured for the transition; CAPTURE_ACTIVITY_FLAG, controlling activity capture; and ALLOW_ALL_RESP_FLAG, governing responsibility-wide permission. DESCRIPTION holds the translated rule description, and OBJECT_VERSION_NUMBER supports optimistic locking on the underlying row.

Common Use Cases and Queries

Typical uses include reporting the permitted status transitions for a given repair type, validating that a proposed transition is configured, and extracting flow rule configuration for integration or migration. A representative query filters by repair type and presents the readable transition:

  • SELECT repair_type_id, current_flow_status, next_flow_status, reason_required_flag, wf_display_name — core reporting projection.
  • WHERE repair_type_id = :p_repair_type_id — scope to a single repair type.
  • ORDER BY current_flow_status, next_flow_status — present transitions in lifecycle order.

Because the view already resolves lookup meanings and workflow display names, it eliminates the need for report authors to replicate the joins across CSD_FLWSTS_TRANS_B, CSD_FLOW_STATUSES_B, FND_LOOKUPS, and WF_RUNNABLE_PROCESSES_V, making it the preferred source for any Depot Repair status-flow rule inquiry.