APPS.IEU_TASKS_WR_MIG_PVT dependencies on JTF_TASKS_B

Line 80: FROM JTF_TASKS_B TASKS , JTF_TASK_ASSIGNMENTS ASG

76: from (SELECT /*+ parallel(TASKS) parallel(ASG) pq_distribute(ASG hash,hash) */
77: tasks.task_id, TASKS.owner_id,
78: tasks.owner_type_code, asg.resource_id, asg.resource_type_code, asg.task_assignment_id,
79: max(asg.last_update_date) over (partition by asg.task_id) max_update_date, asg.last_update_date
80: FROM JTF_TASKS_B TASKS , JTF_TASK_ASSIGNMENTS ASG
81: WHERE TASKS.TASK_ID = ASG.TASK_ID
82: AND NVL(TASKS.DELETED_FLAG,'N') = 'N'
83: AND TASKS.OPEN_FLAG = 'Y'
84: AND TASKS.entity = 'TASK'

Line 112: FROM JTF_TASKS_B

108:
109: CURSOR c_task_status IS
110: SELECT TASK_ID,
111: DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
112: FROM JTF_TASKS_B
113: WHERE ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
114: AND ENTITY = 'TASK';
115:
116: /** select resource_id, task_id, resource_type_code

Line 121: FROM JTF_TASK_ASSIGNMENTS ASG, JTF_TASKS_B TASKS

117: from
118: (
119: SELECT tasks.task_id, TASKS.owner_id, tasks.owner_type_code, asg.resource_id, asg.resource_type_code, asg.task_assignment_id,
120: max(asg.last_update_date) over (partition by asg.task_id) max_update_date, asg.last_update_date
121: FROM JTF_TASK_ASSIGNMENTS ASG, JTF_TASKS_B TASKS
122: WHERE TASKS.TASK_ID = ASG.TASK_ID
123: AND NVL(TASKS.DELETED_FLAG,'N') = 'N'
124: AND TASKS.OPEN_FLAG = 'Y'
125: AND TASKS.entity = 'TASK'

Line 284: from jtf_tasks_b tb

280: , ip.priority_level
281: , decode(NVL(tb.owner_type_code,'||''''||'NULL'||''''||'), '||''''||'RS_GROUP'||''''||', 1, 0) distribution_status_id
282: , decode(nvl(sts_b.on_hold_flag, '||''''||'N'||''''||'),'||''''||'Y'||''''||', 5, 0) uwq_status_id
283: , 1 ins_flag
284: from jtf_tasks_b tb
285: , jtf_tasks_tl tt
286: , jtf_task_priorities_b tp
287: , ieu_uwqm_priorities_b ip
288: , jtf_task_statuses_b sts_b