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 741: from jtf_task_statuses_b jtsb

737: )
738: is
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