VIEW: APPS.OKE_TERMINATE_LINES_V

Source

View Text - Preformatted

SELECT CL.DNZ_CHR_ID , CL.ID , CL.LINE_NUMBER , CLT.ITEM_DESCRIPTION , CL.CLE_ID FROM OKC_K_LINES_B CL , OKC_K_LINES_TL CLT , OKC_STATUSES_V ST WHERE CL.ID = CLT.ID AND CLT.LANGUAGE = USERENV('LANG') AND ST.CODE = CL.STS_CODE AND ST.STE_CODE IN ( 'ACTIVE' , 'HOLD', ' SIGNED' , 'EXPIRED' )

View Text - HTML Formatted

SELECT CL.DNZ_CHR_ID
, CL.ID
, CL.LINE_NUMBER
, CLT.ITEM_DESCRIPTION
, CL.CLE_ID
FROM OKC_K_LINES_B CL
, OKC_K_LINES_TL CLT
, OKC_STATUSES_V ST
WHERE CL.ID = CLT.ID
AND CLT.LANGUAGE = USERENV('LANG')
AND ST.CODE = CL.STS_CODE
AND ST.STE_CODE IN ( 'ACTIVE'
, 'HOLD'
, ' SIGNED'
, 'EXPIRED' )