DBA Data[Home] [Help]

APPS.IEU_TASKS_WR_MIG_PVT dependencies on JTF_TASK_ASSIGNMENTS

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 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'