Search Results csd_flwsts_trans_b_u2

Overview

CSD.CSD_FLWSTS_TRANS_B is a transactional configuration table in the Oracle E-Business Suite Depot Repair (CSD) module. It stores the allowable status transitions for a given repair type, effectively defining the workflow state machine that governs how a repair order, repair line, or related service entity may move from one flow status to another. Each row represents one permitted "from-to" transition, together with the workflow, reason-capture, activity-logging, and responsibility-access attributes that apply when that transition is exercised.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Under the heuristic Data Vault classification supplied in the metadata, this object is identified as standalone. From a modeling perspective, it is best treated as a reference or configuration entity: it carries no foreign keys to other link tables and is referenced by downstream transactional tables rather than acting as a hub, link, or satellite in a Data Vault sense. Its business identity is enforced entirely through its own unique indexes.

Key Information Stored

The primary surrogate key is FLWSTS_TRAN_ID, a NUMBER column that uniquely identifies each status-transition definition and is enforced by the unique index CSD_FLWSTS_TRANS_B_U1. The business key is enforced by the composite unique index CSD_FLWSTS_TRANS_B_U2 across REPAIR_TYPE_ID, FROM_FLOW_STATUS_ID, and TO_FLOW_STATUS_ID — the three columns that together guarantee a transition is defined only once per repair type.

• FLWSTS_TRAN_ID — surrogate primary key identifying the transition record.
• REPAIR_TYPE_ID — the repair type to which this transition definition applies; foreign key to CSD_REPAIR_TYPES_B.
• FROM_FLOW_STATUS_ID — the status the entity must currently hold for the transition to be valid.
• TO_FLOW_STATUS_ID — the status the entity moves to once the transition completes.
• WF_ITEM_TYPE and WF_PROCESS_NAME — identify and name the Oracle Workflow process launched at the moment of the status transition.
• REASON_REQUIRED_FLAG — controls whether the user must supply a reason when performing the transition.
• CAPTURE_ACTIVITY_FLAG — controls whether an activity record is logged for the transition.
• ALLOW_ALL_RESP_FLAG — indicates whether every responsibility may perform the transition or only a restricted set.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard "Who" audit columns.

Common Use Cases and Queries

The most frequent requirement is to enumerate the valid transitions available from a given status for a repair type, typically to drive a status-change list of values or a validation before update:

• Listing all transitions for a repair type:

  SELECT FLWSTS_TRAN_ID, FROM_FLOW_STATUS_ID, TO_FLOW_STATUS_ID,
         WF_ITEM_TYPE, WF_PROCESS_NAME, REASON_REQUIRED_FLAG
    FROM CSD.CSD_FLWSTS_TRANS_B
   WHERE REPAIR_TYPE_ID = :p_repair_type_id;

• Validating a proposed transition:

  SELECT COUNT(*) FROM CSD.CSD_FLWSTS_TRANS_B
   WHERE REPAIR_TYPE_ID = :p_repair_type
     AND FROM_FLOW_STATUS_ID = :p_from
     AND TO_FLOW_STATUS_ID = :p_to;

• Auditing which transitions launch workflow or require a reason:

  SELECT REPAIR_TYPE_ID, FROM_FLOW_STATUS_ID, TO_FLOW_STATUS_ID
    FROM CSD.CSD_FLWSTS_TRANS_B
   WHERE REASON_REQUIRED_FLAG = 'Y'
      OR WF_PROCESS_NAME IS NOT NULL;

Reporting scenarios include documenting the repair lifecycle configuration per repair type, reconciling configured transitions against those actually used in repair transactions, and reviewing which transitions bypass responsibility-level restrictions.

Related Objects

The documented foreign key relates this table to the repair-type definition table, which is the principal parent:

• CSD.CSD_REPAIR_TYPES_B — joined via REPAIR_TYPE_ID; supplies the repair type name and context for each transition definition.
• CSD_REPAIR_TYPES_TL — the translated name table for repair types, typically joined through CSD_REPAIR_TYPES_B.
• Flow status lookup and status-definition tables in the CSD schema — referenced through FROM_FLOW_STATUS_ID and TO_FLOW_STATUS_ID to resolve human-readable status names.
• Depot Repair transaction tables that record the actual status history of repair orders and repair lines; these reference the transition configuration when validating and logging each movement.
• Oracle Workflow tables (WF_ITEM_TYPES, WF_PROCESS_ACTIVITIES) — resolved through WF_ITEM_TYPE and WF_PROCESS_NAME to describe the workflow triggered by the transition.
• The CSD_FLWSTS_TRANS_B unique indexes CSD_FLWSTS_TRANS_B_U1 and CSD_FLWSTS_TRANS_B_U2, which enforce and support the surrogate and business keys respectively.