VIEW: APPS.OKL_CS_CONT_ASSETS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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