View: OKC_LAUNCH_TASKGRID_V

Product:	OKC - Contracts Core
Description:	View for Launchpad schedule tab
Implementation/DBA Data:	APPS.OKC_LAUNCH_TASKGRID_V

View Text

SELECT JTB.TASK_ID TASK_ID
, JTB.TASK_NUMBER TASK_NUMBER
, JTTL.NAME TASK_TYPE
, JTB.OBJECT_VERSION_NUMBER
, JTB.SOURCE_OBJECT_ID
, JTL.TASK_NAME TASK_NAME
, JTF_TASK_UTL.GET_OWNER(JTB.OWNER_TYPE_CODE
, JTB.OWNER_ID) OWNER
, JTB.PLANNED_END_DATE DUE_DATE
, JTB.ACTUAL_END_DATE END_DATE
, JTSL.NAME STATUS
, RUL.DNZ_CHR_ID CONTRACT_ID
, JTB.ALARM_FIRED_COUNT
FROM JTF_TASKS_B JTB
, JTF_TASKS_TL JTL
, JTF_TASK_TYPES_TL JTTL
, JTF_TASK_STATUSES_TL JTSL
, OKC_RESOLVED_TIMEVALUES RES
, OKC_RULES_B RUL
WHERE JTB.TASK_ID = JTL.TASK_ID
AND JTL.LANGUAGE =USERENV('LANG')
AND JTB.TASK_TYPE_ID = JTTL.TASK_TYPE_ID
AND JTTL.LANGUAGE = USERENV('LANG')
AND JTB.TASK_TYPE_ID = 23
AND JTB.TASK_STATUS_ID = JTSL.TASK_STATUS_ID
AND JTSL.LANGUAGE = USERENV('LANG')
AND JTB.SOURCE_OBJECT_ID = RES.ID
AND TO_CHAR(RES.TVE_ID) = RUL.RULE_INFORMATION2
AND RUL.RULE_INFORMATION_CATEGORY = 'NTN' UNION ALL SELECT JTB.TASK_ID TASK_ID
, JTB.TASK_NUMBER TASK_NUMBER
, JTTL.NAME TASK_TYPE
, JTB.OBJECT_VERSION_NUMBER
, JTB.SOURCE_OBJECT_ID
, JTL.TASK_NAME TASK_NAME
, JTF_TASK_UTL.GET_OWNER(JTB.OWNER_TYPE_CODE
, JTB.OWNER_ID) OWNER
, JTB.PLANNED_END_DATE DUE_DATE
, JTB.ACTUAL_END_DATE END_DATE
, JTSL.NAME STATUS
, JTB.SOURCE_OBJECT_ID CONTRACT_ID
, JTB.ALARM_FIRED_COUNT
FROM JTF_TASKS_B JTB
, JTF_TASKS_TL JTL
, JTF_TASK_TYPES_TL JTTL
, JTF_TASK_STATUSES_TL JTSL
WHERE JTB.TASK_ID = JTL.TASK_ID
AND JTL.LANGUAGE =USERENV('LANG')
AND JTB.TASK_TYPE_ID = JTTL.TASK_TYPE_ID
AND JTTL.LANGUAGE = USERENV('LANG')
AND JTB.TASK_TYPE_ID = 24
AND JTB.TASK_STATUS_ID = JTSL.TASK_STATUS_ID
AND JTSL.LANGUAGE = USERENV('LANG') UNION ALL SELECT JTB.TASK_ID TASK_ID
, JTB.TASK_NUMBER TASK_NUMBER
, JTTL.NAME TASK_TYPE
, JTB.OBJECT_VERSION_NUMBER
, JTB.SOURCE_OBJECT_ID
, JTL.TASK_NAME TASK_NAME
, JTF_TASK_UTL.GET_OWNER(JTB.OWNER_TYPE_CODE
, JTB.OWNER_ID) OWNER
, JTB.PLANNED_END_DATE DUE_DATE
, JTB.ACTUAL_END_DATE END_DATE
, JTSL.NAME STATUS
, CNH.DNZ_CHR_ID CONTRACT_ID
, JTB.ALARM_FIRED_COUNT
FROM JTF_TASKS_B JTB
, JTF_TASKS_TL JTL
, JTF_TASK_TYPES_TL JTTL
, JTF_TASK_STATUSES_TL JTSL
, OKC_CONDITION_OCCURS COE
, OKC_CONDITION_HEADERS_B CNH
WHERE JTB.TASK_ID = JTL.TASK_ID
AND JTL.LANGUAGE =USERENV('LANG')
AND JTB.TASK_TYPE_ID = JTTL.TASK_TYPE_ID
AND JTTL.LANGUAGE = USERENV('LANG')
AND JTB.TASK_TYPE_ID = 18
AND JTB.TASK_STATUS_ID = JTSL.TASK_STATUS_ID
AND JTSL.LANGUAGE = USERENV('LANG')
AND COE.ID = JTB.SOURCE_OBJECT_ID
AND CNH.ID =COE.CNH_ID
AND CNH.JTOT_OBJECT_CODE IN ( 'OKC_K_HEADER'
, 'OKC_K_LINE') UNION ALL SELECT JTB.TASK_ID TASK_ID
, JTB.TASK_NUMBER TASK_NUMBER
, JTTL.NAME TASK_TYPE
, JTB.OBJECT_VERSION_NUMBER
, JTB.SOURCE_OBJECT_ID
, JTL.TASK_NAME TASK_NAME
, JTF_TASK_UTL.GET_OWNER(JTB.OWNER_TYPE_CODE
, JTB.OWNER_ID) OWNER
, JTB.PLANNED_END_DATE DUE_DATE
, JTB.ACTUAL_END_DATE END_DATE
, JTSL.NAME STATUS
, OKC_QUERY.GET_NUMBER(AAV.VALUE) CONTRACT_ID
, JTB.ALARM_FIRED_COUNT
FROM JTF_TASKS_B JTB
, JTF_TASKS_TL JTL
, JTF_TASK_TYPES_TL JTTL
, JTF_TASK_STATUSES_TL JTSL
, OKC_CONDITION_OCCURS COE
, OKC_CONDITION_HEADERS_B CNH
, OKC_ACTION_ATTRIBUTES_B AAE
, OKC_ACTION_ATT_VALS AAV
WHERE JTB.TASK_ID = JTL.TASK_ID
AND JTL.LANGUAGE =USERENV('LANG')
AND JTB.TASK_TYPE_ID = JTTL.TASK_TYPE_ID
AND JTTL.LANGUAGE = USERENV('LANG')
AND JTB.TASK_TYPE_ID = 18
AND JTB.TASK_STATUS_ID = JTSL.TASK_STATUS_ID
AND JTSL.LANGUAGE = USERENV('LANG')
AND COE.ID = JTB.SOURCE_OBJECT_ID
AND COE.CNH_ID = CNH.ID
AND CNH.OBJECT_ID IS NULL
AND CNH.JTOT_OBJECT_CODE IS NULL
AND CNH.ACN_ID = AAE.ACN_ID /* ADDED FOR BUG #4760124 */
AND AAV.COE_ID = COE.ID
AND AAE.ID = AAV.AAE_ID
AND AAE.ELEMENT_NAME = 'K_ID'

Columns