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 235: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

231:
232: CURSOR c_task IS
233: SELECT /*+ ORDERED use_nl (a tb tt tl sb sl pi ps hl ft)
234: INDEX (t,JTF_TASKS_B_U3)
235: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
236: tb.task_id
237: , tl.task_name
238: , tb.task_number
239: , tb.source_object_type_code

Line 262: FROM jtf_task_assignments a

258: , a.actual_travel_duration
259: , a.actual_travel_duration_uom
260: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
261: , tz.ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
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

Line 820: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

816: -- task and task assignment data
817: CURSOR c_task IS
818: SELECT /*+ ORDERED use_nl (a tb tt tl sb sl pi ps hl ft)
819: INDEX (t,JTF_TASKS_B_U3)
820: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
821: tb.task_id
822: , tl.task_name
823: , tb.task_number
824: , tb.source_object_type_code

Line 847: FROM jtf_task_assignments a

843: , a.actual_travel_duration
844: , a.actual_travel_duration_uom
845: , tz.ACTIVE_TIMEZONE_CODE ic_tz_code
846: , tz.ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
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

Line 2029: FROM JTF_TASK_ASSIGNMENTS

2025: CURSOR c_assign_obj_ver IS
2026: SELECT object_version_number
2027: , actual_start_date
2028: , actual_end_date
2029: FROM JTF_TASK_ASSIGNMENTS
2030: WHERE task_id= p_task_id
2031: AND task_assignment_id =p_task_assignment_id;
2032:
2033: CURSOR c_parent_ovn(p_task_id number) IS

Line 2434: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

2430: CURSOR C_Virtual_Tasks
2431: IS
2432: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb)
2433: INDEX (t,JTF_TASKS_B_U3)
2434: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
2435: a.task_id || '-' || a.task_assignment_id
2436: , scheduled_start_date
2437: , scheduled_end_date
2438: , 0 color

Line 2469: , jtf_task_assignments a

2465: ,LENGTH(column_value)
2466: ) resource_type
2467: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 2516: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

2512: CURSOR c1
2513: IS
2514: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb pi ca cr)
2515: INDEX (t,JTF_TASKS_B_U3)
2516: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
2517: a.task_id || '-' || a.task_assignment_id
2518: , scheduled_start_date
2519: , scheduled_end_date
2520: , 0 color

Line 2556: , jtf_task_assignments a

2552: , LENGTH(column_value)
2553: ) resource_type
2554: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 2591: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

2587: ---------------------------------------------------------------------------------------------
2588: CURSOR c3 IS
2589: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb pi ca jd jdd cr)
2590: INDEX (t,JTF_TASKS_B_U3)
2591: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
2592: DISTINCT
2593: a.task_id || '-' || a.task_assignment_id
2594: , scheduled_start_date
2595: , scheduled_end_date

Line 2633: , jtf_task_assignments a

2629: , LENGTH(column_value)
2630: ) resource_type
2631: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 2671: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

2667: ---------------------------------------------------------------------------------------------
2668: CURSOR c2 IS
2669: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca cr)
2670: INDEX (t,JTF_TASKS_B_U3)
2671: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
2672: a.task_id || '-' || a.task_assignment_id
2673: , scheduled_start_date
2674: , scheduled_end_date
2675: , 0 color

Line 2711: , jtf_task_assignments a

2707: , LENGTH(column_value)
2708: ) resource_type
2709: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 2744: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

2740: CURSOR C4
2741: IS
2742: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)
2743: INDEX (t,JTF_TASKS_B_U3)
2744: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
2745: DISTINCT
2746: a.task_id || '-' || a.task_assignment_id
2747: , scheduled_start_date
2748: , scheduled_end_date

Line 2786: , jtf_task_assignments a

2782: , LENGTH(column_value)
2783: ) resource_type
2784: FROM TABLE(CAST(p_res_key AS jtf_varchar2_table_2000))
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

Line 3778: , jtf_task_assignments a

3774: , 'N' task_dep
3775: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
3776: , NVL(child_position, 'N') child_task
3777: FROM csf_plan_options_v cpv
3778: , jtf_task_assignments a
3779: , jtf_tasks_b t
3780: , hz_parties pi
3781: , csf_access_hours_b ca
3782: , csp_requirement_headers cr

Line 3835: , jtf_task_assignments a

3831: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
3832: , NVL(child_position, 'N') child_task
3833: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
3834: FROM csf_plan_options_v cpv
3835: , jtf_task_assignments a
3836: , jtf_tasks_b t
3837: , hz_parties pi
3838: , csf_access_hours_b ca
3839: , csp_requirement_headers cr

Line 3895: , jtf_task_assignments a

3891: , 'N' task_dep
3892: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
3893: , NVL(child_position, 'N') child_task
3894: FROM csf_plan_options_v cpv
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

Line 3950: , jtf_task_assignments a

3946: , DECODE(cr.task_id, t.task_id, 'Y', 'N') parts_req
3947: , NVL(child_position, 'N') child_task
3948: , NVL(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
3949: FROM csf_plan_options_v cpv
3950: , jtf_task_assignments a
3951: , jtf_tasks_b t
3952: , csf_access_hours_b ca
3953: , csp_requirement_headers cr
3954: , jtf_task_depends jd

Line 4004: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

4000: CURSOR c1
4001: IS
4002: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb pi ca cr)
4003: INDEX (t,JTF_TASKS_B_U3)
4004: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
4005: a.task_id || '-'|| plan_option_id
4006: , scheduled_start_date
4007: , scheduled_end_date
4008: , 0 color

Line 4048: , jtf_task_assignments a

4044: AND POP.plan_option_id = pt.plan_option_id
4045: AND pt.task_id = t.task_id(+)
4046: AND rt.sched_request_id = p_req_id
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

Line 4084: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

4080: ---------------------------------------------------------------------------------------------
4081: CURSOR c3 IS
4082: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb pi ca jd jdd cr)
4083: INDEX (t,JTF_TASKS_B_U3)
4084: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
4085: DISTINCT
4086: a.task_id || '-'|| plan_option_id
4087: , scheduled_start_date
4088: , scheduled_end_date

Line 4130: , jtf_task_assignments a

4126: AND POP.plan_option_id = pt.plan_option_id
4127: AND pt.task_id = t.task_id(+)
4128: AND rt.sched_request_id = p_req_id
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

Line 4169: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

4165: ---------------------------------------------------------------------------------------------
4166: CURSOR c2 IS
4167: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca cr)
4168: INDEX (t,JTF_TASKS_B_U3)
4169: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
4170: a.task_id || '-'|| plan_option_id
4171: , scheduled_start_date
4172: , scheduled_end_date
4173: , 0 color

Line 4213: , jtf_task_assignments a

4209: AND POP.plan_option_id = pt.plan_option_id
4210: AND pt.task_id = t.task_id(+)
4211: AND rt.sched_request_id = p_req_id
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

Line 4247: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */

4243: CURSOR C4
4244: IS
4245: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)
4246: INDEX (t,JTF_TASKS_B_U3)
4247: INDEX (a,JTF_TASK_ASSIGNMENTS_N1) */
4248: DISTINCT
4249: a.task_id || '-'|| plan_option_id
4250: , scheduled_start_date
4251: , scheduled_end_date

Line 4293: , jtf_task_assignments a

4289: AND POP.plan_option_id = pt.plan_option_id
4290: AND pt.task_id = t.task_id(+)
4291: AND rt.sched_request_id = p_req_id
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