Results for “link_type_id”

50+ results




Overview
Explore in AI Chat

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

Overview

CS_SR_LINK_TYPES_B is a Service (CS) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines every valid relationship type that may exist between a service request and another service request, or between a service request and another business object. Each row represents one directed relationship definition — for example, a parent-to-child incident association or a service request to defect linkage. Because these definitions are configurable rather than hard-coded, the table drives relationship validation, reciprocal pairing, and action/trigger behavior throughout the Service Request lifecycle.

The table follows the standard EBS translated reference-table pattern: base (B) rows hold the relationship definition itself, while the user-facing description text is maintained in the companion translation table CS_SR_LINK_TYPES_TL. With 30 documented columns and a functional focus on relationship semantics rather than transactional volume, the heuristic Data Vault classification is hub-leaning: LINK_TYPE_ID functions as the durable business key around which reciprocal references, validity rules, and dependent link records are organized.

Key Information Stored

  • LINK_TYPE_ID — Surrogate primary key enforced by CS_SR_LINK_TYPES_B_PK; also the leading column of unique index CS_SR_LINK_TYPES_B_U1 (LINK_TYPE_ID, ZD_EDITION_NAME), which is the documented business-key candidate.
  • RECIPROCAL_LINK_TYPE_ID — Self-referencing foreign key to CS_SR_LINK_TYPES_B, identifying the inverse relationship type (for example, the "linked from" counterpart of a "linked to" definition).
  • START_DATE_ACTIVE / END_DATE_ACTIVE — Date-effective range controlling when the relationship type is available for use.
  • SEEDED_FLAG — Indicates whether the row was delivered as seeded Oracle data or created by the customer, which governs whether it can be modified or deleted.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-organization/security-group access partitioning.
  • APPLICATION_ID — Identifies the owning application, consistent with the standard EBS WHO column set.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/ADF framework during concurrent updates.
  • ZD_EDITION_NAME — Edition column supporting Online Patching (Edition-Based Redefinition) in 12.2.x.
  • ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CONTEXT — Descriptive flexfield (DFF) storage for customer-defined extension attributes.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking row provenance and change history.

Common Use Cases and Queries

The most frequent requirement is resolving a link type ID into a display name, which must join to the translation table and respect the session language:

  • Listing all active relationship types: SELECT link_type_id, reciprocal_link_type_id FROM cs_sr_link_types_b WHERE NVL(end_date_active, SYSDATE+1) > SYSDATE.
  • Retrieving user-facing names: join CS_SR_LINK_TYPES_TL on LINK_TYPE_ID and filter on the appropriate LANGUAGE value.
  • Auditing reciprocal pairs: self-join CS_SR_LINK_TYPES_B to itself on RECIPROCAL_LINK_TYPE_ID to confirm that A points to B and B points back to A.
  • Reporting on actual relationship usage: joining CS_INCIDENT_LINKS to this table on LINK_TYPE_ID to count or categorize how service requests are linked in production.
  • Identifying customizations: filtering on SEEDED_FLAG to isolate customer-defined relationship types from seeded ones before upgrades or patching.

Related Objects

  • CS_INCIDENT_LINKS — References CS_SR_LINK_TYPES_B via LINK_TYPE_ID; stores the actual link instances between incidents/service requests.
  • CS_SR_LINK_TYPES_TL — Translation table joined on LINK_TYPE_ID; holds the language-specific relationship description.
  • CS_SR_LINK_VALID_OBJ — Joined on LINK_TYPE_ID; defines which business object types are valid counterparts for a given relationship type.
  • CS_SR_ACTION_DETAILS — References RELATIONSHIP_TYPE_ID; configures actions driven by a relationship type.
  • CS_SR_ACTION_TRIGGERS — References RELATIONSHIP_TYPE_ID; defines trigger conditions tied to the relationship.
  • CS_SR_LINK_TYPES_B — Self-referencing through RECIPROCAL_LINK_TYPE_ID to establish inverse pairings.
  • FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for access control partitioning.