View: OKL_STRMS_STD_HDR_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_STRMS_STD_HDR_UV

View Text

SELECT CKRV.ID KHR_ID
, CKRV.CURRENCY_CODE CURRENCY_CODE
, CKRV.CONTRACT_NUMBER CONTRACT_NUMBER
, CKRV.SHORT_DESCRIPTION SHORT_DESCRIPTION
, OXPV.NAME CUST_NAME
, STST.MEANING STATUS
FROM OKC_K_HEADERS_V CKRV
, OKX_PARTIES_V OXPV
, OKC_K_PARTY_ROLES_V CPLV
, OKC_STATUSES_TL STST
WHERE CKRV.ID = CPLV.CHR_ID
AND CPLV.RLE_CODE = 'LESSEE'
AND CPLV.OBJECT1_ID1 = OXPV.ID1
AND CPLV.OBJECT1_ID2 = OXPV.ID2
AND CKRV.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')

Columns