SELECT ROWID, LOCATION_CONTEXT, (DECODE (LOCATION_CONTEXT, '1', LOCATION_ID_SEGMENT_1, NULL)), (DECODE (LOCATION_CONTEXT, '2', LOCATION_ID_SEGMENT_1, '101', LOCATION_ID_SEGMENT_1, NULL)), (DECODE (LOCATION_CONTEXT, '101', LOCATION_ID_SEGMENT_2, NULL)), (DECODE (LOCATION_CONTEXT, '4', LOCATION_ID_SEGMENT_1, '3', LOCATION_ID_SEGMENT_2, '2', LOCATION_ID_SEGMENT_2, '101', LOCATION_ID_SEGMENT_3, NULL)), (DECODE (LOCATION_CONTEXT, '5', LOCATION_ID_SEGMENT_1, '3', LOCATION_ID_SEGMENT_1, NULL)),
(DECODE (LOCATION_CONTEXT,
'1', LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1,
'101', LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1 || '-' || LOCATION_ID_SEGMENT_2 || '-' || LOCATION_ID_SEGMENT_3,
'2', LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1 || '-' || LOCATION_ID_SEGMENT_2,
'3', LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1 || '-' || LOCATION_ID_SEGMENT_2,
'4', LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1,
'5', LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1, NULL))
FROM RA_TAX_EXEMPTIONS_ALL
SELECT ROWID
, LOCATION_CONTEXT
, (DECODE (LOCATION_CONTEXT
, '1'
, LOCATION_ID_SEGMENT_1
, NULL))
, (DECODE (LOCATION_CONTEXT
, '2'
, LOCATION_ID_SEGMENT_1
, '101'
, LOCATION_ID_SEGMENT_1
, NULL))
, (DECODE (LOCATION_CONTEXT
, '101'
, LOCATION_ID_SEGMENT_2
, NULL))
, (DECODE (LOCATION_CONTEXT
, '4'
, LOCATION_ID_SEGMENT_1
, '3'
, LOCATION_ID_SEGMENT_2
, '2'
, LOCATION_ID_SEGMENT_2
, '101'
, LOCATION_ID_SEGMENT_3
, NULL))
, (DECODE (LOCATION_CONTEXT
, '5'
, LOCATION_ID_SEGMENT_1
, '3'
, LOCATION_ID_SEGMENT_1
, NULL))
,
(DECODE (LOCATION_CONTEXT
,
'1'
, LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1
,
'101'
, LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1 || '-' || LOCATION_ID_SEGMENT_2 || '-' || LOCATION_ID_SEGMENT_3
,
'2'
, LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1 || '-' || LOCATION_ID_SEGMENT_2
,
'3'
, LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1 || '-' || LOCATION_ID_SEGMENT_2
,
'4'
, LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1
,
'5'
, LOCATION_CONTEXT || '-' || LOCATION_ID_SEGMENT_1
, NULL))
FROM RA_TAX_EXEMPTIONS_ALL
|
|
|