DBA Data[Home] [Help]

APPS.CAC_SR_OBJECT_CAPACITY_PUB dependencies on JTF_TASKS_B

Line 130: , jtf_tasks_b jtb

126: , jtb.address_id
127: , jtb.customer_id
128: from jtf_task_statuses_b jtsb
129: , jtf_task_assignments jta
130: , jtf_tasks_b jtb
131: where nvl(jtsb.closed_flag, 'N') = 'N'
132: and nvl(jtsb.completed_flag, 'N') = 'N'
133: and nvl(jtsb.cancelled_flag, 'N') = 'N'
134: and jtsb.task_status_id = jta.assignment_status_id

Line 743: , jtf_tasks_b jtb

739: select jta.task_assignment_id
740: , jta.object_version_number
741: from jtf_task_statuses_b jtsb
742: , jtf_task_assignments jta
743: , jtf_tasks_b jtb
744: where jtsb.task_status_id = jta.assignment_status_id
745: and jta.object_capacity_id = b_object_capacity_id
746: and jta.task_id = jtb.task_id
747: and nvl(jtb.deleted_flag, 'N') = 'N'