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 203: , jtf_task_statuses_b s

199:
200: CURSOR c_esc(b_task_id NUMBER) IS
201: SELECT DECODE(t.escalation_level, 'DE', 'N', 'NE', 'N', 'Y')
202: FROM jtf_tasks_b t
203: , jtf_task_statuses_b s
204: WHERE t.task_id = b_task_id
205: AND t.task_type_id = 22
206: AND s.task_status_id = t.task_status_id
207: AND NVL(s.closed_flag, 'N') <> 'Y'

Line 321: , jtf_task_statuses_b sb

317: FROM jtf_task_assignments a
318: , jtf_tasks_b tb
319: , jtf_task_types_tl tt
320: , jtf_tasks_tl tl
321: , jtf_task_statuses_b sb
322: , jtf_task_statuses_tl sl
323: , hz_party_sites ps
324: , hz_locations hl
325: , hz_parties pi

Line 401: jtf_task_statuses_b js

397: IS
398: SELECT ja.task_id
399: FROM jtf_task_assignments ja ,
400: jtf_tasks_b jb ,
401: jtf_task_statuses_b js
402: WHERE ja.task_id = jb.task_id
403: AND js.task_status_id = jb.task_status_id
404: AND ja.object_capacity_id = l_capacity
405: AND ja.resource_id = p_resource_id

Line 1461: , jtf_task_statuses_b sb

1457: FROM jtf_task_assignments a
1458: , jtf_tasks_b tb
1459: , jtf_task_types_tl tt
1460: , jtf_tasks_tl tl
1461: , jtf_task_statuses_b sb
1462: , jtf_task_statuses_tl sl
1463: , hz_party_sites ps
1464: , hz_locations hl
1465: , hz_parties pi

Line 1540: jtf_task_statuses_b js

1536: IS
1537: SELECT ja.task_id
1538: FROM jtf_task_assignments ja ,
1539: jtf_tasks_b jb ,
1540: jtf_task_statuses_b js
1541: WHERE ja.task_id = jb.task_id
1542: AND js.task_status_id = jb.task_status_id
1543: AND ja.object_capacity_id = l_capacity
1544: AND ja.resource_id = p_resource_id

Line 2431: , jtf_task_statuses_b sb

2427: FROM jtf_task_assignments a
2428: , jtf_tasks_b tb
2429: , jtf_task_types_tl tt
2430: , jtf_tasks_tl tl
2431: , jtf_task_statuses_b sb
2432: , jtf_task_statuses_tl sl
2433: , hz_party_sites ps
2434: , hz_locations hl
2435: , hz_parties pi

Line 3158: , jtf_task_statuses_b sb

3154: FROM jtf_task_assignments a
3155: , jtf_tasks_b tb
3156: , jtf_task_types_tl tt
3157: , jtf_tasks_tl tl
3158: , jtf_task_statuses_b sb
3159: , jtf_task_statuses_tl sl
3160: , hz_party_sites ps
3161: , hz_locations hl
3162: , hz_parties pi

Line 5216: , jtf_task_statuses_b tsa

5212: ) res_info
5213: , jtf_task_assignments a
5214: , jtf_tasks_b t
5215: , jtf_task_types_b tt
5216: , jtf_task_statuses_b tsa
5217: , jtf_task_statuses_b tsb
5218: , cac_sr_object_capacity csr
5219: WHERE t.task_id = a.task_id
5220: AND t.task_type_id = tt.task_type_id

Line 5217: , jtf_task_statuses_b tsb

5213: , jtf_task_assignments a
5214: , jtf_tasks_b t
5215: , jtf_task_types_b tt
5216: , jtf_task_statuses_b tsa
5217: , jtf_task_statuses_b tsb
5218: , cac_sr_object_capacity csr
5219: WHERE t.task_id = a.task_id
5220: AND t.task_type_id = tt.task_type_id
5221: AND (t.task_type_id = 20 OR t.task_type_id = 21)

Line 5331: , jtf_task_statuses_b tsb

5327: , jtf_tasks_tl tl
5328: , jtf_task_types_b tt
5329: , jtf_task_priorities_B jtp
5330: , jtf_task_priorities_tl jtpl
5331: , jtf_task_statuses_b tsb
5332: , jtf_task_statuses_b tsa
5333: , hz_parties pi
5334: , hz_party_sites ps
5335: , hz_locations l

Line 5332: , jtf_task_statuses_b tsa

5328: , jtf_task_types_b tt
5329: , jtf_task_priorities_B jtp
5330: , jtf_task_priorities_tl jtpl
5331: , jtf_task_statuses_b tsb
5332: , jtf_task_statuses_b tsa
5333: , hz_parties pi
5334: , hz_party_sites ps
5335: , hz_locations l
5336: , csf_access_hours_b ca

Line 5425: , jtf_task_statuses_b tsb

5421: , jtf_tasks_tl tl
5422: , jtf_task_types_b tt
5423: , jtf_task_priorities_B jtp
5424: , jtf_task_priorities_tl jtpl
5425: , jtf_task_statuses_b tsb
5426: , jtf_task_statuses_b tsa
5427: , hz_parties pi
5428: , hz_party_sites ps
5429: , hz_locations l

Line 5426: , jtf_task_statuses_b tsa

5422: , jtf_task_types_b tt
5423: , jtf_task_priorities_B jtp
5424: , jtf_task_priorities_tl jtpl
5425: , jtf_task_statuses_b tsb
5426: , jtf_task_statuses_b tsa
5427: , hz_parties pi
5428: , hz_party_sites ps
5429: , hz_locations l
5430: , csf_access_hours_b ca

Line 5510: , jtf_task_statuses_b tsb

5506: ) res_info
5507: , jtf_task_assignments a
5508: , jtf_tasks_b t
5509: , jtf_task_types_b tt
5510: , jtf_task_statuses_b tsb
5511: , jtf_task_statuses_b tsa
5512: , csf_access_hours_b ca
5513: , csp_requirement_headers cr
5514: WHERE t.task_id = a.task_id

Line 5511: , jtf_task_statuses_b tsa

5507: , jtf_task_assignments a
5508: , jtf_tasks_b t
5509: , jtf_task_types_b tt
5510: , jtf_task_statuses_b tsb
5511: , jtf_task_statuses_b tsa
5512: , csf_access_hours_b ca
5513: , csp_requirement_headers cr
5514: WHERE t.task_id = a.task_id
5515: AND t.source_object_type_code in( 'SR','TASK')

Line 5583: , jtf_task_statuses_b tsb

5579: ) res_info
5580: , jtf_task_assignments a
5581: , jtf_tasks_b t
5582: , jtf_task_types_b tt
5583: , jtf_task_statuses_b tsb
5584: , jtf_task_statuses_b tsa
5585: , csf_access_hours_b ca
5586: , jtf_task_depends jd
5587: , jtf_task_depends jdd

Line 5584: , jtf_task_statuses_b tsa

5580: , jtf_task_assignments a
5581: , jtf_tasks_b t
5582: , jtf_task_types_b tt
5583: , jtf_task_statuses_b tsb
5584: , jtf_task_statuses_b tsa
5585: , csf_access_hours_b ca
5586: , jtf_task_depends jd
5587: , jtf_task_depends jdd
5588: , csp_requirement_headers cr

Line 6787: , jtf_task_statuses_b tsa

6783: , hz_party_sites ps
6784: , hz_locations l
6785: , csf_access_hours_b ca
6786: , csp_requirement_headers cr
6787: , jtf_task_statuses_b tsa
6788: , jtf_task_statuses_b tsb
6789: WHERE cpv.sched_request_id = p_req_id
6790: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
6791: AND t.task_type_id = tt.task_type_id

Line 6788: , jtf_task_statuses_b tsb

6784: , hz_locations l
6785: , csf_access_hours_b ca
6786: , csp_requirement_headers cr
6787: , jtf_task_statuses_b tsa
6788: , jtf_task_statuses_b tsb
6789: WHERE cpv.sched_request_id = p_req_id
6790: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
6791: AND t.task_type_id = tt.task_type_id
6792: AND tl.task_id =t.task_id

Line 6869: , jtf_task_statuses_b tsa

6865: , csf_access_hours_b ca
6866: , csp_requirement_headers cr
6867: , jtf_task_depends jd
6868: , jtf_task_depends jdd
6869: , jtf_task_statuses_b tsa
6870: , jtf_task_statuses_b tsb
6871: WHERE cpv.sched_request_id = p_req_id
6872: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
6873: AND t.task_type_id = tt.task_type_id

Line 6870: , jtf_task_statuses_b tsb

6866: , csp_requirement_headers cr
6867: , jtf_task_depends jd
6868: , jtf_task_depends jdd
6869: , jtf_task_statuses_b tsa
6870: , jtf_task_statuses_b tsb
6871: WHERE cpv.sched_request_id = p_req_id
6872: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
6873: AND t.task_type_id = tt.task_type_id
6874: AND tl.task_id =t.task_id

Line 6939: , jtf_task_statuses_b tsa

6935: , jtf_task_assignments a
6936: , jtf_tasks_b t
6937: , csf_access_hours_b ca
6938: , csp_requirement_headers cr
6939: , jtf_task_statuses_b tsa
6940: , jtf_task_statuses_b tsb
6941: WHERE cpv.sched_request_id = p_req_id
6942: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
6943: AND cpv.start_time >= p_start_date

Line 6940: , jtf_task_statuses_b tsb

6936: , jtf_tasks_b t
6937: , csf_access_hours_b ca
6938: , csp_requirement_headers cr
6939: , jtf_task_statuses_b tsa
6940: , jtf_task_statuses_b tsb
6941: WHERE cpv.sched_request_id = p_req_id
6942: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
6943: AND cpv.start_time >= p_start_date
6944: AND cpv.end_time <= p_end_date

Line 6996: , jtf_task_statuses_b tsa

6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd
6996: , jtf_task_statuses_b tsa
6997: , jtf_task_statuses_b tsb
6998: WHERE cpv.sched_request_id = p_req_id
6999: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
7000: AND cpv.start_time >= p_start_date

Line 6997: , jtf_task_statuses_b tsb

6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd
6996: , jtf_task_statuses_b tsa
6997: , jtf_task_statuses_b tsb
6998: WHERE cpv.sched_request_id = p_req_id
6999: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)
7000: AND cpv.start_time >= p_start_date
7001: AND cpv.end_time <= p_end_date

Line 7101: , jtf_task_statuses_b tsb

7097: , jtf_task_types_b tt
7098: , jtf_tasks_tl tl
7099: , jtf_task_priorities_B jtp
7100: , jtf_task_priorities_tl jtpl
7101: , jtf_task_statuses_b tsb
7102: , jtf_task_statuses_b tsa
7103: , hz_parties pi
7104: , hz_party_sites ps
7105: , hz_locations l

Line 7102: , jtf_task_statuses_b tsa

7098: , jtf_tasks_tl tl
7099: , jtf_task_priorities_B jtp
7100: , jtf_task_priorities_tl jtpl
7101: , jtf_task_statuses_b tsb
7102: , jtf_task_statuses_b tsa
7103: , hz_parties pi
7104: , hz_party_sites ps
7105: , hz_locations l
7106: , csf_access_hours_b ca

Line 7200: , jtf_task_statuses_b tsb

7196: , jtf_tasks_tl tl
7197: , jtf_task_types_b tt
7198: , jtf_task_priorities_B jtp
7199: , jtf_task_priorities_tl jtpl
7200: , jtf_task_statuses_b tsb
7201: , jtf_task_statuses_b tsa
7202: , hz_parties pi
7203: , hz_party_sites ps
7204: , hz_locations l

Line 7201: , jtf_task_statuses_b tsa

7197: , jtf_task_types_b tt
7198: , jtf_task_priorities_B jtp
7199: , jtf_task_priorities_tl jtpl
7200: , jtf_task_statuses_b tsb
7201: , jtf_task_statuses_b tsa
7202: , hz_parties pi
7203: , hz_party_sites ps
7204: , hz_locations l
7205: , csf_access_hours_b ca

Line 7291: , jtf_task_statuses_b tsb

7287: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7288: , jtf_task_assignments a
7289: , jtf_tasks_b t
7290: , jtf_task_types_b tt
7291: , jtf_task_statuses_b tsb
7292: , jtf_task_statuses_b tsa
7293: , csf_access_hours_b ca
7294: , csp_requirement_headers cr
7295: WHERE t.task_id = a.task_id

Line 7292: , jtf_task_statuses_b tsa

7288: , jtf_task_assignments a
7289: , jtf_tasks_b t
7290: , jtf_task_types_b tt
7291: , jtf_task_statuses_b tsb
7292: , jtf_task_statuses_b tsa
7293: , csf_access_hours_b ca
7294: , csp_requirement_headers cr
7295: WHERE t.task_id = a.task_id
7296: AND t.source_object_type_code in( 'SR','TASK')

Line 7369: , jtf_task_statuses_b tsb

7365: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7366: , jtf_task_assignments a
7367: , jtf_tasks_b t
7368: , jtf_task_types_b tt
7369: , jtf_task_statuses_b tsb
7370: , jtf_task_statuses_b tsa
7371: , csf_access_hours_b ca
7372: , jtf_task_depends jd
7373: , jtf_task_depends jdd

Line 7370: , jtf_task_statuses_b tsa

7366: , jtf_task_assignments a
7367: , jtf_tasks_b t
7368: , jtf_task_types_b tt
7369: , jtf_task_statuses_b tsb
7370: , jtf_task_statuses_b tsa
7371: , csf_access_hours_b ca
7372: , jtf_task_depends jd
7373: , jtf_task_depends jdd
7374: , csp_requirement_headers cr