VIEW: APPS.OKC_SRS_REN_CONTRACT_NUM_V

Source

View Text - Preformatted

SELECT CHR.ID ID, CHR.CONTRACT_NUMBER CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER MODIFIER FROM OKC_K_HEADERS_B CHR,OKC_STATUSES_B STS WHERE chr.sts_code = sts.code and chr.date_renewed IS NULL AND chr.date_terminated IS NULL AND sts.ste_code IN ('ACTIVE', 'SIGNED', 'EXPIRED') AND chr.template_yn = 'N' AND okc_util.get_k_access_level(chr.id, chr.scs_code) = 'U'

View Text - HTML Formatted

SELECT CHR.ID ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.CONTRACT_NUMBER_MODIFIER MODIFIER
FROM OKC_K_HEADERS_B CHR
, OKC_STATUSES_B STS
WHERE CHR.STS_CODE = STS.CODE
AND CHR.DATE_RENEWED IS NULL
AND CHR.DATE_TERMINATED IS NULL
AND STS.STE_CODE IN ('ACTIVE'
, 'SIGNED'
, 'EXPIRED')
AND CHR.TEMPLATE_YN = 'N'
AND OKC_UTIL.GET_K_ACCESS_LEVEL(CHR.ID
, CHR.SCS_CODE) = 'U'