APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on JTF_TASKS_B

Line 83: FROM jtf_tasks_b t

79: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
80: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
81: , cac.object_capacity_id old_trip_id
82: , cac.object_version_number old_trip_ovn
83: FROM jtf_tasks_b t
84: , jtf_task_assignments ta
85: , jtf_task_statuses_b ts
86: , cac_sr_object_capacity cac
87: WHERE t.task_id = p_task_id

Line 324: , (SELECT pt.object_version_number FROM jtf_tasks_b pt WHERE pt.task_id = t.parent_task_id) parent_task_ovn

320: , t.scheduled_start_date
321: , t.scheduled_end_date
322: , t.task_split_flag
323: , t.parent_task_id
324: , (SELECT pt.object_version_number FROM jtf_tasks_b pt WHERE pt.task_id = t.parent_task_id) parent_task_ovn
325: , t.source_object_type_code
326: , ta.resource_id
327: , ta.resource_type_code
328: , cac.object_capacity_id trip_id

Line 344: FROM jtf_tasks_b t

340: AND ROWNUM = 1
341: )
342: , 'N'
343: ) other_ta_exists
344: FROM jtf_tasks_b t
345: , jtf_task_assignments ta
346: , cac_sr_object_capacity cac
347: WHERE ta.task_assignment_id = p_task_assignment_id
348: AND t.task_id = ta.task_id

Line 901: from jtf_tasks_b

897: WHERE OBJECT_CAPACITY_ID = L_TRIP_ID;
898: cursor c_Task_number(l_task number)
899: is
900: select task_number
901: from jtf_tasks_b
902: where task_id=l_task;
903:
904: cursor c_task_status(l_task number)
905: is

Line 914: from jtf_tasks_b

910:
911: cursor c_scheduled_dates(p_task_id number)
912: IS
913: select scheduled_start_date, scheduled_end_date
914: from jtf_tasks_b
915: where task_id =p_task_id
916: and nvl(deleted_flag,'N')<>'Y';
917:
918: scheduled_dates c_scheduled_dates%rowtype;

Line 1284: FROM jtf_tasks_b

1280:
1281: CURSOR c_scheduled_dates(p_task_id number)
1282: IS
1283: SELECT scheduled_start_date, scheduled_end_date
1284: FROM jtf_tasks_b
1285: WHERE task_id =p_task_id
1286: AND nvl(deleted_flag,'N')<>'Y';
1287:
1288: scheduled_dates c_scheduled_dates%rowtype;

Line 1299: from jtf_tasks_b

1295:
1296: cursor c_Task_number(l_task number)
1297: is
1298: select task_number
1299: from jtf_tasks_b
1300: where task_id=l_task;
1301: Cursor c_task_status(l_task number)
1302: IS
1303: select name

Line 1496: FROM jtf_tasks_b jtb ,

1492: jtb.address_id ,
1493: cac.object_capacity_id,
1494: cac.start_date_time ,
1495: cac.end_date_time
1496: FROM jtf_tasks_b jtb ,
1497: jtf_task_assignments jta,
1498: cac_sr_object_capacity cac
1499: WHERE jta.task_assignment_id = p_task_assignment_id
1500: AND jta.task_id = jtb.task_id

Line 1509: jtf_tasks_b b

1505: SELECT b.task_id ,
1506: a.task_assignment_id,
1507: a.assignment_status_id
1508: FROM jtf_task_assignments a ,
1509: jtf_tasks_b b
1510: WHERE object_capacity_id = p_trip
1511: AND a.task_id =b.task_id
1512: AND b.task_id NOT IN (p_task)
1513: AND b.task_type_id NOT IN (20,21);

Line 1518: from jtf_tasks_b

1514:
1515: CURSOR c_site_info(p_task number)
1516: IS
1517: SELECT task_id,customer_id,address_id
1518: from jtf_tasks_b
1519: where task_id = p_task;
1520:
1521: CURSOR c_working
1522: IS

Line 1539: FROM jtf_tasks_b t, hz_locations l

1535: and seeded_flag= 'Y';
1536:
1537: CURSOR c_task_geometry(p_task_id number) IS
1538: SELECT l.geometry
1539: FROM jtf_tasks_b t, hz_locations l
1540: WHERE t.task_id = p_task_id
1541: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
1542:
1543:

Line 1822: from jtf_tasks_b

1818:
1819: cursor c_scheduled_dates(p_task_id number)
1820: IS
1821: select scheduled_start_date, scheduled_end_date
1822: from jtf_tasks_b
1823: where task_id =p_task_id
1824: and task_type_id not in (20,21)
1825: and nvl(deleted_flag,'N')<>'Y';
1826:

Line 1830: from jtf_tasks_b

1826:
1827: cursor c_Task_number(l_task number)
1828: is
1829: select task_number
1830: from jtf_tasks_b
1831: where task_id=l_task;
1832:
1833: cursor c_task_status(l_task number)
1834: is