Search Results oks_serv_hdr_v




Overview
Explore in AI Chat

Overview

OKS_SERV_HDR_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Service Contracts (OKS) module. Its documented purpose in ETRM is the presentation of service items — the item master records that a service organization is permitted to sell, cover, or reference on a service contract line. In release 12.1.1 and 12.2.2 the object carries a status of VALID and is exposed to reporting, integration, and extension code under the APPS credentials.

The view does not store data. It is a projection that consolidates item eligibility information held in the Service Contracts availability tables with descriptive attributes sourced from the system item master. This makes it a convenient, single-source lookup for consumers that need to enumerate serviceable items without navigating the underlying availability model or the multi-organization item views directly.

Underlying Base Objects

The documented definition references two objects:

  • OKS_SERV_AVAILS (SYNONYM) — the Service Contracts availability table, which records the association between a contract or coverage context and the item identifiers available to it. The view draws its item key from the column OBJECT1_ID1 in this table.
  • OKX_SYSTEM_ITEMS_V (VIEW) — the item master reporting view. The view reads the item name, description, and organization identifier from this object, matching on the surrogate key ID1.

The join condition is AVL.OBJECT1_ID1 = SRV.ID1. Two filters are applied: SRV.VENDOR_WARRANTY_FLAG = 'N' excludes items flagged as vendor warranty items, and SRV.SERVICE_ITEM_FLAG = 'Y' restricts the result to items explicitly designated as service items. A DISTINCT operator removes duplicate rows produced by the availability join.

Key Columns

  • SERVICE_ITEM_ID — the numeric inventory item identifier, aliased from OKS_SERV_AVAILS.OBJECT1_ID1. This is the primary key value passed to other Service Contracts and Order Management APIs.
  • SERVICE_ITEM — the item name, sourced from OKX_SYSTEM_ITEMS_V.NAME. This is the user-facing concatenated or segmented item name.
  • DESCRIPTION — the item description from the item master, useful for report display and search lists.
  • ORGANIZATION_ID — the inventory organization to which the item belongs, taken from OKX_SYSTEM_ITEMS_V.ORGANIZATION_ID. Because the item master is organization-specific, the same item number can appear once per organization.

Common Use Cases and Queries

The view is most often used to populate service item list-of-values, to validate that an item may be placed on a contract, and to reconcile contract lines against the item master. A typical lookup by item name is:

SELECT service_item_id, service_item, description, organization_id
FROM apps.oks_serv_hdr_v
WHERE service_item LIKE :item_name
ORDER BY service_item;

A second pattern resolves the description for a known identifier:

SELECT service_item, description
FROM apps.oks_serv_hdr_v
WHERE service_item_id = :item_id
AND organization_id = :org_id;

Because the definition embeds the SERVICE_ITEM_FLAG and VENDOR_WARRANTY_FLAG predicates, callers should not expect to see warranty-only or non-service inventory items through this view; those require querying OKX_SYSTEM_ITEMS_V directly. Reporting against this view should also account for the DISTINCT clause, which may collapse multiple availability rows for the same item within a given organization.