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 104: FROM jtf_tasks_b jtb,

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

Line 159: FROM jtf_tasks_b jtb,

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

Line 904: FROM jtf_tasks_b jtb,

900: SELECT distinct jtb.task_id,
901: jta.resource_id,
902: jta.resource_type_code,
903: jta.assignment_status_id
904: FROM jtf_tasks_b jtb,
905: jtf_task_assignments jta,
906: jtf_task_priorities_vl jp_vl,
907: jtf_task_types_vl jtt_vl
908: WHERE jta.task_assignment_id = v_task_assgn_id

Line 1496: jtf_tasks_b t

1492: n.notes
1493: from
1494: jtf_notes_vl n,
1495: jtf_task_assignments a,
1496: jtf_tasks_b t
1497: where
1498: n.source_object_code = 'SR'
1499: and n.source_object_id = t.source_object_id
1500: and t.task_id = a.task_id

Line 1735: jtf_tasks_b t

1731: n.notes
1732: from
1733: jtf_notes_vl n,
1734: jtf_task_assignments a,
1735: jtf_tasks_b t
1736: where
1737: n.source_object_code = 'SR'
1738: and n.source_object_id = t.source_object_id
1739: and t.task_id = a.task_id

Line 1971: jtf_tasks_b t

1967: union select
1968: n.notes
1969: from
1970: jtf_notes_vl n,
1971: jtf_tasks_b t
1972: where
1973: n.source_object_code = 'SR'
1974: and n.source_object_id = t.source_object_id
1975: and t.task_id = v_task_id;

Line 2193: jtf_tasks_b t

2189: union select
2190: n.notes
2191: from
2192: jtf_notes_vl n,
2193: jtf_tasks_b t
2194: where
2195: n.source_object_code = 'SR'
2196: and n.source_object_id = t.source_object_id
2197: and t.task_id = v_task_id;

Line 2516: l_task_number jtf_tasks_b.task_number%type;

2512:
2513: l_task_asgn_record task_asgn_record;
2514: l_contact_record contact_record;
2515:
2516: l_task_number jtf_tasks_b.task_number%type;
2517: l_task_name jtf_tasks_vl.task_name%type;
2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;

Line 2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;

2515:
2516: l_task_number jtf_tasks_b.task_number%type;
2517: l_task_name jtf_tasks_vl.task_name%type;
2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2521: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2523: l_planned_effort varchar2(100);

Line 2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;

2516: l_task_number jtf_tasks_b.task_number%type;
2517: l_task_name jtf_tasks_vl.task_name%type;
2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2521: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2523: l_planned_effort varchar2(100);
2524: l_priority jtf_task_priorities_vl.name%type;

Line 2521: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;

2517: l_task_name jtf_tasks_vl.task_name%type;
2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2521: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2523: l_planned_effort varchar2(100);
2524: l_priority jtf_task_priorities_vl.name%type;
2525: l_asgm_sts_name jtf_task_statuses_vl.name%type;

Line 2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;

2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2521: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2523: l_planned_effort varchar2(100);
2524: l_priority jtf_task_priorities_vl.name%type;
2525: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2526: l_sr_number cs_incidents_all_b.incident_number%type;

Line 2561: jtf_tasks_b jtb,

2557: msi_b.description item_description,
2558: chscp.contact_type contact_type,
2559: chscp.party_id contact_party_id
2560: FROM
2561: jtf_tasks_b jtb,
2562: jtf_task_assignments jta,
2563: jtf_tasks_vl j_vl,
2564: jtf_task_priorities_vl jp_vl,
2565: jtf_task_statuses_vl js_vl,

Line 2608: jtf_tasks_b jtb,

2604: msi_b.description item_description,
2605: chscp.contact_type contact_type,
2606: chscp.party_id contact_party_id
2607: FROM
2608: jtf_tasks_b jtb,
2609: jtf_tasks_vl j_vl,
2610: jtf_task_priorities_vl jp_vl,
2611: cs_incidents_all c_b,
2612: hz_party_sites hps,

Line 2653: jtf_tasks_b jtb,

2649: chscp.party_id contact_party_id,
2650: jtab.old_scheduled_start_date old_sch_st_date,
2651: jtab.old_scheduled_end_date old_sch_end_date
2652: FROM
2653: jtf_tasks_b jtb,
2654: jtf_task_audits_b jtab,
2655: jtf_tasks_vl j_vl,
2656: jtf_task_priorities_vl jp_vl,
2657: cs_incidents_all c_b,