View: OKE_TERMINATE_LINES_V

Product:	OKE - Project Contracts
Description:	For the Terminate Form to display the lines available to terminate
Implementation/DBA Data:	APPS.OKE_TERMINATE_LINES_V

View Text

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' )

Columns