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.

[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on CAC_SR_OBJECT_CAPACITY

Line 2352: , cac_sr_object_capacity cac

2348: , ta.resource_type_code
2349: FROM jtf_tasks_b t
2350: , jtf_task_assignments ta
2351: , jtf_task_statuses_b ts
2352: , cac_sr_object_capacity cac
2353: WHERE t.task_id = p_task_id
2354: AND ta.task_id = t.task_id
2355: AND ts.task_status_id = ta.assignment_status_id
2356: AND NVL (ts.assigned_flag, 'N') <> 'Y'

Line 2383: , cac_sr_object_capacity cac

2379: , ta.resource_type_code
2380: FROM jtf_tasks_b t
2381: , jtf_task_assignments ta
2382: , jtf_task_statuses_b ts
2383: , cac_sr_object_capacity cac
2384: WHERE t.task_id = p_task_id
2385: AND ta.task_id = t.task_id
2386: AND ts.task_status_id = ta.assignment_status_id
2387: AND NVL (ts.assigned_flag, 'N') <> 'Y'

Line 2631: , cac_sr_object_capacity cac

2627: , cac.status trip_status
2628: FROM jtf_tasks_b t
2629: , jtf_task_assignments ta
2630: , jtf_task_statuses_b ts
2631: , cac_sr_object_capacity cac
2632: WHERE t.parent_task_id = p_parent_task_id
2633: AND ta.task_id = t.task_id
2634: AND ts.task_status_id = ta.assignment_status_id
2635: AND cac.object_capacity_id(+) = ta.object_capacity_id -- made this outer join for bug 6940526

Line 2853: FROM cac_sr_object_capacity cac

2849: OPEN c_task_list FOR l_query USING p_task_id;
2850: ELSIF p_trip_id IS NOT NULL THEN
2851: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2852: , task_split_flag
2853: FROM cac_sr_object_capacity cac
2854: , jtf_task_assignments ta
2855: , jtf_tasks_b t
2856: , jtf_task_statuses_b ts
2857: WHERE cac.object_capacity_id = :1