View: OKC_SRS_REN_CONTRACT_NUM_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_SRS_REN_CONTRACT_NUM_V

View Text

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'

Columns