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_MAP_PVT dependencies on CAC_SR_OBJECT_CAPACITY

Line 123: cac_sr_object_capacity cso

119: SELECT task_assignment_id,
120: scheduled_end_date
121: FROM jtf_tasks_b jtb,
122: jtf_task_assignments jta,
123: cac_sr_object_capacity cso
124: WHERE jta.resource_id = p_res_id
125: AND jta.resource_type_code = p_res_type
126: AND jta.object_capacity_id = cso.object_capacity_id
127: AND jta.task_id = jtb.task_id

Line 156: cac_sr_object_capacity cso

152: SELECT jta.task_assignment_id,
153: jtb.scheduled_end_date
154: FROM jtf_tasks_b jtb,
155: jtf_task_assignments jta,
156: cac_sr_object_capacity cso
157: WHERE jta.resource_id = p_res_id
158: AND jta.resource_type_code = p_res_type
159: AND jta.object_capacity_id = cso.object_capacity_id
160: AND jta.task_id = jtb.task_id

Line 252: cac_sr_object_capacity cso

248: jtb.planned_end_date,
249: jtb.task_type_id
250: FROM jtf_tasks_b jtb,
251: jtf_task_assignments jta,
252: cac_sr_object_capacity cso
253: WHERE jta.object_capacity_id = cso.object_capacity_id
254: AND jta.task_id = jtb.task_id
255: AND jta.task_assignment_id = p_ta_id;
256: BEGIN

Line 389: FROM jtf_task_assignments jta, cac_sr_object_capacity cso

385: )
386: ) predicted_start_date,
387: MAX (end_date_time) shift_end
388: -- NVL (jta.actual_end_date, jtb.scheduled_end_date + predict_time_difference (jta.task_assignment_id)) predicted_end_date
389: FROM jtf_task_assignments jta, cac_sr_object_capacity cso
390: WHERE jta.resource_id = p_res_id
391: AND jta.resource_type_code = p_res_type
392: AND TRUNC (p_date) BETWEEN TRUNC (jta.booking_start_date)
393: AND TRUNC (jta.booking_end_date)