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

Line 604: , jtf_task_statuses_b s_old

600: and a.creation_date+0 <= l_collect_to_date
601: and nvl(t.task_split_flag,'N') in ('N','M')
602: ) x
603: ) a
604: , jtf_task_statuses_b s_old
605: , jtf_task_statuses_b s_new
606: where
607: a.task_status_id = s_new.task_status_id
608: and a.old_task_status_id = s_old.task_status_id(+);

Line 605: , jtf_task_statuses_b s_new

601: and nvl(t.task_split_flag,'N') in ('N','M')
602: ) x
603: ) a
604: , jtf_task_statuses_b s_old
605: , jtf_task_statuses_b s_new
606: where
607: a.task_status_id = s_new.task_status_id
608: and a.old_task_status_id = s_old.task_status_id(+);
609:

Line 1014: , jtf_task_statuses_b s_old

1010: and a.creation_date >= l_collect_from_date
1011: and a.creation_date <= l_collect_to_date
1012: ) x
1013: ) a
1014: , jtf_task_statuses_b s_old
1015: , jtf_task_statuses_b s_new
1016: where
1017: a.task_status_id = s_new.task_status_id
1018: and a.old_task_status_id = s_old.task_status_id(+);

Line 1015: , jtf_task_statuses_b s_new

1011: and a.creation_date <= l_collect_to_date
1012: ) x
1013: ) a
1014: , jtf_task_statuses_b s_old
1015: , jtf_task_statuses_b s_new
1016: where
1017: a.task_status_id = s_new.task_status_id
1018: and a.old_task_status_id = s_old.task_status_id(+);
1019:

Line 1236: , jtf_task_statuses_b s

1232: isc_fs_task_act_bac_stg
1233: where last_row_for_day_flag = 'Y'
1234: ) b
1235: , isc_fs_tasks_f t
1236: , jtf_task_statuses_b s
1237: where
1238: b.rnk = 1
1239: and b.status_flag = 'O'
1240: and trunc(b.audit_date) < trunc(l_collect_to_date)