[Home] [Help]
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
Name |
SERVICE_ITEM_ID |
SERVICE_ITEM |
DESCRIPTION |
ORGANIZATION_ID |