View: OKS_SERV_HDR_V

Product:	OKS - Service Contracts
Description:	View for Service Items
Implementation/DBA Data:	APPS.OKS_SERV_HDR_V

View Text

SELECT DISTINCT AVL.OBJECT1_ID1 SERVICE_ITEM_ID
, SRV.NAME SERVICE_ITEM
, SRV.DESCRIPTION DESCRIPTION
, SRV.ORGANIZATION_ID ORGANIZATION_ID
FROM OKS_SERV_AVAILS AVL
, OKX_SYSTEM_ITEMS_V SRV
WHERE AVL.OBJECT1_ID1 = SRV.ID1
AND SRV. VENDOR_WARRANTY_FLAG = 'N'
AND SRV.SERVICE_ITEM_FLAG = 'Y'

Columns