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_TASKS_B

Line 202: FROM jtf_tasks_b t

198: AND r.object_id = p_task_id;
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

Line 287: INDEX (t,JTF_TASKS_B_U3)

283:
284:
285: CURSOR c_task IS
286: SELECT /*+ ORDERED use_nl (a tb tt tl sb sl pi ps hl ft)
287: INDEX (t,JTF_TASKS_B_U3)
288: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
289: tb.task_id
290: , tl.task_name
291: , tb.task_number

Line 318: , jtf_tasks_b tb

314: , tz.ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
315: , tb.planned_effort ||' '|| tb.planned_effort_uom plan_effort
316: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
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

Line 389: , jtf_tasks_b jb

385: Cursor c_trip
386: IS
387: SELECT object_capacity_id
388: FROM jtf_task_assignments ja
389: , jtf_tasks_b jb
390: WHERE ja.task_id = jb.task_id
391: AND ja.task_id = p_task_id
392: AND jb.task_type_id not in (20,21)
393: AND ja.object_capacity_id is not null

Line 400: jtf_tasks_b jb ,

396: Cursor c_tasks(l_capacity number)
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

Line 421: jtf_tasks_b jb

417: , ja.sched_travel_duration
418: , ja.actual_travel_duration_uom
419: , ja.sched_travel_duration_uom
420: FROM jtf_task_assignments ja ,
421: jtf_tasks_b jb
422: WHERE ja.task_id = jb.task_id
423: AND jb.task_type_id IN (21)
424: AND ja.task_id= p_task_id;
425:

Line 1427: INDEX (t,JTF_TASKS_B_U3)

1423:
1424: -- task and task assignment data
1425: CURSOR c_task IS
1426: SELECT /*+ ORDERED use_nl (a tb tt tl sb sl pi ps hl ft)
1427: INDEX (t,JTF_TASKS_B_U3)
1428: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
1429: tb.task_id
1430: , tl.task_name
1431: , tb.task_number

Line 1458: , jtf_tasks_b tb

1454: , tz.ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
1455: , tb.planned_effort ||' '|| tb.planned_effort_uom plan_effort
1456: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
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

Line 1528: , jtf_tasks_b jb

1524: Cursor c_trip
1525: IS
1526: SELECT object_capacity_id
1527: FROM jtf_task_assignments ja
1528: , jtf_tasks_b jb
1529: WHERE ja.task_id = jb.task_id
1530: AND ja.task_id = p_task_id
1531: AND jb.task_type_id not in (20,21)
1532: AND ja.object_capacity_id is not null

Line 1539: jtf_tasks_b jb ,

1535: Cursor c_tasks(l_capacity number)
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

Line 1560: jtf_tasks_b jb

1556: , ja.sched_travel_duration
1557: , ja.actual_travel_duration_uom
1558: , ja.sched_travel_duration_uom
1559: FROM jtf_task_assignments ja ,
1560: jtf_tasks_b jb
1561: WHERE ja.task_id = jb.task_id
1562: AND jb.task_type_id IN (21)
1563: AND ja.task_id= p_task_id;
1564:

Line 2397: INDEX (t,JTF_TASKS_B_U3)

2393: RETURN VARCHAR2 IS
2394: -- task and task assignment data
2395: CURSOR c_task IS
2396: SELECT /*+ ORDERED use_nl (a tb tt tl sb sl pi ps hl ft)
2397: INDEX (t,JTF_TASKS_B_U3)
2398: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
2399: tb.task_id
2400: , tl.task_name
2401: , tb.task_number

Line 2428: , jtf_tasks_b tb

2424: , tz.ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
2425: , tb.planned_effort ||' '|| tb.planned_effort_uom plan_effort
2426: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
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

Line 3124: INDEX (t,JTF_TASKS_B_U3)

3120:
3121: -- task and task assignment data
3122: CURSOR c_task IS
3123: SELECT /*+ ORDERED use_nl (a tb tt tl sb sl pi ps hl ft)
3124: INDEX (t,JTF_TASKS_B_U3)
3125: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
3126: tb.task_id
3127: , tl.task_name
3128: , tb.task_number

Line 3155: , jtf_tasks_b tb

3151: , tz.ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
3152: , tb.planned_effort ||' '|| tb.planned_effort_uom plan_effort
3153: , tb.actual_effort ||' '|| tb.actual_effort_uom act_effort
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

Line 4611: FROM jtf_tasks_b

4607: , task_status_id
4608: , scheduled_start_date
4609: , scheduled_end_date
4610: , parent_task_id
4611: FROM jtf_tasks_b
4612: WHERE task_id = p_task_id;
4613:
4614: CURSOR c_assign_obj_ver IS
4615: SELECT object_version_number

Line 4624: FROM jtf_tasks_b

4620: AND task_assignment_id =p_task_assignment_id;
4621:
4622: CURSOR c_parent_ovn(p_task_id number) IS
4623: SELECT object_version_number
4624: FROM jtf_tasks_b
4625: WHERE task_id = p_task_id;
4626: BEGIN
4627: -- Standard start of API savepoint
4628: SAVEPOINT drag_n_drop;

Line 5176: INDEX (t,JTF_TASKS_B_U3)

5172:
5173: CURSOR C_Virtual_Tasks
5174: IS
5175: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb)
5176: INDEX (t,JTF_TASKS_B_U3)
5177: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
5178: a.task_id || '-' || a.task_assignment_id
5179: , scheduled_start_date
5180: , scheduled_end_date

Line 5214: , jtf_tasks_b t

5210: ) resource_type
5211: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 5276: INDEX (t,JTF_TASKS_B_U3)

5272:
5273: CURSOR c1
5274: IS
5275: SELECT /*+ ORDERED use_nl (res_info a t tl tt jtp jtpl tsa tsb pi ps l ca cr)
5276: INDEX (t,JTF_TASKS_B_U3)
5277: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
5278: DISTINCT
5279: a.task_id || '-' || a.task_assignment_id
5280: , t.task_number

Line 5326: , jtf_tasks_B t

5322: ) resource_type
5323: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5324: ) res_info
5325: , jtf_task_assignments a
5326: , jtf_tasks_B t
5327: , jtf_tasks_tl tl
5328: , jtf_task_types_b tt
5329: , jtf_task_priorities_B jtp
5330: , jtf_task_priorities_tl jtpl

Line 5369: INDEX (t,JTF_TASKS_B_U3)

5365: -- this cursor also has hz_parties join for party name to be shown on task bar
5366: ---------------------------------------------------------------------------------------------
5367: CURSOR c3 IS
5368: SELECT /*+ ORDERED use_nl (res_info a t tt jtp jtpl tsa tsb pi ps l ca jd jdd cr)
5369: INDEX (t,JTF_TASKS_B_U3)
5370: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
5371: DISTINCT
5372: a.task_id || '-' || a.task_assignment_id
5373: , t.task_number

Line 5420: , jtf_tasks_b t

5416: ) resource_type
5417: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
5418: ) res_info
5419: , jtf_task_assignments a
5420: , jtf_tasks_b t
5421: , jtf_tasks_tl tl
5422: , jtf_task_types_b tt
5423: , jtf_task_priorities_B jtp
5424: , jtf_task_priorities_tl jtpl

Line 5466: INDEX (t,JTF_TASKS_B_U3)

5462: -- the diffrence between c1 and c2 join for hz_parties
5463: ---------------------------------------------------------------------------------------------
5464: CURSOR c2 IS
5465: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca cr)
5466: INDEX (t,JTF_TASKS_B_U3)
5467: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
5468: a.task_id || '-' || a.task_assignment_id
5469: , scheduled_start_date
5470: , scheduled_end_date

Line 5508: , jtf_tasks_b t

5504: ) resource_type
5505: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 5537: INDEX (t,JTF_TASKS_B_U3)

5533: ---------------------------------------------------------------------------------------------
5534: CURSOR C4
5535: IS
5536: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)
5537: INDEX (t,JTF_TASKS_B_U3)
5538: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
5539: DISTINCT
5540: a.task_id || '-' || a.task_assignment_id
5541: , scheduled_start_date

Line 5581: , jtf_tasks_b t

5577: ) resource_type
5578: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 6777: , jtf_tasks_b t

6773: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
6774: , NVL(child_position, 'N') child_task
6775: FROM csf_plan_options_v cpv
6776: , jtf_task_assignments a
6777: , jtf_tasks_b t
6778: , jtf_tasks_tl tl
6779: , jtf_task_types_b tt
6780: , jtf_task_priorities_B jtp
6781: , jtf_task_priorities_tl jtpl

Line 6857: , jtf_tasks_b t

6853: , NVL(child_position, 'N') child_task
6854: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
6855: FROM csf_plan_options_v cpv
6856: , jtf_task_assignments a
6857: , jtf_tasks_b t
6858: , jtf_tasks_tl tl
6859: , jtf_task_types_b tt
6860: , jtf_task_priorities_B jtp
6861: , jtf_task_priorities_tl jtpl

Line 6936: , jtf_tasks_b t

6932: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
6933: , NVL(child_position, 'N') child_task
6934: FROM csf_plan_options_v cpv
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

Line 6991: , jtf_tasks_b t

6987: , NVL(child_position, 'N') child_task
6988: , NVL(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
6989: FROM csf_plan_options_v cpv
6990: , jtf_task_assignments a
6991: , jtf_tasks_b t
6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd

Line 7043: INDEX (t,JTF_TASKS_B_U3)

7039:
7040: CURSOR c1
7041: IS
7042: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb pi ca cr)
7043: INDEX (t,JTF_TASKS_B_U3)
7044: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
7045: a.task_id || '-'|| plan_option_id
7046: , t.task_number
7047: , tl.task_name

Line 7088: jtf_tasks_b t

7084: FROM csf_r_request_tasks rt,
7085: csf_r_resource_results rr,
7086: csf_r_plan_options pop,
7087: csf_r_plan_option_tasks pt,
7088: jtf_tasks_b t
7089: WHERE rt.request_task_id = rr.request_task_id
7090: AND rr.resource_result_id = POP.resource_result_id
7091: AND POP.plan_option_id = pt.plan_option_id
7092: AND pt.task_id = t.task_id(+)

Line 7096: , jtf_tasks_b t

7092: AND pt.task_id = t.task_id(+)
7093: AND rt.sched_request_id = p_req_id
7094: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7095: , jtf_task_assignments a
7096: , jtf_tasks_b t
7097: , jtf_task_types_b tt
7098: , jtf_tasks_tl tl
7099: , jtf_task_priorities_B jtp
7100: , jtf_task_priorities_tl jtpl

Line 7140: INDEX (t,JTF_TASKS_B_U3)

7136: -- this cursor also has hz_parties join for party name to be shown on task bar
7137: ---------------------------------------------------------------------------------------------
7138: CURSOR c3 IS
7139: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb pi ca jd jdd cr)
7140: INDEX (t,JTF_TASKS_B_U3)
7141: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
7142: DISTINCT
7143: a.task_id || '-'|| plan_option_id
7144: , t.task_number

Line 7187: jtf_tasks_b t

7183: FROM csf_r_request_tasks rt,
7184: csf_r_resource_results rr,
7185: csf_r_plan_options pop,
7186: csf_r_plan_option_tasks pt,
7187: jtf_tasks_b t
7188: WHERE rt.request_task_id = rr.request_task_id
7189: AND rr.resource_result_id = POP.resource_result_id
7190: AND POP.plan_option_id = pt.plan_option_id
7191: AND pt.task_id = t.task_id(+)

Line 7195: , jtf_tasks_b t

7191: AND pt.task_id = t.task_id(+)
7192: AND rt.sched_request_id = p_req_id
7193: AND nvl(t.task_type_id, 0) not in(20, 21)) res_info
7194: , jtf_task_assignments a
7195: , jtf_tasks_b t
7196: , jtf_tasks_tl tl
7197: , jtf_task_types_b tt
7198: , jtf_task_priorities_B jtp
7199: , jtf_task_priorities_tl jtpl

Line 7243: INDEX (t,JTF_TASKS_B_U3)

7239: -- the diffrence between c1 and c2 join for hz_parties
7240: ---------------------------------------------------------------------------------------------
7241: CURSOR c2 IS
7242: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca cr)
7243: INDEX (t,JTF_TASKS_B_U3)
7244: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
7245: a.task_id || '-'|| plan_option_id
7246: , scheduled_start_date
7247: , scheduled_end_date

Line 7281: jtf_tasks_b t

7277: FROM csf_r_request_tasks rt,
7278: csf_r_resource_results rr,
7279: csf_r_plan_options pop,
7280: csf_r_plan_option_tasks pt,
7281: jtf_tasks_b t
7282: WHERE rt.request_task_id = rr.request_task_id
7283: AND rr.resource_result_id = POP.resource_result_id
7284: AND POP.plan_option_id = pt.plan_option_id
7285: AND pt.task_id = t.task_id(+)

Line 7289: , jtf_tasks_b t

7285: AND pt.task_id = t.task_id(+)
7286: AND rt.sched_request_id = p_req_id
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

Line 7319: INDEX (t,JTF_TASKS_B_U3)

7315: ---------------------------------------------------------------------------------------------
7316: CURSOR C4
7317: IS
7318: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)
7319: INDEX (t,JTF_TASKS_B_U3)
7320: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
7321: DISTINCT
7322: a.task_id || '-'|| plan_option_id
7323: , scheduled_start_date

Line 7359: jtf_tasks_b t

7355: FROM csf_r_request_tasks rt,
7356: csf_r_resource_results rr,
7357: csf_r_plan_options pop,
7358: csf_r_plan_option_tasks pt,
7359: jtf_tasks_b t
7360: WHERE rt.request_task_id = rr.request_task_id
7361: AND rr.resource_result_id = POP.resource_result_id
7362: AND POP.plan_option_id = pt.plan_option_id
7363: AND pt.task_id = t.task_id(+)

Line 7367: , jtf_tasks_b t

7363: AND pt.task_id = t.task_id(+)
7364: AND rt.sched_request_id = p_req_id
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

Line 7580: ||' JTF_TASKS_B T'

7576: ||' CSF_R_REQUEST_TASKS RT,'
7577: ||' CSF_R_RESOURCE_RESULTS RR,'
7578: ||' CSF_R_PLAN_OPTIONS POP,'
7579: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7580: ||' JTF_TASKS_B T'
7581: ||' WHERE RT.SCHED_REQUEST_ID =:1'
7582: ||' AND (NVL(T.TASK_TYPE_ID,0) NOT IN (20,21))'
7583: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
7584: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'

Line 7599: ||' JTF_TASKS_B T'

7595: ||' CSF_R_REQUEST_TASKS RT,'
7596: ||' CSF_R_RESOURCE_RESULTS RR,'
7597: ||' CSF_R_PLAN_OPTIONS POP,'
7598: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7599: ||' JTF_TASKS_B T'
7600: ||' WHERE RT.SCHED_REQUEST_ID =:1'
7601: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
7602: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'
7603: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID'

Line 7614: ||' JTF_TASKS_B T'

7610: ||' CSF_R_REQUEST_TASKS RT,'
7611: ||' CSF_R_RESOURCE_RESULTS RR,'
7612: ||' CSF_R_PLAN_OPTIONS POP,'
7613: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7614: ||' JTF_TASKS_B T'
7615: ||' WHERE RT.SCHED_REQUEST_ID =:2'
7616: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
7617: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'
7618: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID'

Line 7634: ||' JTF_TASKS_B T '

7630: ||' CSF_R_REQUEST_TASKS RT, '
7631: ||' CSF_R_RESOURCE_RESULTS RR, '
7632: ||' CSF_R_PLAN_OPTIONS POP, '
7633: ||' CSF_R_PLAN_OPTION_TASKS PT, '
7634: ||' JTF_TASKS_B T '
7635: ||' WHERE RT.SCHED_REQUEST_ID = :1 '
7636: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
7637: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '
7638: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID '

Line 7649: ||' JTF_TASKS_B T '

7645: ||' CSF_R_REQUEST_TASKS RT, '
7646: ||' CSF_R_RESOURCE_RESULTS RR, '
7647: ||' CSF_R_PLAN_OPTIONS POP, '
7648: ||' CSF_R_PLAN_OPTION_TASKS PT, '
7649: ||' JTF_TASKS_B T '
7650: ||' WHERE RT.SCHED_REQUEST_ID = :2 '
7651: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
7652: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '
7653: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID '

Line 7665: ||' JTF_TASKS_B T '

7661: ||' CSF_R_REQUEST_TASKS RT, '
7662: ||' CSF_R_RESOURCE_RESULTS RR, '
7663: ||' CSF_R_PLAN_OPTIONS POP, '
7664: ||' CSF_R_PLAN_OPTION_TASKS PT, '
7665: ||' JTF_TASKS_B T '
7666: ||' WHERE RT.SCHED_REQUEST_ID = :4 '
7667: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
7668: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '
7669: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID '

Line 7686: ||' JTF_TASKS_B T'

7682: ||' CSF_R_REQUEST_TASKS RT,'
7683: ||' CSF_R_RESOURCE_RESULTS RR,'
7684: ||' CSF_R_PLAN_OPTIONS POP,'
7685: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7686: ||' JTF_TASKS_B T'
7687: ||' WHERE RT.SCHED_REQUEST_ID =:1'
7688: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
7689: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'
7690: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID'