VIEW: APPS.IEU_UWQ_TASKS_TO_SEC_V

Source

View Text - Preformatted

SELECT task_src_obj_b.object_Function IEU_OBJECT_FUNCTION, task_src_obj_b.object_parameters IEU_OBJECT_PARAMETERS, '' IEU_MEDIA_TYPE_UUID, 'Source_Object_id' IEU_PARAM_PK_COL, to_char(tasks_b.source_object_id) IEU_PARAM_PK_VALUE, tasks_b.owner_id resource_id, tasks_b.owner_id owner_id, tasks_b.owner_type_code resource_type, tasks_b.task_id, tasks_b.task_number, tasks_tl.task_name, typ.name task_type, sts_tl.name task_status, pri.name task_priority, tasks_b.planned_start_date, tasks_b.planned_end_date, tasks_b.scheduled_start_date, tasks_b.scheduled_end_date, tasks_b.actual_start_date, tasks_b.actual_end_date, task_src_obj_tl.name source_object_type, tasks_b.source_object_type_code, tasks_b.source_object_id, tasks_b.object_version_number, jtf_task_utl.get_owner(tasks_b.owner_type_code, tasks_b.owner_id ) owner, tasks_b.customer_id, jtf_task_utl.get_customer_name(customer_id) customer_name, tz_b.global_timezone_name, tz_b.gmt_deviation_hours, tasks_b.duration, tasks_b.duration_uom, tasks_b.task_status_id, typ.task_type_id, tasks_b.source_object_type_code IEU_ACTION_OBJECT_CODE, tasks_b.source_object_name source_document_name , tasks_tl.description FROM jtf_tasks_b tasks_b, jtf_tasks_tl tasks_tl, jtf_task_statuses_b sts_b, jtf_task_statuses_tl sts_tl, jtf_task_types_tl typ, jtf_task_priorities_tl pri, hz_timezones tz_b, jtf_objects_b task_src_obj_b, jtf_objects_tl task_src_obj_tl WHERE tasks_b.source_object_type_code = task_src_obj_b.object_code and tasks_b.task_status_id = sts_b.task_status_id and sts_b.task_status_id = sts_tl.task_status_id and sts_tl.LANGUAGE = userenv('lang') and tasks_b.task_type_id = typ.task_type_id and tasks_b.task_priority_id = pri.task_priority_id (+) and task_src_obj_b.object_code = task_src_obj_tl.object_code and task_src_obj_tl.language = userenv('lang') and tasks_b.task_id = tasks_tl.task_id and tasks_tl.language = userenv('lang') and typ.language = userenv('lang') and nvl(pri.language, userenv('lang')) = userenv('lang') and nvl(tasks_b.deleted_flag, 'N') = 'N' and tasks_b.open_flag = 'Y' and tasks_b.entity = 'TASK' and tasks_b.timezone_id = tz_b.timezone_id(+) and tasks_b.owner_type_code = 'RS_TEAM' and nvl(tasks_b.source_object_type_code,'X') <> 'SR' UNION ALL SELECT task_src_obj_b.object_Function IEU_OBJECT_FUNCTION, task_src_obj_b.object_parameters IEU_OBJECT_PARAMETERS, '' IEU_MEDIA_TYPE_UUID, 'Source_Object_id' IEU_PARAM_PK_COL, to_char(tasks_b.source_object_id) IEU_PARAM_PK_VALUE, tasks_b.owner_id resource_id, tasks_b.owner_id owner_id, tasks_b.owner_type_code resource_type, tasks_b.task_id, tasks_b.task_number, tasks_tl.task_name, typ.name task_type, sts_tl.name task_status, pri.name task_priority, tasks_b.planned_start_date, tasks_b.planned_end_date, tasks_b.scheduled_start_date, tasks_b.scheduled_end_date, tasks_b.actual_start_date, tasks_b.actual_end_date, task_src_obj_tl.name source_object_type, tasks_b.source_object_type_code, tasks_b.source_object_id, tasks_b.object_version_number, jtf_task_utl.get_owner(tasks_b.owner_type_code, tasks_b.owner_id ) owner, tasks_b.customer_id, jtf_task_utl.get_customer_name(customer_id) customer_name, tz_b.global_timezone_name, tz_b.gmt_deviation_hours, tasks_b.duration, tasks_b.duration_uom, tasks_b.task_status_id, typ.task_type_id, tasks_b.source_object_type_code IEU_ACTION_OBJECT_CODE, tasks_b.source_object_name source_document_name , tasks_tl.description FROM jtf_tasks_b tasks_b, jtf_tasks_tl tasks_tl, jtf_task_statuses_b sts_b, jtf_task_statuses_tl sts_tl, jtf_task_types_tl typ, jtf_task_priorities_tl pri, hz_timezones tz_b, jtf_objects_b task_src_obj_b, jtf_objects_tl task_src_obj_tl WHERE tasks_b.source_object_type_code = task_src_obj_b.object_code and tasks_b.task_status_id = sts_b.task_status_id and sts_b.task_status_id = sts_tl.task_status_id and sts_tl.LANGUAGE = userenv('lang') and tasks_b.task_type_id = typ.task_type_id and tasks_b.task_priority_id = pri.task_priority_id (+) and task_src_obj_b.object_code = task_src_obj_tl.object_code and task_src_obj_tl.language = userenv('lang') and tasks_b.task_id = tasks_tl.task_id and tasks_tl.language = userenv('lang') and typ.language = userenv('lang') and nvl(pri.language, userenv('lang')) = userenv('lang') and nvl(tasks_b.deleted_flag, 'N') = 'N' and tasks_b.open_flag = 'Y' and tasks_b.entity = 'TASK' and tasks_b.timezone_id = tz_b.timezone_id(+) and tasks_b.owner_type_code = 'RS_TEAM' and tasks_b.source_object_type_code = 'SR' and exists (select 'X' from cs_incidents_b_sec sr where sr.incident_id =tasks_b.source_object_id)

View Text - HTML Formatted

SELECT TASK_SRC_OBJ_B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, TASK_SRC_OBJ_B.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'SOURCE_OBJECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(TASKS_B.SOURCE_OBJECT_ID) IEU_PARAM_PK_VALUE
, TASKS_B.OWNER_ID RESOURCE_ID
, TASKS_B.OWNER_ID OWNER_ID
, TASKS_B.OWNER_TYPE_CODE RESOURCE_TYPE
, TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS_TL.NAME TASK_STATUS
, PRI.NAME TASK_PRIORITY
, TASKS_B.PLANNED_START_DATE
, TASKS_B.PLANNED_END_DATE
, TASKS_B.SCHEDULED_START_DATE
, TASKS_B.SCHEDULED_END_DATE
, TASKS_B.ACTUAL_START_DATE
, TASKS_B.ACTUAL_END_DATE
, TASK_SRC_OBJ_TL.NAME SOURCE_OBJECT_TYPE
, TASKS_B.SOURCE_OBJECT_TYPE_CODE
, TASKS_B.SOURCE_OBJECT_ID
, TASKS_B.OBJECT_VERSION_NUMBER
, JTF_TASK_UTL.GET_OWNER(TASKS_B.OWNER_TYPE_CODE
, TASKS_B.OWNER_ID ) OWNER
, TASKS_B.CUSTOMER_ID
, JTF_TASK_UTL.GET_CUSTOMER_NAME(CUSTOMER_ID) CUSTOMER_NAME
, TZ_B.GLOBAL_TIMEZONE_NAME
, TZ_B.GMT_DEVIATION_HOURS
, TASKS_B.DURATION
, TASKS_B.DURATION_UOM
, TASKS_B.TASK_STATUS_ID
, TYP.TASK_TYPE_ID
, TASKS_B.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, TASKS_B.SOURCE_OBJECT_NAME SOURCE_DOCUMENT_NAME
, TASKS_TL.DESCRIPTION
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_B STS_B
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_PRIORITIES_TL PRI
, HZ_TIMEZONES TZ_B
, JTF_OBJECTS_B TASK_SRC_OBJ_B
, JTF_OBJECTS_TL TASK_SRC_OBJ_TL
WHERE TASKS_B.SOURCE_OBJECT_TYPE_CODE = TASK_SRC_OBJ_B.OBJECT_CODE
AND TASKS_B.TASK_STATUS_ID = STS_B.TASK_STATUS_ID
AND STS_B.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND STS_TL.LANGUAGE = USERENV('LANG')
AND TASKS_B.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND TASKS_B.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND TASK_SRC_OBJ_B.OBJECT_CODE = TASK_SRC_OBJ_TL.OBJECT_CODE
AND TASK_SRC_OBJ_TL.LANGUAGE = USERENV('LANG')
AND TASKS_B.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND TYP.LANGUAGE = USERENV('LANG')
AND NVL(PRI.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.OPEN_FLAG = 'Y'
AND TASKS_B.ENTITY = 'TASK'
AND TASKS_B.TIMEZONE_ID = TZ_B.TIMEZONE_ID(+)
AND TASKS_B.OWNER_TYPE_CODE = 'RS_TEAM'
AND NVL(TASKS_B.SOURCE_OBJECT_TYPE_CODE
, 'X') <> 'SR' UNION ALL SELECT TASK_SRC_OBJ_B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, TASK_SRC_OBJ_B.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'SOURCE_OBJECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(TASKS_B.SOURCE_OBJECT_ID) IEU_PARAM_PK_VALUE
, TASKS_B.OWNER_ID RESOURCE_ID
, TASKS_B.OWNER_ID OWNER_ID
, TASKS_B.OWNER_TYPE_CODE RESOURCE_TYPE
, TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS_TL.NAME TASK_STATUS
, PRI.NAME TASK_PRIORITY
, TASKS_B.PLANNED_START_DATE
, TASKS_B.PLANNED_END_DATE
, TASKS_B.SCHEDULED_START_DATE
, TASKS_B.SCHEDULED_END_DATE
, TASKS_B.ACTUAL_START_DATE
, TASKS_B.ACTUAL_END_DATE
, TASK_SRC_OBJ_TL.NAME SOURCE_OBJECT_TYPE
, TASKS_B.SOURCE_OBJECT_TYPE_CODE
, TASKS_B.SOURCE_OBJECT_ID
, TASKS_B.OBJECT_VERSION_NUMBER
, JTF_TASK_UTL.GET_OWNER(TASKS_B.OWNER_TYPE_CODE
, TASKS_B.OWNER_ID ) OWNER
, TASKS_B.CUSTOMER_ID
, JTF_TASK_UTL.GET_CUSTOMER_NAME(CUSTOMER_ID) CUSTOMER_NAME
, TZ_B.GLOBAL_TIMEZONE_NAME
, TZ_B.GMT_DEVIATION_HOURS
, TASKS_B.DURATION
, TASKS_B.DURATION_UOM
, TASKS_B.TASK_STATUS_ID
, TYP.TASK_TYPE_ID
, TASKS_B.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, TASKS_B.SOURCE_OBJECT_NAME SOURCE_DOCUMENT_NAME
, TASKS_TL.DESCRIPTION
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_B STS_B
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_PRIORITIES_TL PRI
, HZ_TIMEZONES TZ_B
, JTF_OBJECTS_B TASK_SRC_OBJ_B
, JTF_OBJECTS_TL TASK_SRC_OBJ_TL
WHERE TASKS_B.SOURCE_OBJECT_TYPE_CODE = TASK_SRC_OBJ_B.OBJECT_CODE
AND TASKS_B.TASK_STATUS_ID = STS_B.TASK_STATUS_ID
AND STS_B.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND STS_TL.LANGUAGE = USERENV('LANG')
AND TASKS_B.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND TASKS_B.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND TASK_SRC_OBJ_B.OBJECT_CODE = TASK_SRC_OBJ_TL.OBJECT_CODE
AND TASK_SRC_OBJ_TL.LANGUAGE = USERENV('LANG')
AND TASKS_B.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND TYP.LANGUAGE = USERENV('LANG')
AND NVL(PRI.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.OPEN_FLAG = 'Y'
AND TASKS_B.ENTITY = 'TASK'
AND TASKS_B.TIMEZONE_ID = TZ_B.TIMEZONE_ID(+)
AND TASKS_B.OWNER_TYPE_CODE = 'RS_TEAM'
AND TASKS_B.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND EXISTS (SELECT 'X'
FROM CS_INCIDENTS_B_SEC SR
WHERE SR.INCIDENT_ID =TASKS_B.SOURCE_OBJECT_ID)