SELECT ROWID, CONDITION_CODE, (DECODE (CONDITION_CODE, 'ADVERTISEMENT_DAYS_OPN_REMAIN', FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1), 'ADVERTISEMENT_DAYS_OPEN', FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1), NULL)), (DECODE (CONDITION_CODE, 'ADVERTISEMENT_DAYS_OPN_REMAIN', FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE2), NULL)), (DECODE (CONDITION_CODE, 'ADVERTISEMENT_DAYS_REMAINING', FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE2), NULL)), (DECODE (CONDITION_CODE, 'PA_PROJ_STATUS_REPORT_AFTER', FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1), NULL)), (DECODE (CONDITION_CODE, 'PA_TASK_PROGRESS_REQUEST', CONDITION_ATTRIBUTE2, 'PA_PROJ_STATUS_REPORT_BEFORE', CONDITION_ATTRIBUTE2, 'PA_PROJ_STATUS_REPORT_AFTER', CONDITION_ATTRIBUTE2, NULL)), (DECODE (CONDITION_CODE, 'PA_PROJ_STATUS_REPORT_BEFORE', FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1), NULL)),
(DECODE (CONDITION_CODE,
'ADVERTISEMENT_DAYS_OPEN', CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1,
'ADVERTISEMENT_DAYS_OPN_REMAIN', CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1 || ';' || CONDITION_ATTRIBUTE2,
'ADVERTISEMENT_DAYS_REMAINING', CONDITION_CODE || ';' || CONDITION_ATTRIBUTE2,
'PA_PROJ_STATUS_REPORT_AFTER', CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1 || ';' || CONDITION_ATTRIBUTE2,
'PA_PROJ_STATUS_REPORT_BEFORE', CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1 || ';' || CONDITION_ATTRIBUTE2,
'PA_TASK_PROGRESS_REQUEST', CONDITION_CODE || ';' || CONDITION_ATTRIBUTE2, NULL))
FROM PA_ACTION_SET_LINE_COND
SELECT ROWID
, CONDITION_CODE
, (DECODE (CONDITION_CODE
, 'ADVERTISEMENT_DAYS_OPN_REMAIN'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1)
, 'ADVERTISEMENT_DAYS_OPEN'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1)
, NULL))
, (DECODE (CONDITION_CODE
, 'ADVERTISEMENT_DAYS_OPN_REMAIN'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE2)
, NULL))
, (DECODE (CONDITION_CODE
, 'ADVERTISEMENT_DAYS_REMAINING'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE2)
, NULL))
, (DECODE (CONDITION_CODE
, 'PA_PROJ_STATUS_REPORT_AFTER'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1)
, NULL))
, (DECODE (CONDITION_CODE
, 'PA_TASK_PROGRESS_REQUEST'
, CONDITION_ATTRIBUTE2
, 'PA_PROJ_STATUS_REPORT_BEFORE'
, CONDITION_ATTRIBUTE2
, 'PA_PROJ_STATUS_REPORT_AFTER'
, CONDITION_ATTRIBUTE2
, NULL))
, (DECODE (CONDITION_CODE
, 'PA_PROJ_STATUS_REPORT_BEFORE'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONDITION_ATTRIBUTE1)
, NULL))
,
(DECODE (CONDITION_CODE
,
'ADVERTISEMENT_DAYS_OPEN'
, CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1
,
'ADVERTISEMENT_DAYS_OPN_REMAIN'
, CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1 || ';' || CONDITION_ATTRIBUTE2
,
'ADVERTISEMENT_DAYS_REMAINING'
, CONDITION_CODE || ';' || CONDITION_ATTRIBUTE2
,
'PA_PROJ_STATUS_REPORT_AFTER'
, CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1 || ';' || CONDITION_ATTRIBUTE2
,
'PA_PROJ_STATUS_REPORT_BEFORE'
, CONDITION_CODE || ';' || CONDITION_ATTRIBUTE1 || ';' || CONDITION_ATTRIBUTE2
,
'PA_TASK_PROGRESS_REQUEST'
, CONDITION_CODE || ';' || CONDITION_ATTRIBUTE2
, NULL))
FROM PA_ACTION_SET_LINE_COND
|
|
|