SELECT ROWID, ACTION_CODE, ACTION_ATTRIBUTE1, ACTION_ATTRIBUTE1, ACTION_ATTRIBUTE2, ACTION_ATTRIBUTE1, ACTION_ATTRIBUTE1, ACTION_ATTRIBUTE1, ACTION_ATTRIBUTE1, ACTION_ATTRIBUTE1,
(DECODE (ACTION_CODE,
'ADVERTISEMENT_ESC_TO_NEXT_LVL', ACTION_CODE,
'ADVERTISEMENT_PUB_TO_ALL', ACTION_CODE,
'ADVERTISEMENT_PUB_TO_SM', ACTION_CODE || ';' || ACTION_ATTRIBUTE1,
'ADVERTISEMENT_PUB_TO_START_ORG', ACTION_CODE || ';' || ACTION_ATTRIBUTE1 || ';' || ACTION_ATTRIBUTE2,
'ADVERTISEMENT_REMOVE_ADV', ACTION_CODE,
'ADVERTISEMENT_SEND_EMAIL', ACTION_CODE || ';' || ACTION_ATTRIBUTE1,
'ADVERTISEMENT_SEND_NTF_PERSON', ACTION_CODE || ';' || ACTION_ATTRIBUTE1,
'ADVERTISEMENT_SEND_NTF_ROLE', ACTION_CODE || ';' || ACTION_ATTRIBUTE1,
'ADVERTISEMENT_UPDATE_SP', ACTION_CODE || ';' || ACTION_ATTRIBUTE1,
'PA_PROJ_STATUS_REPORT_MISS', ACTION_CODE || ';' || ACTION_ATTRIBUTE1,
'PA_PROJ_STATUS_REPORT_NEXT', ACTION_CODE,
'PA_TASK_PROGRESS_NOTIFY', ACTION_CODE, NULL))
FROM PA_ACTION_SET_LINES
SELECT ROWID
, ACTION_CODE
, ACTION_ATTRIBUTE1
, ACTION_ATTRIBUTE1
, ACTION_ATTRIBUTE2
, ACTION_ATTRIBUTE1
, ACTION_ATTRIBUTE1
, ACTION_ATTRIBUTE1
, ACTION_ATTRIBUTE1
, ACTION_ATTRIBUTE1
,
(DECODE (ACTION_CODE
,
'ADVERTISEMENT_ESC_TO_NEXT_LVL'
, ACTION_CODE
,
'ADVERTISEMENT_PUB_TO_ALL'
, ACTION_CODE
,
'ADVERTISEMENT_PUB_TO_SM'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1
,
'ADVERTISEMENT_PUB_TO_START_ORG'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1 || ';' || ACTION_ATTRIBUTE2
,
'ADVERTISEMENT_REMOVE_ADV'
, ACTION_CODE
,
'ADVERTISEMENT_SEND_EMAIL'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1
,
'ADVERTISEMENT_SEND_NTF_PERSON'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1
,
'ADVERTISEMENT_SEND_NTF_ROLE'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1
,
'ADVERTISEMENT_UPDATE_SP'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1
,
'PA_PROJ_STATUS_REPORT_MISS'
, ACTION_CODE || ';' || ACTION_ATTRIBUTE1
,
'PA_PROJ_STATUS_REPORT_NEXT'
, ACTION_CODE
,
'PA_TASK_PROGRESS_NOTIFY'
, ACTION_CODE
, NULL))
FROM PA_ACTION_SET_LINES
|
|
|