View: OKR_CONTRACT_TERMINATION_DV

View Text

SELECT CHRB.ID CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.SCS_CODE SCS_CODE
, CHRB.STS_CODE STS_CODE
, STST.MEANING STS_MEANING
, NVL(CHRB.CONTRACT_NUMBER_MODIFIER
, 'T' || TO_CHAR(SYSDATE
, 'DD-MON-YYYY HH:MI:SS')) CONTRACT_NUMBER_MODIFIER
, CHRB.END_DATE END_DATE
, CHRB.DATE_TERMINATED DATE_TERMINATED
, CHRB.TRN_CODE TRN_CODE
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STST
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHRB.STS_CODE = STSB.CODE
AND STSB.CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND STSB.STE_CODE IN ('ACTIVE'
, 'HOLD'
, 'SIGNED')
AND CHRB.STS_CODE NOT IN ( 'QA_HOLD')
AND CHRB.END_DATE IS NOT NULL
AND CHRB.DATE_TERMINATED IS NULL
AND CHRB.TEMPLATE_YN = 'N'
AND CHRB.END_DATE >= SYSDATE

Columns