View: OKL_OKS_CONTRACTS_ALL_UV

Product:	OKL - Lease and Finance Management
Description:	List of Lease contracts linked to service Contracts
Implementation/DBA Data:	APPS.OKL_OKS_CONTRACTS_ALL_UV

View Text

SELECT RELO.CHR_ID OKL_CHR_ID
, OKLH.CONTRACT_NUMBER
, RELO.OBJECT1_ID1 OKS_CHR_ID
, OKCH.CONTRACT_NUMBER OKS_CONTRACT_NUMBER
, (SELECT MEANING
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE='OKL_CONTRACT_CATEGORY'
AND LOOKUP_CODE='SERVICE'
AND VIEW_APPLICATION_ID = 0 ) CONTRACT_TYPE
, STST.MEANING OKS_STS_CODE
, OKCH.START_DATE OKS_START_DATE
, OKCH.END_DATE OKS_END_DATE
, OKCH.SHORT_DESCRIPTION OKS_SHORT_DESCRIPTION
FROM OKC_K_REL_OBJS_V RELO
, OKC_K_HEADERS_ALL_V OKCH
, OKC_STATUSES_TL STST
, OKL_K_HEADERS_FULL_ALL_V OKLH
WHERE RTY_CODE IN ('OKLSRV'
, 'OKLUBB')
AND RELO.CLE_ID IS NULL
AND JTOT_OBJECT1_CODE = 'OKL_SERVICE'
AND OKCH.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND OKCH.ID = RELO.OBJECT1_ID1
AND OKLH.ID=RELO.CHR_ID

Columns