SELECT ROWID, LOCATION_ID, LOCATION_STRUCTURE_ID,
(DECODE(LOCATION_STRUCTURE_ID,
1, LOCATION_ID_SEGMENT_1,
2, LOCATION_ID_SEGMENT_1 || '.' || LOCATION_ID_SEGMENT_2,
3, LOCATION_ID_SEGMENT_1 || '.' || LOCATION_ID_SEGMENT_2,
4, LOCATION_ID_SEGMENT_1,
5, LOCATION_ID_SEGMENT_1,
101, LOCATION_ID_SEGMENT_1 || '.' || LOCATION_ID_SEGMENT_2 || '.' || LOCATION_ID_SEGMENT_3, NULL)),
(DECODE(LOCATION_STRUCTURE_ID,
1, LPAD(NVL(LOCATION_ID_SEGMENT_1, ' '), 15),
2, LPAD(NVL(LOCATION_ID_SEGMENT_1, ' '), 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_2, ' '), 15),
3, LPAD(NVL(LOCATION_ID_SEGMENT_1, ' '), 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_2, ' '), 15),
4, LPAD(NVL(LOCATION_ID_SEGMENT_1, ' '), 15),
5, LPAD(NVL(LOCATION_ID_SEGMENT_1, ' '), 15),
101, LPAD(NVL(LOCATION_ID_SEGMENT_1, ' '), 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_2, ' '), 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_3, ' '), 15), NULL)),
ENABLED_FLAG, LAST_UPDATED_BY, LAST_UPDATE_DATE, START_DATE_ACTIVE, END_DATE_ACTIVE, SUMMARY_FLAG, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, LOCATION_ID_SEGMENT_1, LOCATION_ID_SEGMENT_2, LOCATION_ID_SEGMENT_3, LOCATION_ID_SEGMENT_4, LOCATION_ID_SEGMENT_5, LOCATION_ID_SEGMENT_6, LOCATION_ID_SEGMENT_7, LOCATION_ID_SEGMENT_8, LOCATION_ID_SEGMENT_9, LOCATION_ID_SEGMENT_10, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CREATED_BY, CREATION_DATE
FROM AR_LOC_COMBINATIONS_OLD
SELECT ROWID
, LOCATION_ID
, LOCATION_STRUCTURE_ID
,
(DECODE(LOCATION_STRUCTURE_ID
,
1
, LOCATION_ID_SEGMENT_1
,
2
, LOCATION_ID_SEGMENT_1 || '.' || LOCATION_ID_SEGMENT_2
,
3
, LOCATION_ID_SEGMENT_1 || '.' || LOCATION_ID_SEGMENT_2
,
4
, LOCATION_ID_SEGMENT_1
,
5
, LOCATION_ID_SEGMENT_1
,
101
, LOCATION_ID_SEGMENT_1 || '.' || LOCATION_ID_SEGMENT_2 || '.' || LOCATION_ID_SEGMENT_3
, NULL))
,
(DECODE(LOCATION_STRUCTURE_ID
,
1
, LPAD(NVL(LOCATION_ID_SEGMENT_1
, ' ')
, 15)
,
2
, LPAD(NVL(LOCATION_ID_SEGMENT_1
, ' ')
, 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_2
, ' ')
, 15)
,
3
, LPAD(NVL(LOCATION_ID_SEGMENT_1
, ' ')
, 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_2
, ' ')
, 15)
,
4
, LPAD(NVL(LOCATION_ID_SEGMENT_1
, ' ')
, 15)
,
5
, LPAD(NVL(LOCATION_ID_SEGMENT_1
, ' ')
, 15)
,
101
, LPAD(NVL(LOCATION_ID_SEGMENT_1
, ' ')
, 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_2
, ' ')
, 15) || '.' || LPAD(NVL(LOCATION_ID_SEGMENT_3
, ' ')
, 15)
, NULL))
,
ENABLED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SUMMARY_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LOCATION_ID_SEGMENT_1
, LOCATION_ID_SEGMENT_2
, LOCATION_ID_SEGMENT_3
, LOCATION_ID_SEGMENT_4
, LOCATION_ID_SEGMENT_5
, LOCATION_ID_SEGMENT_6
, LOCATION_ID_SEGMENT_7
, LOCATION_ID_SEGMENT_8
, LOCATION_ID_SEGMENT_9
, LOCATION_ID_SEGMENT_10
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
FROM AR_LOC_COMBINATIONS_OLD
|
|
|