VIEW: APPS.OKC_CONT_NUM_DISTINCT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'