View: OKC_CONT_NUM_DISTINCT_V

Product:	OKC - Contracts Core
Description:	This view lists unique contract numbers only.
Implementation/DBA Data:	APPS.OKC_CONT_NUM_DISTINCT_V

View Text

SELECT DISTINCT KH.CONTRACT_NUMBER CONTRACT_NUMBER
FROM OKC_SUBCLASSES_B SUB
, OKC_K_HEADERS_B KH
WHERE KH.SCS_CODE = SUB.CODE
AND SUB.CLS_CODE <> 'OKL'
AND OKC_UTIL.GET_K_ACCESS_LEVEL(KH.ID
, KH.SCS_CODE) = 'U'

Columns