DBA Data[Home] [Help]

APPS.CAC_SR_OBJECT_CAPACITY_PUB dependencies on JTF_TASK_STATUSES_B

Line 128: from jtf_task_statuses_b jtsb

124: , jtb.planned_start_date
125: , jtb.planned_end_date
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'

Line 800: from jtf_task_statuses_b jtsb

796: )
797: is
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