View: OKS_CONTRACT_NUMBER_V

Product:	OKS - Service Contracts
Description:	View Is Used For Quote Printing LOV to display distinct Contract Numbers
Implementation/DBA Data:	APPS.OKS_CONTRACT_NUMBER_V

View Text

SELECT DISTINCT CHRB.CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
WHERE CHRB.ID = CHRT.ID
AND CHRB.SCS_CODE = 'WARRANTY'
AND CHRT.LANGUAGE = USERENV('LANG')

Columns