Search Results csd_aging_thresholds_pk1

Overview

CSD_AGING_THRESHOLDS_B is the foundational setup table within the Oracle EBS Depot Repair (CSD) module responsible for storing aging threshold definitions. In the context of depot repair operations, aging thresholds govern the calculation of elapsed time against repair orders, units, or components, enabling organizations to categorize, escalate, or report on repair activity based on configurable day counts. This table holds the base (non-translated) definition rows and serves as the anchor for aging configuration used throughout the Depot Repair workflow.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is treated as standalone. From a dimensional modeling perspective, the table functions primarily as a reference or setup entity rather than a transactional hub, link, or satellite. It carries descriptive configuration attributes keyed to repair types and inventory dimensions, making it a low-volatility setup object that downstream processes read rather than mutate at high frequency.

Key Information Stored

The table is documented with 31 physical columns in the ETRM 12.2.2 schema (owner: CSD). The most significant columns and their roles are:

• AGING_THRESHOLD_ID — The surrogate primary key, enforced by constraint CSD_AGING_THRESHOLDS_PK1. It uniquely identifies each aging threshold definition row.
• REPAIR_TYPE_ID — A foreign key referencing CSD_REPAIR_TYPES_B. This ties the threshold definition to a specific repair type, forming a key business-key candidate in combination with other scope columns.
• INVENTORY_ORG_ID — Scopes the threshold to a specific inventory organization, enabling organization-specific aging rules.
• ITEM_CATEGORY_ID — Narrows the threshold to a category of items.
• INVENTORY_ITEM_ID — Narrows the threshold to a specific inventory item where item-level aging control is required.
• ITEM_REVISION — Further qualifies the definition by item revision.
• REPAIR_STATUS — Indicates the repair status the aging definition applies to, allowing status-sensitive aging logic.
• THRESHOLD_DAYS — The core business value: the number of days defining the aging boundary or bucket.
• FLOW_STATUS_ID — References the flow status, integrating aging setup with the Depot Repair flow-status framework.
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS auditing columns recording who created and last modified each row and when.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) columns allowing customer-specific extension of the aging definition without schema change.

The combination of REPAIR_TYPE_ID with scoping columns such as INVENTORY_ORG_ID, ITEM_CATEGORY_ID, INVENTORY_ITEM_ID, and REPAIR_STATUS represents the logical business key, while AGING_THRESHOLD_ID remains the documented surrogate primary key.

Common Use Cases and Queries

Aging threshold setup drives reporting on how long repair orders or units remain in a given state before crossing a defined day boundary. Typical scenarios include identifying repair units exceeding a threshold for escalation, tuning organization-specific aging rules, and validating that no duplicate or conflicting thresholds exist for the same repair type and status combination.

A basic query to list all aging definitions for a repair type:

• SELECT AGING_THRESHOLD_ID, REPAIR_TYPE_ID, INVENTORY_ORG_ID, REPAIR_STATUS, THRESHOLD_DAYS FROM CSD.CSD_AGING_THRESHOLDS_B WHERE REPAIR_TYPE_ID = :p_repair_type_id ORDER BY THRESHOLD_DAYS;

Joining to the repair type base table to resolve the descriptive name:

• SELECT a.THRESHOLD_DAYS, t.REPAIR_TYPE FROM CSD.CSD_AGING_THRESHOLDS_B a, CSD.CSD_REPAIR_TYPES_B t WHERE a.REPAIR_TYPE_ID = t.REPAIR_TYPE_ID AND a.INVENTORY_ORG_ID = :p_org_id;

Reporting uses include aging bucket analysis, SLA monitoring for depot repair turnaround, and configuration audits ensuring threshold coverage across organizations and repair statuses.

Related Objects

• CSD_REPAIR_TYPES_B — Referenced via REPAIR_TYPE_ID. This is the parent setup table defining repair types and is the most significant related object.
• CSD_AGING_THRESHOLDS_TL — The translated (language) companion table, keyed by AGING_THRESHOLD_ID, holding translated descriptive text for multi-language deployments.
• CSD_REPAIR_ORDERS — The transactional depot repair order table whose aging logic consumes these threshold definitions.
• CSD_REPAIR_TYPES_TL — Provides translated repair type descriptions for reporting joins.
• FND_FLOW_STATUS / CSD flow status entities — Referenced by FLOW_STATUS_ID for status-based aging logic.
• MTL_SYSTEM_ITEMS_B and MTL_ITEM_CATEGORIES — Referenced indirectly through INVENTORY_ITEM_ID and ITEM_CATEGORY_ID for item-scoped thresholds.

Because the object is classified as standalone with respect to its mined key structure, its principal dependency is the REPAIR_TYPE_ID foreign key to CSD_REPAIR_TYPES_B, with the remaining associations realized through inventory and flow-status reference identifiers rather than enforced relationships.