VIEW: APPS.OKS_SERV_HDR_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'