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_TASKS_B

Line 56: FROM jtf_tasks_b jtb,

52: jtb.scheduled_end_date,
53: jta.resource_id,
54: jta.resource_type_code,
55: jta.assignment_status_id
56: FROM jtf_tasks_b jtb,
57: jtf_task_assignments jta,
58: jtf_task_priorities_vl jp_vl,
59: jtf_task_types_vl jtt_vl
60: WHERE jta.task_assignment_id = v_task_assgn_id

Line 105: FROM jtf_tasks_b jtb,

101: jtb.scheduled_start_date,
102: jtb.scheduled_end_date,
103: jta.resource_id,
104: jta.resource_type_code
105: FROM jtf_tasks_b jtb,
106: jtf_task_assignments jta,
107: jtf_task_priorities_vl jp_vl,
108: jtf_task_types_vl jtt_vl
109: WHERE jta.task_assignment_id = v_task_assgn_id

Line 161: FROM jtf_tasks_b jtb,

157:
158: cursor c_task_detail (v_task_id number, v_resource_id number, v_resource_type_code varchar2) is
159: SELECT jtb.scheduled_start_date,
160: jtb.scheduled_end_date
161: FROM jtf_tasks_b jtb,
162: jtf_task_priorities_vl jp_vl,
163: jtf_task_types_vl jtt_vl
164: WHERE jtb.task_id = v_task_id
165: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 196: jtf_tasks_b jtb

192: (select
193: 'TRUE'
194: from
195: jtf_task_audits_b jtab,
196: jtf_tasks_b jtb
197: where
198: jtb.task_id = v_task_id
199: and jtb.source_object_type_code = 'SR'
200: and jtb.task_id = jtab.task_id

Line 208: jtf_tasks_b jtb

204: (select
205: 'TRUE'
206: from
207: jtf_task_audits_b jtab,
208: jtf_tasks_b jtb
209: where
210: jtb.task_id = v_task_id
211: and jtb.source_object_type_code = 'SR'
212: and jtb.task_id = jtab.task_id

Line 914: FROM jtf_tasks_b jtb,

910: SELECT distinct jtb.task_id,
911: jta.resource_id,
912: jta.resource_type_code,
913: jta.assignment_status_id
914: FROM jtf_tasks_b jtb,
915: jtf_task_assignments jta,
916: jtf_task_priorities_vl jp_vl,
917: jtf_task_types_vl jtt_vl
918: WHERE jta.task_assignment_id = v_task_assgn_id

Line 1506: jtf_tasks_b t

1502: n.notes
1503: from
1504: jtf_notes_vl n,
1505: jtf_task_assignments a,
1506: jtf_tasks_b t
1507: where
1508: n.source_object_code = 'SR'
1509: and n.source_object_id = t.source_object_id
1510: and t.task_id = a.task_id

Line 1745: jtf_tasks_b t

1741: n.notes
1742: from
1743: jtf_notes_vl n,
1744: jtf_task_assignments a,
1745: jtf_tasks_b t
1746: where
1747: n.source_object_code = 'SR'
1748: and n.source_object_id = t.source_object_id
1749: and t.task_id = a.task_id

Line 1981: jtf_tasks_b t

1977: union select
1978: n.notes
1979: from
1980: jtf_notes_vl n,
1981: jtf_tasks_b t
1982: where
1983: n.source_object_code = 'SR'
1984: and n.source_object_id = t.source_object_id
1985: and t.task_id = v_task_id;

Line 2203: jtf_tasks_b t

2199: union select
2200: n.notes
2201: from
2202: jtf_notes_vl n,
2203: jtf_tasks_b t
2204: where
2205: n.source_object_code = 'SR'
2206: and n.source_object_id = t.source_object_id
2207: and t.task_id = v_task_id;

Line 2526: l_task_number jtf_tasks_b.task_number%type;

2522:
2523: l_task_asgn_record task_asgn_record;
2524: l_contact_record contact_record;
2525:
2526: l_task_number jtf_tasks_b.task_number%type;
2527: l_task_name jtf_tasks_vl.task_name%type;
2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;

Line 2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;

2525:
2526: l_task_number jtf_tasks_b.task_number%type;
2527: l_task_name jtf_tasks_vl.task_name%type;
2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2531: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2533: l_planned_effort varchar2(100);

Line 2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;

2526: l_task_number jtf_tasks_b.task_number%type;
2527: l_task_name jtf_tasks_vl.task_name%type;
2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2531: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2533: l_planned_effort varchar2(100);
2534: l_priority jtf_task_priorities_vl.name%type;

Line 2531: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;

2527: l_task_name jtf_tasks_vl.task_name%type;
2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2531: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2533: l_planned_effort varchar2(100);
2534: l_priority jtf_task_priorities_vl.name%type;
2535: l_asgm_sts_name jtf_task_statuses_vl.name%type;

Line 2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;

2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2531: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2533: l_planned_effort varchar2(100);
2534: l_priority jtf_task_priorities_vl.name%type;
2535: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2536: l_sr_number cs_incidents_all_b.incident_number%type;

Line 2571: jtf_tasks_b jtb,

2567: msi_b.description item_description,
2568: chscp.contact_type contact_type,
2569: chscp.party_id contact_party_id
2570: FROM
2571: jtf_tasks_b jtb,
2572: jtf_task_assignments jta,
2573: jtf_tasks_vl j_vl,
2574: jtf_task_priorities_vl jp_vl,
2575: jtf_task_statuses_vl js_vl,

Line 2618: jtf_tasks_b jtb,

2614: msi_b.description item_description,
2615: chscp.contact_type contact_type,
2616: chscp.party_id contact_party_id
2617: FROM
2618: jtf_tasks_b jtb,
2619: jtf_tasks_vl j_vl,
2620: jtf_task_priorities_vl jp_vl,
2621: cs_incidents_all c_b,
2622: hz_party_sites hps,

Line 2663: jtf_tasks_b jtb,

2659: chscp.party_id contact_party_id,
2660: jtab.old_scheduled_start_date old_sch_st_date,
2661: jtab.old_scheduled_end_date old_sch_end_date
2662: FROM
2663: jtf_tasks_b jtb,
2664: jtf_task_audits_b jtab,
2665: jtf_tasks_vl j_vl,
2666: jtf_task_priorities_vl jp_vl,
2667: cs_incidents_all c_b,