VIEW: APPS.JTF_ESC_UWQ_V

Source

View Text - Preformatted

SELECT tasks_b.task_id , tasks_b.task_number , tasks_tl.description , sts_tl.name task_status , tasks_b.actual_start_date , tasks_b.planned_end_date , tasks_b.actual_end_date , tasks_b.owner_type_code , tasks_b.owner_id , jtf_task_utl.get_owner(owner_type_code ,owner_id ) owner , jtf_task_utl.get_customer_name(customer_id) customer_name , null cust_account_number , lkups.meaning escalation_level_name , tasks_b.ESCALATION_LEVEL escalation_level, jtf_ec_util.get_requester_name(tasks_b.task_id), tasks_b.owner_id resource_id , tasks_b.owner_type_code resource_type, refs_b.object_name ref_doc_number, refs_b.object_id ref_doc_id, o.object_code, o.name, o.OBJECT_PARAMETERS, o.OBJECT_function from jtf_tasks_b tasks_b , jtf_tasks_tl tasks_tl , jtf_task_statuses_tl sts_tl, jtf_task_statuses_b sts_b, fnd_lookups lkups, jtf_task_references_b refs_b, (select obj_b.object_code, obj_tl.name, obj_b.object_parameters, obj_b.object_function from jtf_objects_b obj_b, jtf_objects_tl obj_tl where obj_b.object_code = obj_tl.object_code and obj_tl.LANGUAGE = USERENV('lang')) o WHERE tasks_b.task_status_id = sts_b.task_status_id and nvl(tasks_b.deleted_flag ,'N') <> 'Y' and tasks_b.task_id = tasks_tl.task_id and tasks_tl.language = userenv('lang') and nvl(sts_b.closed_flag,'N') = 'N' and nvl(sts_b.cancelled_flag,'N') = 'N' and nvl(sts_b.COMPLETED_FLAG,'N') = 'N' and nvl(sts_b.rejected_flag,'N') = 'N' and nvl(tasks_b.deleted_flag,'N') = 'N' and tasks_b.task_type_id = 22 and lkups.lookup_type = 'JTF_TASK_ESC_LEVEL' and lkups.lookup_code = tasks_b.ESCALATION_LEVEL and sts_tl.language = userenv('lang') and sts_b.task_status_id = sts_tl.task_status_id and refs_b.task_id(+) = tasks_b.task_id and o.object_code(+) = refs_b.object_type_code and refs_b.reference_code='ESC'

View Text - HTML Formatted

SELECT TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.DESCRIPTION
, STS_TL.NAME TASK_STATUS
, TASKS_B.ACTUAL_START_DATE
, TASKS_B.PLANNED_END_DATE
, TASKS_B.ACTUAL_END_DATE
, TASKS_B.OWNER_TYPE_CODE
, TASKS_B.OWNER_ID
, JTF_TASK_UTL.GET_OWNER(OWNER_TYPE_CODE
, OWNER_ID ) OWNER
, JTF_TASK_UTL.GET_CUSTOMER_NAME(CUSTOMER_ID) CUSTOMER_NAME
, NULL CUST_ACCOUNT_NUMBER
, LKUPS.MEANING ESCALATION_LEVEL_NAME
, TASKS_B.ESCALATION_LEVEL ESCALATION_LEVEL
, JTF_EC_UTIL.GET_REQUESTER_NAME(TASKS_B.TASK_ID)
, TASKS_B.OWNER_ID RESOURCE_ID
, TASKS_B.OWNER_TYPE_CODE RESOURCE_TYPE
, REFS_B.OBJECT_NAME REF_DOC_NUMBER
, REFS_B.OBJECT_ID REF_DOC_ID
, O.OBJECT_CODE
, O.NAME
, O.OBJECT_PARAMETERS
, O.OBJECT_FUNCTION
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASK_STATUSES_B STS_B
, FND_LOOKUPS LKUPS
, JTF_TASK_REFERENCES_B REFS_B
, (SELECT OBJ_B.OBJECT_CODE
, OBJ_TL.NAME
, OBJ_B.OBJECT_PARAMETERS
, OBJ_B.OBJECT_FUNCTION
FROM JTF_OBJECTS_B OBJ_B
, JTF_OBJECTS_TL OBJ_TL
WHERE OBJ_B.OBJECT_CODE = OBJ_TL.OBJECT_CODE
AND OBJ_TL.LANGUAGE = USERENV('LANG')) O
WHERE TASKS_B.TASK_STATUS_ID = STS_B.TASK_STATUS_ID
AND NVL(TASKS_B.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS_B.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND NVL(STS_B.CLOSED_FLAG
, 'N') = 'N'
AND NVL(STS_B.CANCELLED_FLAG
, 'N') = 'N'
AND NVL(STS_B.COMPLETED_FLAG
, 'N') = 'N'
AND NVL(STS_B.REJECTED_FLAG
, 'N') = 'N'
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.TASK_TYPE_ID = 22
AND LKUPS.LOOKUP_TYPE = 'JTF_TASK_ESC_LEVEL'
AND LKUPS.LOOKUP_CODE = TASKS_B.ESCALATION_LEVEL
AND STS_TL.LANGUAGE = USERENV('LANG')
AND STS_B.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND REFS_B.TASK_ID(+) = TASKS_B.TASK_ID
AND O.OBJECT_CODE(+) = REFS_B.OBJECT_TYPE_CODE
AND REFS_B.REFERENCE_CODE='ESC'