View: OKL_CS_CONT_ASSETS_UV

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

View Text

SELECT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, ALV.ASSET_NUMBER ASSET_NUMBER
, ALV.SERIAL_NUMBER SERIAL_NUMBER
, ALV.MODEL_NUMBER MODEL_NUMBER
, ALV.DESCRIPTION ASSET_DESCRIPTION
, ALV.ASSET_ID ASSET_ID
, ALV.ORG_ID REGISTRATION
FROM OKL_CS_ASSET_LINES_V ALV
, OKC_K_HEADERS_V CHR
WHERE ALV.DNZ_CHR_ID = CHR.ID
AND CHR.STS_CODE != 'ABANOINED' ORDER BY CHR.ID

Columns