eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TRIPS_PUB dependencies on JTF_TASKS_B

Line 364: , jtf_tasks_b t

360: WHERE object_capacity_id = p_trip_id
361: AND EXISTS (SELECT 1
362: FROM jtf_task_assignments ta
363: , jtf_task_statuses_b ts
364: , jtf_tasks_b t
365: WHERE ta.object_capacity_id = oc.object_capacity_id
366: AND ts.task_status_id = ta.assignment_status_id
367: AND NVL(ts.closed_flag, 'N') = 'N'
368: AND NVL(ts.completed_flag, 'N') = 'N'

Line 715: , jtf_tasks_b t

711: , ta.sched_travel_duration_uom
712: ) travel_time
713: FROM jtf_task_assignments ta
714: , jtf_task_statuses_b ts
715: , jtf_tasks_b t
716: WHERE ta.resource_id = p_resource_id
717: AND ta.resource_type_code = p_resource_type
718: AND ta.assignee_role = 'ASSIGNEE'
719: AND ts.task_status_id = ta.assignment_status_id

Line 953: , jtf_tasks_b t

949: , t.object_version_number task_ovn
950: , t.task_status_id
951: FROM cac_sr_object_capacity cac
952: , jtf_task_assignments ta
953: , jtf_tasks_b t
954: , jtf_task_statuses_b ts
955: WHERE cac.object_capacity_id = p_trip.trip_id
956: AND ta.resource_id = cac.object_id
957: AND ta.resource_type_code = cac.object_type

Line 1305: , jtf_tasks_b t

1301: , ta.object_capacity_id wrong_trip_id
1302: , oc.object_capacity_id correct_trip_id
1303: FROM cac_sr_object_capacity oc
1304: , jtf_task_assignments ta
1305: , jtf_tasks_b t
1306: , jtf_task_statuses_b ts
1307: WHERE oc.object_capacity_id = p_trip.trip_id
1308: AND ta.resource_id = oc.object_id
1309: AND ta.resource_type_code = oc.object_type

Line 1329: , jtf_tasks_b t

1325: , p_trip.trip_id wrong_trip_id
1326: , oc.object_capacity_id correct_trip_id
1327: FROM cac_sr_object_capacity oc
1328: , jtf_task_assignments ta
1329: , jtf_tasks_b t
1330: , jtf_task_statuses_b ts
1331: WHERE ta.object_capacity_id = p_trip.trip_id
1332: AND oc.object_id = ta.resource_id
1333: AND oc.object_type = ta.resource_type_code

Line 1351: , jtf_tasks_b t

1347: , ta.object_version_number
1348: , to_number(NULL) wrong_trip_id
1349: , p_trip.trip_id correct_trip_id
1350: FROM jtf_task_assignments ta
1351: , jtf_tasks_b t
1352: WHERE ta.task_id IN (l_dep_task_id, l_arr_task_id)
1353: AND t.task_id = ta.task_id;
1354:
1355: CURSOR c_used_time IS

Line 1723: FROM jtf_tasks_b t

1719:
1720: -- Query to check for the existence of Stray Shift Tasks
1721: CURSOR c_shift_tasks_exist (p_res_id NUMBER, p_res_type VARCHAR2, p_start DATE, p_end DATE) IS
1722: SELECT 'Y'
1723: FROM jtf_tasks_b t
1724: , jtf_task_assignments ta
1725: WHERE t.owner_id = p_res_id
1726: AND t.owner_type_code = p_res_type
1727: AND t.planned_start_date BETWEEN p_start AND p_end

Line 1751: , jtf_tasks_b t

1747: ) travel_time
1748: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc
1749: , jtf_task_assignments ta
1750: , jtf_task_statuses_b ts
1751: , jtf_tasks_b t
1752: WHERE ta.object_capacity_id = oc.COLUMN_VALUE
1753: AND ts.task_status_id = ta.assignment_status_id
1754: AND NVL(ts.closed_flag, 'N') = 'N'
1755: AND NVL(ts.completed_flag, 'N') = 'N'

Line 1767: jtf_tasks_b tb,

1763:
1764: CURSOR c_linkable_tasks(l_trip number) IS
1765: SELECT tb.task_id
1766: FROM jtf_task_assignments jta,
1767: jtf_tasks_b tb,
1768: jtf_task_statuses_b jts
1769: WHERE jta.object_capacity_id=l_trip
1770: AND jta.task_id=tb.task_id
1771: AND jts.task_status_id = tb.task_status_id

Line 2405: FROM jtf_tasks_b d

2401: SELECT d.task_id dep_task_id
2402: , a.task_id arr_task_id
2403: , d.planned_start_date start_time
2404: , a.planned_end_date end_time
2405: FROM jtf_tasks_b d
2406: , jtf_task_assignments dta
2407: , jtf_tasks_b a
2408: , jtf_task_assignments ata
2409: WHERE d.owner_id = p_resource_tbl(1).resource_id

Line 2407: , jtf_tasks_b a

2403: , d.planned_start_date start_time
2404: , a.planned_end_date end_time
2405: FROM jtf_tasks_b d
2406: , jtf_task_assignments dta
2407: , jtf_tasks_b a
2408: , jtf_task_assignments ata
2409: WHERE d.owner_id = p_resource_tbl(1).resource_id
2410: AND d.owner_type_code = p_resource_tbl(1).resource_type
2411: AND d.planned_start_date BETWEEN p_start_date AND p_end_date

Line 2635: FROM jtf_tasks_b t

2631:
2632: -- Query for the existence of any Shift Task in the Trip Inteval for the Resource.
2633: CURSOR c_st_exist IS
2634: SELECT 'Y'
2635: FROM jtf_tasks_b t
2636: WHERE t.owner_id = p_resource_id
2637: AND t.owner_type_code = p_resource_type
2638: AND t.scheduled_start_date BETWEEN p_start_date_time AND p_end_date_time
2639: AND t.task_type_id IN (20, 21)

Line 3919: FROM jtf_tasks_b t

3915:
3916: -- Query for the existence of any Shift Task in the Trip Inteval for the Resource.
3917: CURSOR c_st_exist IS
3918: SELECT 'Y'
3919: FROM jtf_tasks_b t
3920: WHERE t.owner_id = p_resource_id
3921: AND t.owner_type_code = p_resource_type
3922: AND t.scheduled_start_date BETWEEN p_start_date_time AND p_end_date_time
3923: AND t.task_type_id IN (20, 21)

Line 4088: , jtf_tasks_b t

4084: , ta.sched_travel_duration_uom
4085: ) travel_time
4086: FROM jtf_task_assignments ta
4087: , jtf_task_statuses_b ts
4088: , jtf_tasks_b t
4089: WHERE ta.resource_id = p_resource_id
4090: AND ta.resource_type_code = p_resource_type
4091: AND ta.assignee_role = 'ASSIGNEE'
4092: AND ts.task_status_id = ta.assignment_status_id

Line 4970: FROM jtf_tasks_b t

4966:
4967: CURSOR c_dangling_tasks(p_res_id number,p_res_type varchar2)
4968: IS
4969: SELECT t.task_id,t.object_version_number,scheduled_start_date,scheduled_end_date
4970: FROM jtf_tasks_b t
4971: , jtf_task_assignments ta
4972: WHERE t.owner_id = p_res_id
4973: AND t.owner_type_code = p_res_type
4974: AND t.planned_start_date BETWEEN p_start AND p_end

Line 4982: FROM jtf_tasks_b t

4978: AND ta.assignee_role = 'ASSIGNEE'
4979: AND ta.object_capacity_id IS NULL
4980: UNION
4981: SELECT t.task_id,t.object_version_number,scheduled_start_date,scheduled_end_date
4982: FROM jtf_tasks_b t
4983: WHERE t.owner_id = p_res_id
4984: AND t.owner_type_code = p_res_type
4985: AND t.task_type_id IN (20, 21)
4986: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 4998: FROM JTF_TASKS_B

4994: scheduled_start_date,
4995: scheduled_end_date,
4996: owner_id,
4997: owner_type_code
4998: FROM JTF_TASKS_B
4999: WHERE TASK_ID IN
5000: (SELECT TASK_ID
5001: FROM JTF_TASK_ASSIGNMENTS
5002: WHERE OBJECT_CAPACITY_ID IN

Line 5005: jtf_tasks_b jtb,

5001: FROM JTF_TASK_ASSIGNMENTS
5002: WHERE OBJECT_CAPACITY_ID IN
5003: (SELECT co.object_capacity_id
5004: FROM cac_sr_object_capacity co,
5005: jtf_tasks_b jtb,
5006: jtf_task_assignments jta,
5007: jtf_task_statuses_b jts,
5008: jtf_Task_statuses_b jtsa
5009: WHERE jtb.task_id =jta.task_id

Line 5193: , jtf_tasks_b t

5189: , ta.sched_travel_duration_uom
5190: ) travel_time
5191: FROM jtf_task_assignments ta
5192: , jtf_task_statuses_b ts
5193: , jtf_tasks_b t
5194: WHERE ta.resource_id = p_resource_id
5195: AND ta.resource_type_code = p_resource_type
5196: AND ta.assignee_role = 'ASSIGNEE'
5197: AND ts.task_status_id = ta.assignment_status_id