Search Results res_dt_calc_point

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSD.CSD_REPAIR_TYPES_B is the base configuration table within the Oracle E-Business Suite Depot Repair (CSD) module that stores all repair type definitions. In EBS 12.1.1 and 12.2.2, it functions as the master repository of repair type metadata that governs how a repair order flows through the depot repair lifecycle. Each row defines a distinct repair type, including its associated workflow, billing rules, pricing, and sales order integration behaviors. The table is seeded with Oracle-provided repair types and can be extended with user-defined entries.

From a Data Vault modeling perspective, the mined foreign-key structure classifies CSD_REPAIR_TYPES_B as hub-leaning. This suggests that the table acts primarily as a business entity hub, holding a stable, unique identifier (REPAIR_TYPE_ID) around which descriptive and transactional satellites and link tables cluster. It is not a pure transactional fact table but rather a reference/configuration entity that many downstream objects depend upon.

Key Information Stored

The table contains 51 documented columns. The most significant include:

• REPAIR_TYPE_ID — Surrogate primary key (CSD_REPAIR_TYPES_B_PK) uniquely identifying each repair type; also part of the unique index CSD_REPAIR_TYPES_B_U1 alongside ZD_EDITION_NAME.
• REPAIR_TYPE_REF — Business-key candidate; the user-facing reference code for the repair type.
• WORKFLOW_ITEM_TYPE — Foreign key to WF_ITEM_TYPES, linking the repair type to the Oracle Workflow item type that drives its process flow.
• BUSINESS_PROCESS_ID — Foreign key to CS_BUSINESS_PROCESSES, defining the business process governing the repair.
• PRICE_LIST_HEADER_ID — Foreign key to QP_LIST_HEADERS_B, associating an Advanced Pricing price list for charge calculation.
• CPR_TXN_BILLING_TYPE_ID — Foreign key to CS_TXN_BILLING_TYPES, specifying the billing type for customer-paid repairs.
• REPAIR_MODE — Indicates the mode of repair processing.
• SEEDED_FLAG — Distinguishes Oracle-seeded repair types from customer-defined ones.
• AUTO_PROCESS_RMA — Controls automatic RMA processing behavior.
• INTERFACE_TO_OM_FLAG and the related sales order flags (BOOK_SALES_ORDER_FLAG, RELEASE_SALES_ORDER_FLAG, SHIP_SALES_ORDER_FLAG) — Determine Order Management integration.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating for the repair type.
• START_FLOW_STATUS_ID — Initial flow status in the repair workflow.
• ZD_EDITION_NAME — Editioning column supporting EBS 12.2 online patching.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the ORM framework.

Common Use Cases and Queries

Typical reporting and configuration audits query this table to validate repair type setup before creating repair orders. A common pattern joins the translation table to present user-facing names:

• Listing active repair types: SELECT REPAIR_TYPE_ID, REPAIR_TYPE_REF FROM CSD_REPAIR_TYPES_B WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE;
• Resolving repair type names via CSD_REPAIR_TYPES_TL using REPAIR_TYPE_ID.
• Auditing which repair types interface to Order Management by filtering on INTERFACE_TO_OM_FLAG.
• Reconciling repair volume by type through CSD_REPAIRS.REPAIR_TYPE_ID.
• Reviewing billing configuration by joining to CS_TXN_BILLING_TYPES.
• Feeding reporting materialized views such as ISC_DR_CURR_01_MV and ISC_DR_COSTS_01_MV, which denormalize repair type attributes for analytics.

Related Objects

The most significant objects dependent on or referenced by this table include:

• CSD_REPAIRS — Joins on REPAIR_TYPE_ID; the transactional repair order records.
• CSD_REPAIR_TYPES_TL — Translation table keyed by REPAIR_TYPE_ID, providing multilingual descriptions.
• CSD_REPAIR_TYPES_SAR — Sub-account/segment association table.
• CSD_REPAIR_ORDER_GROUPS — Groups repair orders by REPAIR_TYPE_ID.
• CSD_FLWSTS_TRANS_B — Flow status transitions keyed by REPAIR_TYPE_ID.
• WF_ITEM_TYPES — Referenced via WORKFLOW_ITEM_TYPE.
• CS_BUSINESS_PROCESSES — Referenced via BUSINESS_PROCESS_ID.
• QP_LIST_HEADERS_B — Referenced via PRICE_LIST_HEADER_ID.
• CS_TXN_BILLING_TYPES — Referenced via CPR_TXN_BILLING_TYPE_ID.
• ISC_DR_*_MV materialized views — Analytic views (current, backlog, MTTR, costs, charges) keyed by REPAIR_TYPE_ID.