Search Results csd_rule_conditions_b




Overview
Explore in AI Chat

Overview

CSD_RULE_CONDITIONS_B is a core configuration table within the Oracle E-Business Suite Depot Repair (CSD) module. It stores the condition definitions that, together with the parent rule header, govern how Depot Repair evaluates and applies business rules during repair order processing. Each row represents a single condition line belonging to a rule defined in CSD_RULES_B, expressed through a flexible set of descriptive and attribute columns. In releases 12.1.1 and 12.2.2, the table resides in the CSD schema and is exposed to both the forms-based setup UI and concurrent/reporting logic.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. It carries descriptive, versioned business attributes keyed to an owning rule, rather than acting as an independent hub or a pure many-to-many link. This suggests the natural modeling home for the table is a satellite attached to the CSD_RULES_B business hub.

Key Information Stored

The table contains 28 documented columns in 12.2.2. The most significant are:

Notably, the condition specifics are almost entirely flexfield-driven, so downstream reporting generally reads the DFF segments rather than named business columns.

Common Use Cases and Queries

Typical uses include auditing which conditions belong to a given rule, migrating rule configuration between environments, and diagnosing why a Depot Repair rule fired or failed. A basic join pattern is:

SELECT c.RULE_CONDITION_ID, c.RULE_ID, c.ATTRIBUTE_CATEGORY, c.ATTRIBUTE1, c.ATTRIBUTE2
FROM CSD.CSD_RULE_CONDITIONS_B c, CSD.CSD_RULES_B r
WHERE c.RULE_ID = r.RULE_ID
AND r.RULE_ID = :p_rule_id;

Reporting queries commonly filter on ATTRIBUTE_CATEGORY to isolate condition types, and aggregate counts per RULE_ID to identify heavily conditioned rules. Because the table is DFF-centric, extraction tools should join the DFF definitions for human-readable labels.

Related Objects

  • CSD_RULES_B — the parent rule header. Joined on RULE_ID; the mandatory FK in this table.
  • CSD_RULES_TL — translated rule names/descriptions, providing readable rule labels for reports.
  • CSD_RULES_B_PK — the parent primary key referenced by the CSD_RULE_CONDITIONS_B.RULE_ID foreign key.
  • CSD_RULE_CONDITIONS_B_PK1 / _U1 — primary and unique indexes enforcing RULE_CONDITION_ID uniqueness.
  • CSD Depot Repair setup UI (Rules form) — the primary maintenance interface that inserts, updates, and deletes condition rows.
  • FND descriptive flexfield tables (FND_FLEX_VALUES / FND_FLEX_VALUE_SETS) — supply the definitions and value sets for ATTRIBUTE and SOO_ATTRIBUTE segments.

Together these objects form the rule-configuration cluster used by Depot Repair's eligibility and pricing logic.