SELECT CHRB.ID ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CTLB.MEANING STATUS FROM OKC_STATUSES_TL CTLB,OKC_K_HEADERS_B CHRB WHERE CHRB.STS_CODE = CTLB.CODE AND CHRB.SCS_CODE = 'LEASE' AND CTLB.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted
SELECT CHRB.ID ID , CHRB.CONTRACT_NUMBER CONTRACT_NUMBER , CTLB.MEANING STATUS FROM OKC_STATUSES_TL CTLB , OKC_K_HEADERS_B CHRB WHERE CHRB.STS_CODE = CTLB.CODE AND CHRB.SCS_CODE = 'LEASE' AND CTLB.LANGUAGE = USERENV('LANG')