VIEW: APPS.OKL_ASSET_KEY_LOV_UV

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))