VIEW: APPS.JTF_TASK_CUSTOM_COLORS_V

Source

View Text - Preformatted

select /* SHIPPED_BY_ORACLE */        a.task_id ,        a.resource_id,        a.resource_type_code ,        decode(t.task_type_id||r.reference_code||NVL(s.closed_flag,'N')||NVL(s.completed_flag,'N')||NVL(s.cancelled_flag,'N')||NVL(s.rejected_flag,'N')||NVL(t.deleted_flag,'N'),               '22ESCNNNNN', 16711680,               decode(to_char(a.actual_start_date,'YYYY')||to_char(a.actual_end_date,'YYYY'), NULL, 3342591, 14796875)) foreground_color_dec,              to_number(null) background_color_dec,        decode(t.task_type_id||r.reference_code||NVL(s.closed_flag,'N')||NVL(s.completed_flag,'N')||NVL(s.cancelled_flag,'N')||NVL(s.rejected_flag,'N')||NVL(t.deleted_flag,'N'),               '22ESCNNNNN', 'FF0000',               decode(to_char(a.actual_start_date,'YYYY')||to_char(a.actual_end_date,'YYYY'), NULL, '3300FF', 'E1C84B')) foreground_color_hex,              null background_color_hex,        decode(t.task_type_id||r.reference_code||NVL(s.closed_flag,'N')||NVL(s.completed_flag,'N')||NVL(s.cancelled_flag,'N')||NVL(s.rejected_flag,'N')||NVL(t.deleted_flag,'N'),               '22ESCNNNNN', 'r255g000b000',               decode(to_char(a.actual_start_date,'YYYY')||to_char(a.actual_end_date,'YYYY'), NULL, 'r051g000b255', 'r225g200b075')) foreground_color_rgb,         null background_color_rgb   from jtf_task_statuses_b s,        jtf_tasks_b t,        jtf_task_references_b r,        jtf_task_assignments a  where r.object_id        (+)= a.task_id    and r.reference_code   (+)= 'ESC'     and r.object_type_code (+)= 'TASK'    and t.task_id          (+)= r.task_id    and s.task_status_id   (+)= t.task_status_id

View Text - HTML Formatted

SELECT /* SHIPPED_BY_ORACLE */ A.TASK_ID
, A.RESOURCE_ID
, A.RESOURCE_TYPE_CODE
, DECODE(T.TASK_TYPE_ID||R.REFERENCE_CODE||NVL(S.CLOSED_FLAG
, 'N')||NVL(S.COMPLETED_FLAG
, 'N')||NVL(S.CANCELLED_FLAG
, 'N')||NVL(S.REJECTED_FLAG
, 'N')||NVL(T.DELETED_FLAG
, 'N')
, '22ESCNNNNN'
, 16711680
, DECODE(TO_CHAR(A.ACTUAL_START_DATE
, 'YYYY')||TO_CHAR(A.ACTUAL_END_DATE
, 'YYYY')
, NULL
, 3342591
, 14796875)) FOREGROUND_COLOR_DEC
, TO_NUMBER(NULL) BACKGROUND_COLOR_DEC
, DECODE(T.TASK_TYPE_ID||R.REFERENCE_CODE||NVL(S.CLOSED_FLAG
, 'N')||NVL(S.COMPLETED_FLAG
, 'N')||NVL(S.CANCELLED_FLAG
, 'N')||NVL(S.REJECTED_FLAG
, 'N')||NVL(T.DELETED_FLAG
, 'N')
, '22ESCNNNNN'
, 'FF0000'
, DECODE(TO_CHAR(A.ACTUAL_START_DATE
, 'YYYY')||TO_CHAR(A.ACTUAL_END_DATE
, 'YYYY')
, NULL
, '3300FF'
, 'E1C84B')) FOREGROUND_COLOR_HEX
, NULL BACKGROUND_COLOR_HEX
, DECODE(T.TASK_TYPE_ID||R.REFERENCE_CODE||NVL(S.CLOSED_FLAG
, 'N')||NVL(S.COMPLETED_FLAG
, 'N')||NVL(S.CANCELLED_FLAG
, 'N')||NVL(S.REJECTED_FLAG
, 'N')||NVL(T.DELETED_FLAG
, 'N')
, '22ESCNNNNN'
, 'R255G000B000'
, DECODE(TO_CHAR(A.ACTUAL_START_DATE
, 'YYYY')||TO_CHAR(A.ACTUAL_END_DATE
, 'YYYY')
, NULL
, 'R051G000B255'
, 'R225G200B075')) FOREGROUND_COLOR_RGB
, NULL BACKGROUND_COLOR_RGB
FROM JTF_TASK_STATUSES_B S
, JTF_TASKS_B T
, JTF_TASK_REFERENCES_B R
, JTF_TASK_ASSIGNMENTS A
WHERE R.OBJECT_ID (+)= A.TASK_ID
AND R.REFERENCE_CODE (+)= 'ESC'
AND R.OBJECT_TYPE_CODE (+)= 'TASK'
AND T.TASK_ID (+)= R.TASK_ID
AND S.TASK_STATUS_ID (+)= T.TASK_STATUS_ID