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_ASSIGNMENTS

Line 288: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
292: , tb.source_object_type_code

Line 317: FROM jtf_task_assignments a

313: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
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

Line 388: FROM jtf_task_assignments ja

384:
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)

Line 399: FROM jtf_task_assignments ja ,

395:
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

Line 420: FROM jtf_task_assignments ja ,

416: , ja.actual_travel_duration
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;

Line 1428: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
1432: , tb.source_object_type_code

Line 1457: FROM jtf_task_assignments a

1453: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
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

Line 1527: FROM jtf_task_assignments ja

1523:
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)

Line 1538: FROM jtf_task_assignments ja ,

1534:
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

Line 1559: FROM jtf_task_assignments ja ,

1555: , ja.actual_travel_duration
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;

Line 2398: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
2402: , tb.source_object_type_code

Line 2427: FROM jtf_task_assignments a

2423: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
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

Line 3125: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
3129: , tb.source_object_type_code

Line 3154: FROM jtf_task_assignments a

3150: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
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

Line 4618: FROM JTF_TASK_ASSIGNMENTS

4614: CURSOR c_assign_obj_ver IS
4615: SELECT object_version_number
4616: , actual_start_date
4617: , actual_end_date
4618: FROM JTF_TASK_ASSIGNMENTS
4619: WHERE task_id= p_task_id
4620: AND task_assignment_id =p_task_assignment_id;
4621:
4622: CURSOR c_parent_ovn(p_task_id number) IS

Line 5177: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
5181: , 0 color

Line 5213: , jtf_task_assignments a

5209: ,LENGTH(column_value)
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

Line 5277: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
5281: , tl.task_name

Line 5325: , jtf_task_assignments a

5321: , LENGTH(column_value)
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

Line 5370: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
5374: , tl.task_name

Line 5419: , jtf_task_assignments a

5415: , LENGTH(column_value)
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

Line 5467: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
5471: , 0 color

Line 5507: , jtf_task_assignments a

5503: , LENGTH(column_value)
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

Line 5538: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
5542: , scheduled_end_date

Line 5580: , jtf_task_assignments a

5576: , LENGTH(column_value)
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

Line 6776: , jtf_task_assignments a

6772: , 'N' task_dep
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

Line 6856: , jtf_task_assignments a

6852: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
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

Line 6935: , jtf_task_assignments a

6931: , 'N' task_dep
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

Line 6990: , jtf_task_assignments a

6986: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
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

Line 7044: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
7048: , jtpl.name

Line 7095: , jtf_task_assignments a

7091: AND POP.plan_option_id = pt.plan_option_id
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

Line 7141: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
7145: , tl.task_name

Line 7194: , jtf_task_assignments a

7190: AND POP.plan_option_id = pt.plan_option_id
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

Line 7244: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
7248: , 0 color

Line 7288: , jtf_task_assignments a

7284: AND POP.plan_option_id = pt.plan_option_id
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

Line 7320: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

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
7324: , scheduled_end_date

Line 7366: , jtf_task_assignments a

7362: AND POP.plan_option_id = pt.plan_option_id
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