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_TASKS_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 354: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts

350: , NVL (ts.closed_flag, 'N') closed_flag
351: , NVL (ts.cancelled_flag, 'N') cancelled_flag
352: , NVL (ts.completed_flag, 'N') completed_flag
353: , NVL (ts.rejected_flag, 'N') rejected_flag
354: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts
355: WHERE ta.task_id = t.task_id
356: AND t.task_id = p_task_id
357: AND assignment_status_id = ts.task_status_id;
358:

Line 545: FROM jtf_tasks_b t, jtf_task_assignments ta

541: , t.scheduled_end_date
542: , t.task_split_flag
543: , t.task_status_id
544: , ta.resource_id
545: FROM jtf_tasks_b t, jtf_task_assignments ta
546: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
547:
548: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
549: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;

Line 550: l_resource_id jtf_task_assignments.resource_id%TYPE;

546: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
547:
548: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
549: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;
550: l_resource_id jtf_task_assignments.resource_id%TYPE;
551: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
552: l_status_id jtf_task_statuses_b.task_status_id%TYPE;
553: BEGIN
554: -- Initialize API return status to success

Line 1191: FROM jtf_task_assignments ta, jtf_task_statuses_b ts

1187: , NVL (ts.closed_flag, 'N') closed_flag
1188: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1189: , NVL (ts.completed_flag, 'N') completed_flag
1190: , NVL (ts.rejected_flag, 'N') rejected_flag
1191: FROM jtf_task_assignments ta, jtf_task_statuses_b ts
1192: WHERE ta.task_id = p_task_id
1193: AND ts.task_status_id = ta.assignment_status_id;
1194:
1195: l_task_status_id NUMBER;

Line 1252: jtf_task_assignments_pub.update_task_assignment(

1248: RAISE fnd_api.g_exc_error;
1249: END IF;
1250:
1251: -- All validations done. Close the Task Assignment
1252: jtf_task_assignments_pub.update_task_assignment(
1253: p_api_version => 1.0
1254: , x_return_status => x_return_status
1255: , x_msg_count => x_msg_count
1256: , x_msg_data => x_msg_data

Line 1572: FROM jtf_task_assignments tas, jtf_task_statuses_b ts

1568: , tas.assignment_status_id
1569: , tas.task_id
1570: , tas.actual_effort
1571: , tas.actual_effort_uom
1572: FROM jtf_task_assignments tas, jtf_task_statuses_b ts
1573: WHERE task_id = p_task_id
1574: AND ts.task_status_id = tas.assignment_status_id
1575: AND NVL(ts.cancelled_flag, 'N') <> 'Y'
1576: AND NVL(ts.closed_flag, 'N') <> 'Y'

Line 1919: , jtf_task_assignments ta

1915: , ta.object_capacity_id
1916: , ta.assignment_status_id
1917: , cac.status trip_status
1918: FROM jtf_tasks_b t
1919: , jtf_task_assignments ta
1920: , jtf_task_statuses_b ts
1921: , cac_sr_object_capacity cac
1922: WHERE t.task_id = p_task_id
1923: AND ta.task_id = t.task_id

Line 1948: , jtf_task_assignments ta

1944: , ta.object_capacity_id
1945: , ta.assignment_status_id
1946: , cac.status trip_status
1947: FROM jtf_tasks_b t
1948: , jtf_task_assignments ta
1949: , jtf_task_statuses_b ts
1950: , cac_sr_object_capacity cac
1951: WHERE t.task_id = p_task_id
1952: AND ta.task_id = t.task_id

Line 2133: , jtf_task_assignments ta

2129: CURSOR c_child_tasks (p_parent_task_id NUMBER) IS
2130: SELECT t.task_id
2131: , cac.status trip_status
2132: FROM jtf_tasks_b t
2133: , jtf_task_assignments ta
2134: , jtf_task_statuses_b ts
2135: , cac_sr_object_capacity cac
2136: WHERE t.parent_task_id = p_parent_task_id
2137: AND ta.task_id = t.task_id

Line 2150: FROM jtf_task_assignments a

2146: --for given task
2147: CURSOR check_assignments(p_task_id number)
2148: IS
2149: SELECT count(task_id)
2150: FROM jtf_task_assignments a
2151: , jtf_task_statuses_b b
2152: WHERE a.task_id = p_task_id
2153: AND a.assignment_status_id = b.task_status_id
2154: AND nvl(b.cancelled_flag ,'N') <> 'Y';

Line 2227: , jtf_task_assignments ta

2223:
2224: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2225: , t.task_split_flag
2226: FROM jtf_tasks_b t
2227: , jtf_task_assignments ta
2228: , jtf_task_statuses_b ts
2229: WHERE ta.resource_id = :1
2230: AND ta.resource_type_code = :2
2231: AND ts.task_status_id = ta.assignment_status_id

Line 2260: , jtf_task_assignments ta

2256: ELSIF p_trip_id IS NOT NULL THEN
2257: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2258: , task_split_flag
2259: FROM cac_sr_object_capacity cac
2260: , jtf_task_assignments ta
2261: , jtf_tasks_b t
2262: , jtf_task_statuses_b ts
2263: WHERE cac.object_capacity_id = :1
2264: AND ta.resource_id = cac.object_id

Line 2906: FROM jtf_task_assignments ta, jtf_task_statuses_b ats

2902: , t.object_version_number
2903: , t.scheduled_start_date
2904: , t.scheduled_end_date
2905: , NVL( ( SELECT 'Y'
2906: FROM jtf_task_assignments ta, jtf_task_statuses_b ats
2907: WHERE ta.task_id = p_task_id
2908: AND ta.assignment_status_id = ats.task_status_id
2909: AND NVL(ats.cancelled_flag, 'N') <> 'Y'
2910: AND ROWNUM = 1

Line 2919: FROM jtf_task_assignments ta

2915:
2916: CURSOR c_task_assignment_info IS
2917: SELECT ta.resource_id
2918: , ta.resource_type_code
2919: FROM jtf_task_assignments ta
2920: WHERE ta.task_assignment_id = p_old_task_assignment_id;
2921:
2922: l_task_info c_task_info%ROWTYPE;
2923: l_task_assignment_info c_task_assignment_info%ROWTYPE;

Line 3119: FROM jtf_tasks_b t , jtf_task_assignments ta

3115: , scheduled_start_date
3116: , scheduled_end_date
3117: , ta.assignment_status_id
3118: , ta.object_capacity_id
3119: FROM jtf_tasks_b t , jtf_task_assignments ta
3120: WHERE t.task_id = p_task_id
3121: AND ta.task_id = t.task_id
3122: AND ta.task_assignment_id = p_task_assignment_id;
3123:

Line 3301: jtf_task_assignments_pub.update_task_assignment(

3297: IF p_sched_travel_distance IS NOT NULL
3298: OR p_sched_travel_duration IS NOT NULL
3299: OR p_sched_travel_duration_uom IS NOT NULL
3300: THEN
3301: jtf_task_assignments_pub.update_task_assignment(
3302: p_api_version => 1.0
3303: , x_return_status => x_return_status
3304: , x_msg_count => x_msg_count
3305: , x_msg_data => x_msg_data

Line 3399: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta

3395: , t.task_status_id
3396: , ta.task_assignment_id
3397: , ta.object_version_number task_assignment_ovn
3398: , ta.assignment_status_id
3399: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta
3400: WHERE t.parent_task_id = p_task_id
3401: AND NVL(t.deleted_flag, 'N') <> 'Y'
3402: AND ts.task_status_id = t.task_status_id
3403: AND NVL(ts.cancelled_flag, 'N') <> 'Y'

Line 3726: jtf_task_assignments_pub.create_task_assignment(

3722: END IF;
3723: END IF;
3724:
3725: -- Create the Task Assignment
3726: jtf_task_assignments_pub.create_task_assignment(
3727: p_api_version => 1.0
3728: , x_return_status => x_return_status
3729: , x_msg_count => x_msg_count
3730: , x_msg_data => x_msg_data

Line 4558: from jtf_task_assignments jta,jtf_tasks_b jt

4554:
4555: cursor c_task_ass(p_task_id number)
4556: is
4557: select jta.task_assignment_id
4558: from jtf_task_assignments jta,jtf_tasks_b jt
4559: where jt.task_id=p_task_id
4560: and jta.task_id=jt.task_id
4561: and jt.source_object_type_code = 'TASK'
4562: and jt.task_type_id not in (20,21);