Search Results csd_repair_flow_statuses_v




Overview
Explore in AI Chat

Overview

The CSD_REPAIR_FLOW_STATUSES_V view is a reporting and integration object owned by the APPS schema within the Oracle E-Business Suite Depot Repair (CSD) module. It exposes the set of repair flow statuses that drive the lifecycle of a repair order, presenting each flow status alongside its user-facing meaning, description, external display status, and associated repair status. The view is defined over the flow status base and translation tables and joins them to two seeded FND_LOOKUPS lookup types, CSD_REPAIR_FLOW_STATUS and CSD_REPAIR_STATUS, so that codes stored on the transactional tables are rendered as descriptive text. Because the view resolves lookup meanings and uses USERENV('LANG') for language selection, it provides multilingual, human-readable output suitable for concurrent programs, Oracle Reports, OAF pages, and inbound or outbound integrations. Users searching for the column FLOW_STATUS_MEANING are typically looking for the descriptive label corresponding to a flow status code, which this view supplies directly.

Underlying Base Objects

The view is defined over the following documented objects:

  • CSD_FLOW_STATUSES_B (SYNONYM) — the base table holding flow status identifiers, codes, seeded flag, object version number, and the descriptive flexfield attribute columns.
  • CSD_FLOW_STATUSES_TL (SYNONYM) — the translation table providing the language-specific external display status.
  • FND_LOOKUPS (VIEW) — joined twice: once for the CSD_REPAIR_FLOW_STATUS lookup type to derive the flow status meaning and description, and once for the CSD_REPAIR_STATUS lookup type to derive the associated status code and meaning.
  • FND_GLOBAL (PACKAGE) — supplies USERENV('LANG') semantics for language resolution used in the TL join.

The join predicates link FS_TL.FLOW_STATUS_ID to FS_B.FLOW_STATUS_ID with the TL row filtered by FS_TL.LANGUAGE = USERENV('LANG'), connect FS_B.FLOW_STATUS_CODE to FS_LKUP.LOOKUP_CODE where FS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS', and connect FS_B.STATUS_CODE to SS_LKUP.LOOKUP_CODE where SS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_STATUS'. Rows where FS_B.FLOW_STATUS_CODE = 'D' are excluded, filtering out deleted flow statuses.

Key Columns

  • FLOW_STATUS_ID — surrogate primary key of the flow status.
  • FLOW_STATUS_CODE — the internal code for the flow status.
  • FLOW_STATUS_MEANING — the lookup meaning from FND_LOOKUPS; this is the descriptive label most queries target.
  • FLOW_STATUS_DESC — the lookup description for the flow status.
  • EXTERNAL_DISPLAY_STATUS — the translated, externally visible status text from the TL table.
  • STATUS_CODE and STATUS_MEANING — the associated repair status code and its lookup meaning.
  • SEEDED_FLAG and OBJECT_VERSION_NUMBER — seeded/seed-data indicator and row version for concurrency control.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments available for extensibility.

Common Use Cases and Queries

Typical scenarios include populating LOVs and drop-downs for repair flow statuses, producing status reference listings, and resolving a stored flow status code to its meaning in integrations and reports.

To list all available flow statuses with their meanings:

SELECT flow_status_code, flow_status_meaning, status_meaning
FROM   apps.csd_repair_flow_statuses_v
ORDER  BY flow_status_code;

To resolve a specific code to its meaning (the common use when searching for flow_status_meaning):

SELECT flow_status_meaning, external_display_status
FROM   apps.csd_repair_flow_statuses_v
WHERE  flow_status_code = :p_flow_status_code;

To filter only user-defined (non-seeded) statuses for administration purposes:

SELECT flow_status_code, flow_status_meaning
FROM   apps.csd_repair_flow_statuses_v
WHERE  seeded_flag = 'N';

Because the view excludes deleted codes and resolves the current session language automatically, it is the preferred source for both end-user reporting and programmatic lookup resolution in Depot Repair.