VIEW: APPS.PA_ACTION_SET_LINE_COND_DFV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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