Search Results csd_sc_domains_v




Overview
Explore in AI Chat

Overview

The CSD_SC_DOMAINS_V view is an Oracle E-Business Suite 12.1.1 and 12.2.2 database object owned by the APPS schema and shipped as part of the CSD (Depot Repair) product family. Its documented purpose is to display the mapping between Service Codes and Product Categories. In the Depot Repair data model, the underlying CSD_SC_DOMAINS table stores the domain definitions that associate a service code with a particular domain type — most notably an inventory item or a product category. The view denormalizes these mappings by resolving foreign keys into human-readable values, thereby presenting a single, query-friendly row that carries both the raw identifiers and the descriptive names of the referenced items, categories, category sets, and lookup meanings.

Because the business meaning of the domain record depends on the DOMAIN_TYPE_CODE (for example, whether the domain is an item or a category), consumers would otherwise need to join multiple inventory and lookup views themselves. CSD_SC_DOMAINS_V encapsulates those joins, making it suitable for reporting, concurrent program queries, extensions, and integration interfaces that must determine which product categories or items a given service code applies to. The object holds a VALID status, and the ETRM lists it as a view rather than a table, so it is strictly a read-only projection over its base objects.

Underlying Base Objects

The view text is defined over a join of the following documented objects:

All joins to the inventory and category views are outer joins (denoted by (+)), meaning a domain row is retained even when the referenced item or category cannot be resolved. The item join is additionally guarded by a DECODE construct so that the item linkage applies only when DOMAIN_TYPE_CODE equals 'ITEM'.

Key Columns

Common Use Cases and Queries

Typical uses include validating which categories a service code is restricted to, driving Depot Repair eligibility rules, and exposing domain mappings to downstream reporting. A representative query listing item domains for a service code follows:

  • SELECT SC_DOMAIN_ID, SERVICE_CODE_ID, DOMAIN_TYPE_MEANING, INVENTORY_ITEM_NAME, CATEGORY_NAME, CATEGORY_SET_NAME FROM CSD_SC_DOMAINS_V WHERE SERVICE_CODE_ID = :p_service_code_id AND DOMAIN_TYPE_CODE = 'ITEM' ORDER BY INVENTORY_ITEM_NAME;
  • SELECT SERVICE_CODE_ID, CATEGORY_NAME, CATEGORY_SET_NAME FROM CSD_SC_DOMAINS_V WHERE DOMAIN_TYPE_CODE = 'CATEGORY';
  • SELECT DOMAIN_TYPE_MEANING, COUNT(*) FROM CSD_SC_DOMAINS_V GROUP BY DOMAIN_TYPE_MEANING;

Because the view relies on outer joins and a lookup join on CSD_DOMAIN_TYPE_CODE, reports should anticipate NULL descriptive columns where an item or category reference is missing or unresolvable.