View: OKL_ASSET_KEY_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	Asset Key List of Values UI View
Implementation/DBA Data:	APPS.OKL_ASSET_KEY_LOV_UV

View Text

SELECT FAK.CODE_COMBINATION_ID CODE_COMBINATION_ID
, DECODE(FAK.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(FAK.SEGMENT1
, ' ')
, ' '))|| DECODE(FAK.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT2
, ' ')
, ' '))|| DECODE(FAK.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT3
, ' ')
, ' '))|| DECODE(FAK.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT4
, ' ')
, ' '))|| DECODE(FAK.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT5
, ' ')
, ' '))|| DECODE(FAK.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT6
, ' ')
, ' '))|| DECODE(FAK.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT7
, ' ')
, ' '))|| DECODE(FAK.SEGMENT8
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT8
, ' ')
, ' '))|| DECODE(FAK.SEGMENT9
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT9
, ' ')
, ' '))|| DECODE(FAK.SEGMENT10
, NULL
, NULL
, '.'||LTRIM(RTRIM(FAK.SEGMENT10
, ' ')
, ' ')) CONCATENATED_SEGMENTS
FROM FA_ASSET_KEYWORDS FAK
WHERE FAK.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(FAK.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(FAK.END_DATE_ACTIVE
, SYSDATE))

Columns