VIEW: APPS.JTF_TASK_UWQ_V

Source

View Text - Preformatted

SELECT tasks_b.task_id ,tasks_b.task_number ,tasks_tl.task_name ,typ.name task_type ,sts.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 ,tasks_b.source_object_type_code ,jtf_objects_tl.name source_object_type ,tasks_b.source_object_id ,tasks_b.source_object_name ,null owner_type_code ,null owner_id ,jtf_task_utl.get_owner(asg.resource_type_code, asg.resource_id ) owner ,p.party_name customer_name ,null cust_account_number ,ttl.name timezone_name ,tz.gmt_deviation_hours ,tasks_b.duration ,tasks_b.duration_uom ,null escalation_level ,null escalation_owner ,asg.resource_id resource_id ,asg.resource_type_code resource_type ,decode(asg.assignee_role,'ASSIGNEE', 'A' , 'OWNER' , 'O' ,asg.assignee_role) owned_flag ,tasks_b.task_status_id ,typ.task_type_id ,'N' closed_flag ,jtf_objects_b.object_function object_function ,jtf_objects_b.object_parameters object_parameters ,nvl(asg.assignee_role,'ASSIGNEE') assignee_role ,nvl(jtf_objects_b.enter_from_task,'N') from jtf_tasks_b tasks_b ,jtf_tasks_tl tasks_tl ,jtf_task_statuses_vl sts ,jtf_task_types_tl typ ,jtf_task_priorities_tl pri ,jtf_objects_b ,jtf_objects_tl ,jtf_task_all_assignments asg ,hz_timezones tz ,hz_timezones_tl ttl ,hz_parties p WHERE tasks_b.task_status_id = sts.task_status_id and asg.task_id = tasks_b.task_id and tasks_b.task_type_id = typ.task_type_id and nvl(tasks_b.deleted_flag ,'N') <> 'Y' and tasks_b.task_priority_id = pri.task_priority_id (+) and tasks_b.source_object_type_code = jtf_objects_b.object_code and jtf_objects_b.object_code = jtf_objects_tl.object_code and jtf_objects_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.open_flag,'N') = 'Y' and nvl(tasks_b.deleted_flag ,'N') = 'N' and tasks_b.task_type_id <> 22 and tasks_b.source_object_type_code <> 'APPOINTMENT' and tasks_b.timezone_id = tz.timezone_id(+) and tasks_b.timezone_id = ttl.timezone_id(+) and nvl(ttl.language, userenv('lang')) = userenv('lang') and tasks_b.customer_id = p.party_id(+)

View Text - HTML Formatted

SELECT TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS.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
, TASKS_B.SOURCE_OBJECT_TYPE_CODE
, JTF_OBJECTS_TL.NAME SOURCE_OBJECT_TYPE
, TASKS_B.SOURCE_OBJECT_ID
, TASKS_B.SOURCE_OBJECT_NAME
, NULL OWNER_TYPE_CODE
, NULL OWNER_ID
, JTF_TASK_UTL.GET_OWNER(ASG.RESOURCE_TYPE_CODE
, ASG.RESOURCE_ID ) OWNER
, P.PARTY_NAME CUSTOMER_NAME
, NULL CUST_ACCOUNT_NUMBER
, TTL.NAME TIMEZONE_NAME
, TZ.GMT_DEVIATION_HOURS
, TASKS_B.DURATION
, TASKS_B.DURATION_UOM
, NULL ESCALATION_LEVEL
, NULL ESCALATION_OWNER
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_TYPE_CODE RESOURCE_TYPE
, DECODE(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE'
, 'A'
, 'OWNER'
, 'O'
, ASG.ASSIGNEE_ROLE) OWNED_FLAG
, TASKS_B.TASK_STATUS_ID
, TYP.TASK_TYPE_ID
, 'N' CLOSED_FLAG
, JTF_OBJECTS_B.OBJECT_FUNCTION OBJECT_FUNCTION
, JTF_OBJECTS_B.OBJECT_PARAMETERS OBJECT_PARAMETERS
, NVL(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE') ASSIGNEE_ROLE
, NVL(JTF_OBJECTS_B.ENTER_FROM_TASK
, 'N')
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_VL STS
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_PRIORITIES_TL PRI
, JTF_OBJECTS_B
, JTF_OBJECTS_TL
, JTF_TASK_ALL_ASSIGNMENTS ASG
, HZ_TIMEZONES TZ
, HZ_TIMEZONES_TL TTL
, HZ_PARTIES P
WHERE TASKS_B.TASK_STATUS_ID = STS.TASK_STATUS_ID
AND ASG.TASK_ID = TASKS_B.TASK_ID
AND TASKS_B.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND NVL(TASKS_B.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS_B.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND TASKS_B.SOURCE_OBJECT_TYPE_CODE = JTF_OBJECTS_B.OBJECT_CODE
AND JTF_OBJECTS_B.OBJECT_CODE = JTF_OBJECTS_TL.OBJECT_CODE
AND JTF_OBJECTS_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.OPEN_FLAG
, 'N') = 'Y'
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.TASK_TYPE_ID <> 22
AND TASKS_B.SOURCE_OBJECT_TYPE_CODE <> 'APPOINTMENT'
AND TASKS_B.TIMEZONE_ID = TZ.TIMEZONE_ID(+)
AND TASKS_B.TIMEZONE_ID = TTL.TIMEZONE_ID(+)
AND NVL(TTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND TASKS_B.CUSTOMER_ID = P.PARTY_ID(+)