View: OKL_RA_TERRITORIES_UV

Product:	OKL - Leasing and Finance Management
Description:	User interface view for sales territories list of values
Implementation/DBA Data:	APPS.OKL_RA_TERRITORIES_UV

View Text

SELECT RAT.TERRITORY_ID TERRITORY_ID
, DECODE(RAT.SEGMENT1
, NULL
, NULL
, LTRIM(RTRIM(RAT.SEGMENT1
, ' ')
, ' '))|| DECODE(RAT.SEGMENT2
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT2
, ' ')
, ' '))|| DECODE(RAT.SEGMENT3
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT3
, ' ')
, ' '))|| DECODE(RAT.SEGMENT4
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT4
, ' ')
, ' '))|| DECODE(RAT.SEGMENT5
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT5
, ' ')
, ' '))|| DECODE(RAT.SEGMENT6
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT6
, ' ')
, ' '))|| DECODE(RAT.SEGMENT7
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT7
, ' ')
, ' '))|| DECODE(RAT.SEGMENT8
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT8
, ' ')
, ' '))|| DECODE(RAT.SEGMENT9
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT9
, ' ')
, ' '))|| DECODE(RAT.SEGMENT10
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT10
, ' ')
, ' '))|| DECODE(RAT.SEGMENT11
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT11
, ' ')
, ' '))|| DECODE(RAT.SEGMENT12
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT12
, ' ')
, ' '))|| DECODE(RAT.SEGMENT13
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT13
, ' ')
, ' '))|| DECODE(RAT.SEGMENT14
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT14
, ' ')
, ' '))|| DECODE(RAT.SEGMENT15
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT15
, ' ')
, ' '))|| DECODE(RAT.SEGMENT16
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT16
, ' ')
, ' '))|| DECODE(RAT.SEGMENT17
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT17
, ' ')
, ' '))|| DECODE(RAT.SEGMENT18
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT18
, ' ')
, ' '))|| DECODE(RAT.SEGMENT19
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT19
, ' ')
, ' '))|| DECODE(RAT.SEGMENT20
, NULL
, NULL
, '.'||LTRIM(RTRIM(RAT.SEGMENT20
, ' ')
, ' ')) CONCAT_SEGMENTS
, RAT.NAME NAME
, RAT.DESCRIPTION DESCRIPTION
FROM RA_TERRITORIES RAT
WHERE RAT.ENABLED_FLAG = 'Y'
AND RAT.STATUS = 'A'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(RAT.START_DATE_ACTIVE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(RAT.END_DATE_ACTIVE)
, TRUNC(SYSDATE))

Columns