SELECT ROWID, MSITE_INFORMATION_CONTEXT, MSITE_INFORMATION1, MSITE_INFORMATION1, MSITE_INFORMATION1,
(DECODE (MSITE_INFORMATION_CONTEXT,
'CC_TYPE', MSITE_INFORMATION_CONTEXT || '.' || MSITE_INFORMATION1,
'PMT_MTHD', MSITE_INFORMATION_CONTEXT || '.' || MSITE_INFORMATION1,
'SHPMT_MTHD', MSITE_INFORMATION_CONTEXT || '.' || MSITE_INFORMATION1, NULL))
FROM IBE_MSITE_INFORMATION
SELECT ROWID
, MSITE_INFORMATION_CONTEXT
, MSITE_INFORMATION1
, MSITE_INFORMATION1
, MSITE_INFORMATION1
,
(DECODE (MSITE_INFORMATION_CONTEXT
,
'CC_TYPE'
, MSITE_INFORMATION_CONTEXT || '.' || MSITE_INFORMATION1
,
'PMT_MTHD'
, MSITE_INFORMATION_CONTEXT || '.' || MSITE_INFORMATION1
,
'SHPMT_MTHD'
, MSITE_INFORMATION_CONTEXT || '.' || MSITE_INFORMATION1
, NULL))
FROM IBE_MSITE_INFORMATION
|
|
|