VIEW: APPS.OKL_RA_TERRITORIES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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