VIEW: APPS.OKC_LAUNCH_TASKGRID_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'