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_TASK_STATUSES_B

Line 321: , jtf_task_statuses_b ts

317: FROM cac_sr_object_capacity oc
318: WHERE object_capacity_id = p_trip_id
319: AND EXISTS (SELECT 1
320: FROM jtf_task_assignments ta
321: , jtf_task_statuses_b ts
322: , jtf_tasks_b t
323: WHERE ta.object_capacity_id = oc.object_capacity_id
324: AND ts.task_status_id = ta.assignment_status_id
325: AND NVL(ts.closed_flag, 'N') = 'N'

Line 637: , jtf_task_statuses_b ts

633: ta.sched_travel_duration
634: , ta.sched_travel_duration_uom
635: ) travel_time
636: FROM jtf_task_assignments ta
637: , jtf_task_statuses_b ts
638: , jtf_tasks_b t
639: WHERE ta.resource_id = p_resource_id
640: AND ta.resource_type_code = p_resource_type
641: AND ta.assignee_role = 'ASSIGNEE'

Line 854: , jtf_task_statuses_b ts

850: , t.task_status_id
851: FROM cac_sr_object_capacity cac
852: , jtf_task_assignments ta
853: , jtf_tasks_b t
854: , jtf_task_statuses_b ts
855: WHERE cac.object_capacity_id = p_trip.trip_id
856: AND ta.resource_id = cac.object_id
857: AND ta.resource_type_code = cac.object_type
858: AND ( (ta.object_capacity_id IS NOT NULL AND ta.object_capacity_id = cac.object_capacity_id)

Line 1195: , jtf_task_statuses_b ts

1191: , oc.object_capacity_id correct_trip_id
1192: FROM cac_sr_object_capacity oc
1193: , jtf_task_assignments ta
1194: , jtf_tasks_b t
1195: , jtf_task_statuses_b ts
1196: WHERE oc.object_capacity_id = p_trip.trip_id
1197: AND ta.resource_id = oc.object_id
1198: AND ta.resource_type_code = oc.object_type
1199: AND ta.assignee_role = 'ASSIGNEE'

Line 1219: , jtf_task_statuses_b ts

1215: , oc.object_capacity_id correct_trip_id
1216: FROM cac_sr_object_capacity oc
1217: , jtf_task_assignments ta
1218: , jtf_tasks_b t
1219: , jtf_task_statuses_b ts
1220: WHERE ta.object_capacity_id = p_trip.trip_id
1221: AND oc.object_id = ta.resource_id
1222: AND oc.object_type = ta.resource_type_code
1223: AND oc.object_capacity_id <> ta.object_capacity_id

Line 1251: , jtf_task_statuses_b ts

1247: ta.sched_travel_duration
1248: , ta.sched_travel_duration_uom
1249: ), 0)) travel_time
1250: FROM jtf_task_assignments ta
1251: , jtf_task_statuses_b ts
1252: WHERE ta.object_capacity_id = p_trip.trip_id
1253: AND ts.task_status_id = ta.assignment_status_id
1254: AND NVL(ts.closed_flag, 'N') = 'N'
1255: AND NVL(ts.completed_flag, 'N') = 'N'

Line 1631: , jtf_task_statuses_b ts

1627: , ta.sched_travel_duration_uom
1628: ) travel_time
1629: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc
1630: , jtf_task_assignments ta
1631: , jtf_task_statuses_b ts
1632: , jtf_tasks_b t
1633: WHERE ta.object_capacity_id = oc.COLUMN_VALUE
1634: AND ts.task_status_id = ta.assignment_status_id
1635: AND NVL(ts.closed_flag, 'N') = 'N'