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

Line 150: , jtf_task_statuses_b s

146:
147: CURSOR c_esc(b_task_id NUMBER) IS
148: SELECT DECODE(t.escalation_level, 'DE', 'N', 'NE', 'N', 'Y')
149: FROM jtf_tasks_b t
150: , jtf_task_statuses_b s
151: WHERE t.task_id = b_task_id
152: AND t.task_type_id = 22
153: AND s.task_status_id = t.task_status_id
154: AND NVL(s.closed_flag, 'N') <> 'Y'

Line 266: , jtf_task_statuses_b sb

262: FROM jtf_task_assignments a
263: , jtf_tasks_b tb
264: , jtf_task_types_tl tt
265: , jtf_tasks_tl tl
266: , jtf_task_statuses_b sb
267: , jtf_task_statuses_tl sl
268: , hz_party_sites ps
269: , hz_locations hl
270: , hz_parties pi

Line 851: , jtf_task_statuses_b sb

847: FROM jtf_task_assignments a
848: , jtf_tasks_b tb
849: , jtf_task_types_tl tt
850: , jtf_tasks_tl tl
851: , jtf_task_statuses_b sb
852: , jtf_task_statuses_tl sl
853: , hz_party_sites ps
854: , hz_locations hl
855: , hz_parties pi

Line 2472: , jtf_task_statuses_b tsa

2468: ) res_info
2469: , jtf_task_assignments a
2470: , jtf_tasks_b t
2471: , jtf_task_types_b tt
2472: , jtf_task_statuses_b tsa
2473: , jtf_task_statuses_b tsb
2474: WHERE t.task_id = a.task_id
2475: AND t.task_type_id = tt.task_type_id
2476: AND (t.task_type_id = 20 OR t.task_type_id = 21)

Line 2473: , jtf_task_statuses_b tsb

2469: , jtf_task_assignments a
2470: , jtf_tasks_b t
2471: , jtf_task_types_b tt
2472: , jtf_task_statuses_b tsa
2473: , jtf_task_statuses_b tsb
2474: WHERE t.task_id = a.task_id
2475: AND t.task_type_id = tt.task_type_id
2476: AND (t.task_type_id = 20 OR t.task_type_id = 21)
2477: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 2559: , jtf_task_statuses_b tsb

2555: ) res_info
2556: , jtf_task_assignments a
2557: , jtf_tasks_b t
2558: , jtf_task_types_b tt
2559: , jtf_task_statuses_b tsb
2560: , jtf_task_statuses_b tsa
2561: , hz_parties pi
2562: , csf_access_hours_b ca
2563: , csp_requirement_headers cr

Line 2560: , jtf_task_statuses_b tsa

2556: , jtf_task_assignments a
2557: , jtf_tasks_b t
2558: , jtf_task_types_b tt
2559: , jtf_task_statuses_b tsb
2560: , jtf_task_statuses_b tsa
2561: , hz_parties pi
2562: , csf_access_hours_b ca
2563: , csp_requirement_headers cr
2564: WHERE t.task_id = a.task_id

Line 2636: , jtf_task_statuses_b tsb

2632: ) res_info
2633: , jtf_task_assignments a
2634: , jtf_tasks_b t
2635: , jtf_task_types_b tt
2636: , jtf_task_statuses_b tsb
2637: , jtf_task_statuses_b tsa
2638: , hz_parties pi
2639: , csf_access_hours_b ca
2640: , jtf_task_depends jd

Line 2637: , jtf_task_statuses_b tsa

2633: , jtf_task_assignments a
2634: , jtf_tasks_b t
2635: , jtf_task_types_b tt
2636: , jtf_task_statuses_b tsb
2637: , jtf_task_statuses_b tsa
2638: , hz_parties pi
2639: , csf_access_hours_b ca
2640: , jtf_task_depends jd
2641: , jtf_task_depends jdd

Line 2714: , jtf_task_statuses_b tsb

2710: ) res_info
2711: , jtf_task_assignments a
2712: , jtf_tasks_b t
2713: , jtf_task_types_b tt
2714: , jtf_task_statuses_b tsb
2715: , jtf_task_statuses_b tsa
2716: , csf_access_hours_b ca
2717: , csp_requirement_headers cr
2718: WHERE t.task_id = a.task_id

Line 2715: , jtf_task_statuses_b tsa

2711: , jtf_task_assignments a
2712: , jtf_tasks_b t
2713: , jtf_task_types_b tt
2714: , jtf_task_statuses_b tsb
2715: , jtf_task_statuses_b tsa
2716: , csf_access_hours_b ca
2717: , csp_requirement_headers cr
2718: WHERE t.task_id = a.task_id
2719: AND t.source_object_type_code in( 'SR','TASK')

Line 2789: , jtf_task_statuses_b tsb

2785: ) res_info
2786: , jtf_task_assignments a
2787: , jtf_tasks_b t
2788: , jtf_task_types_b tt
2789: , jtf_task_statuses_b tsb
2790: , jtf_task_statuses_b tsa
2791: , csf_access_hours_b ca
2792: , jtf_task_depends jd
2793: , jtf_task_depends jdd

Line 2790: , jtf_task_statuses_b tsa

2786: , jtf_task_assignments a
2787: , jtf_tasks_b t
2788: , jtf_task_types_b tt
2789: , jtf_task_statuses_b tsb
2790: , jtf_task_statuses_b tsa
2791: , csf_access_hours_b ca
2792: , jtf_task_depends jd
2793: , jtf_task_depends jdd
2794: , csp_requirement_headers cr

Line 3783: , jtf_task_statuses_b tsa

3779: , jtf_tasks_b t
3780: , hz_parties pi
3781: , csf_access_hours_b ca
3782: , csp_requirement_headers cr
3783: , jtf_task_statuses_b tsa
3784: , jtf_task_statuses_b tsb
3785: WHERE cpv.sched_request_id = p_req_id
3786: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3787: AND cpv.start_time >= p_start_date

Line 3784: , jtf_task_statuses_b tsb

3780: , hz_parties pi
3781: , csf_access_hours_b ca
3782: , csp_requirement_headers cr
3783: , jtf_task_statuses_b tsa
3784: , jtf_task_statuses_b tsb
3785: WHERE cpv.sched_request_id = p_req_id
3786: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3787: AND cpv.start_time >= p_start_date
3788: AND cpv.end_time <= p_end_date

Line 3842: , jtf_task_statuses_b tsa

3838: , csf_access_hours_b ca
3839: , csp_requirement_headers cr
3840: , jtf_task_depends jd
3841: , jtf_task_depends jdd
3842: , jtf_task_statuses_b tsa
3843: , jtf_task_statuses_b tsb
3844: WHERE cpv.sched_request_id = p_req_id
3845: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3846: AND cpv.start_time >= p_start_date

Line 3843: , jtf_task_statuses_b tsb

3839: , csp_requirement_headers cr
3840: , jtf_task_depends jd
3841: , jtf_task_depends jdd
3842: , jtf_task_statuses_b tsa
3843: , jtf_task_statuses_b tsb
3844: WHERE cpv.sched_request_id = p_req_id
3845: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3846: AND cpv.start_time >= p_start_date
3847: AND cpv.end_time <= p_end_date

Line 3899: , jtf_task_statuses_b tsa

3895: , jtf_task_assignments a
3896: , jtf_tasks_b t
3897: , csf_access_hours_b ca
3898: , csp_requirement_headers cr
3899: , jtf_task_statuses_b tsa
3900: , jtf_task_statuses_b tsb
3901: WHERE cpv.sched_request_id = p_req_id
3902: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3903: AND cpv.start_time >= p_start_date

Line 3900: , jtf_task_statuses_b tsb

3896: , jtf_tasks_b t
3897: , csf_access_hours_b ca
3898: , csp_requirement_headers cr
3899: , jtf_task_statuses_b tsa
3900: , jtf_task_statuses_b tsb
3901: WHERE cpv.sched_request_id = p_req_id
3902: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3903: AND cpv.start_time >= p_start_date
3904: AND cpv.end_time <= p_end_date

Line 3956: , jtf_task_statuses_b tsa

3952: , csf_access_hours_b ca
3953: , csp_requirement_headers cr
3954: , jtf_task_depends jd
3955: , jtf_task_depends jdd
3956: , jtf_task_statuses_b tsa
3957: , jtf_task_statuses_b tsb
3958: WHERE cpv.sched_request_id = p_req_id
3959: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3960: AND cpv.start_time >= p_start_date

Line 3957: , jtf_task_statuses_b tsb

3953: , csp_requirement_headers cr
3954: , jtf_task_depends jd
3955: , jtf_task_depends jdd
3956: , jtf_task_statuses_b tsa
3957: , jtf_task_statuses_b tsb
3958: WHERE cpv.sched_request_id = p_req_id
3959: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
3960: AND cpv.start_time >= p_start_date
3961: AND cpv.end_time <= p_end_date

Line 4051: , jtf_task_statuses_b tsb

4047: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4048: , jtf_task_assignments a
4049: , jtf_tasks_b t
4050: , jtf_task_types_b tt
4051: , jtf_task_statuses_b tsb
4052: , jtf_task_statuses_b tsa
4053: , hz_parties pi
4054: , csf_access_hours_b ca
4055: , csp_requirement_headers cr

Line 4052: , jtf_task_statuses_b tsa

4048: , jtf_task_assignments a
4049: , jtf_tasks_b t
4050: , jtf_task_types_b tt
4051: , jtf_task_statuses_b tsb
4052: , jtf_task_statuses_b tsa
4053: , hz_parties pi
4054: , csf_access_hours_b ca
4055: , csp_requirement_headers cr
4056: WHERE t.task_id = a.task_id

Line 4133: , jtf_task_statuses_b tsb

4129: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4130: , jtf_task_assignments a
4131: , jtf_tasks_b t
4132: , jtf_task_types_b tt
4133: , jtf_task_statuses_b tsb
4134: , jtf_task_statuses_b tsa
4135: , hz_parties pi
4136: , csf_access_hours_b ca
4137: , jtf_task_depends jd

Line 4134: , jtf_task_statuses_b tsa

4130: , jtf_task_assignments a
4131: , jtf_tasks_b t
4132: , jtf_task_types_b tt
4133: , jtf_task_statuses_b tsb
4134: , jtf_task_statuses_b tsa
4135: , hz_parties pi
4136: , csf_access_hours_b ca
4137: , jtf_task_depends jd
4138: , jtf_task_depends jdd

Line 4216: , jtf_task_statuses_b tsb

4212: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4213: , jtf_task_assignments a
4214: , jtf_tasks_b t
4215: , jtf_task_types_b tt
4216: , jtf_task_statuses_b tsb
4217: , jtf_task_statuses_b tsa
4218: , csf_access_hours_b ca
4219: , csp_requirement_headers cr
4220: WHERE t.task_id = a.task_id

Line 4217: , jtf_task_statuses_b tsa

4213: , jtf_task_assignments a
4214: , jtf_tasks_b t
4215: , jtf_task_types_b tt
4216: , jtf_task_statuses_b tsb
4217: , jtf_task_statuses_b tsa
4218: , csf_access_hours_b ca
4219: , csp_requirement_headers cr
4220: WHERE t.task_id = a.task_id
4221: AND t.source_object_type_code in( 'SR','TASK')

Line 4296: , jtf_task_statuses_b tsb

4292: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
4293: , jtf_task_assignments a
4294: , jtf_tasks_b t
4295: , jtf_task_types_b tt
4296: , jtf_task_statuses_b tsb
4297: , jtf_task_statuses_b tsa
4298: , csf_access_hours_b ca
4299: , jtf_task_depends jd
4300: , jtf_task_depends jdd

Line 4297: , jtf_task_statuses_b tsa

4293: , jtf_task_assignments a
4294: , jtf_tasks_b t
4295: , jtf_task_types_b tt
4296: , jtf_task_statuses_b tsb
4297: , jtf_task_statuses_b tsa
4298: , csf_access_hours_b ca
4299: , jtf_task_depends jd
4300: , jtf_task_depends jdd
4301: , csp_requirement_headers cr