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_ALERTS_PUB dependencies on JTF_TASK_STATUSES_B

Line 69: jtf_task_statuses_b

65: and jta.assignment_status_id in (
66: select
67: task_status_id
68: from
69: jtf_task_statuses_b
70: where
71: usage = 'TASK'
72: and nvl(assigned_flag, 'N') = 'Y'
73: and nvl(assignment_status_flag, 'N') = 'Y'

Line 140: jtf_task_statuses_b

136: cursor c_check_task_status_id (v_new_status_id number, v_old_status_id number) is
137: select 'TRUE' from dual where v_old_status_id in (select
138: task_status_id
139: from
140: jtf_task_statuses_b
141: where
142: usage = 'TASK'
143: and nvl(assigned_flag, 'N') <> 'Y'
144: and nvl(assignment_status_flag, 'N') = 'Y'

Line 150: jtf_task_statuses_b

146: and nvl(end_date_active, sysdate + 1))
147: and v_new_status_id in (select
148: task_status_id
149: from
150: jtf_task_statuses_b
151: where
152: usage = 'TASK'
153: and nvl(assigned_flag, 'N') = 'Y'
154: and nvl(assignment_status_flag, 'N') = 'Y'

Line 926: jtf_task_statuses_b

922: and jta.assignment_status_id in (
923: select
924: task_status_id
925: from
926: jtf_task_statuses_b
927: where
928: usage = 'TASK'
929: and nvl(assigned_flag, 'N') = 'Y'
930: and nvl(assignment_status_flag, 'N') = 'Y'