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 802: , jtf_tasks_b jtb

798: select jta.task_assignment_id
799: , jta.object_version_number
800: from jtf_task_statuses_b jtsb
801: , jtf_task_assignments jta
802: , jtf_tasks_b jtb
803: where jtsb.task_status_id = jta.assignment_status_id
804: and jta.object_capacity_id = b_object_capacity_id
805: and jta.task_id = jtb.task_id
806: and nvl(jtb.deleted_flag, 'N') = 'N'