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.CSL_JTF_TASK_REFS_ACC_PKG dependencies on JTF_TASK_STATUSES_B

Line 20: jtf_task_statuses_b jts

16: CURSOR c_esc(b_task_id NUMBER, b_resource_id NUMBER, b_last_run_date DATE ) IS
17: SELECT jtr.task_reference_id
18: FROM jtf_tasks_b jtb,
19: jtf_task_references_b jtr,
20: jtf_task_statuses_b jts
21: WHERE jtb.task_id = jtr.task_id
22: AND jtb.task_type_id = 22
23: AND jtb.task_status_id = jts.task_status_id
24: AND NVL(jts.closed_flag, 'N') <> 'Y'

Line 167: jtf_task_statuses_b jts

163: AND task_reference_id NOT IN(
164: SELECT jtr.task_reference_id
165: FROM jtf_tasks_b jtb,
166: jtf_task_references_b jtr,
167: jtf_task_statuses_b jts
168: WHERE jtb.task_id = jtr.task_id
169: AND jtb.task_type_id = 22
170: AND jtb.task_status_id = jts.task_status_id
171: AND NVL(jts.closed_flag, 'N') <> 'Y'