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 149: FROM jtf_tasks_b t

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

Line 234: INDEX (t,JTF_TASKS_B_U3)

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

Line 263: , jtf_tasks_b tb

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
267: , jtf_task_statuses_tl sl

Line 819: INDEX (t,JTF_TASKS_B_U3)

815: RETURN VARCHAR2 IS
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

Line 848: , jtf_tasks_b tb

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
852: , jtf_task_statuses_tl sl

Line 2022: FROM jtf_tasks_b

2018: , task_status_id
2019: , scheduled_start_date
2020: , scheduled_end_date
2021: , parent_task_id
2022: FROM jtf_tasks_b
2023: WHERE task_id = p_task_id;
2024:
2025: CURSOR c_assign_obj_ver IS
2026: SELECT object_version_number

Line 2035: FROM jtf_tasks_b

2031: AND task_assignment_id =p_task_assignment_id;
2032:
2033: CURSOR c_parent_ovn(p_task_id number) IS
2034: SELECT object_version_number
2035: FROM jtf_tasks_b
2036: WHERE task_id = p_task_id;
2037:
2038: BEGIN
2039: -- Standard start of API savepoint

Line 2433: INDEX (t,JTF_TASKS_B_U3)

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

Line 2470: , jtf_tasks_b t

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
2474: WHERE t.task_id = a.task_id

Line 2515: INDEX (t,JTF_TASKS_B_U3)

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

Line 2557: , jtf_tasks_b t

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
2561: , hz_parties pi

Line 2590: INDEX (t,JTF_TASKS_B_U3)

2586: -- this cursor also has hz_parties join for party name to be shown on task bar
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

Line 2634: , jtf_tasks_b t

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
2638: , hz_parties pi

Line 2670: INDEX (t,JTF_TASKS_B_U3)

2666: -- the diffrence between c1 and c2 join for hz_parties
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

Line 2712: , jtf_tasks_b t

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
2716: , csf_access_hours_b ca

Line 2743: INDEX (t,JTF_TASKS_B_U3)

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

Line 2787: , jtf_tasks_b t

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
2791: , csf_access_hours_b ca

Line 3779: , jtf_tasks_b t

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
3783: , jtf_task_statuses_b tsa

Line 3836: , jtf_tasks_b t

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
3840: , jtf_task_depends jd

Line 3896: , jtf_tasks_b t

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
3900: , jtf_task_statuses_b tsb

Line 3951: , jtf_tasks_b t

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
3955: , jtf_task_depends jdd

Line 4003: INDEX (t,JTF_TASKS_B_U3)

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

Line 4041: jtf_tasks_b t

4037: FROM csf_r_request_tasks rt,
4038: csf_r_resource_results rr,
4039: csf_r_plan_options pop,
4040: csf_r_plan_option_tasks pt,
4041: jtf_tasks_b t
4042: WHERE rt.request_task_id = rr.request_task_id
4043: AND rr.resource_result_id = POP.resource_result_id
4044: AND POP.plan_option_id = pt.plan_option_id
4045: AND pt.task_id = t.task_id(+)

Line 4049: , jtf_tasks_b t

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
4053: , hz_parties pi

Line 4083: INDEX (t,JTF_TASKS_B_U3)

4079: -- this cursor also has hz_parties join for party name to be shown on task bar
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

Line 4123: jtf_tasks_b t

4119: FROM csf_r_request_tasks rt,
4120: csf_r_resource_results rr,
4121: csf_r_plan_options pop,
4122: csf_r_plan_option_tasks pt,
4123: jtf_tasks_b t
4124: WHERE rt.request_task_id = rr.request_task_id
4125: AND rr.resource_result_id = POP.resource_result_id
4126: AND POP.plan_option_id = pt.plan_option_id
4127: AND pt.task_id = t.task_id(+)

Line 4131: , jtf_tasks_b t

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
4135: , hz_parties pi

Line 4168: INDEX (t,JTF_TASKS_B_U3)

4164: -- the diffrence between c1 and c2 join for hz_parties
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

Line 4206: jtf_tasks_b t

4202: FROM csf_r_request_tasks rt,
4203: csf_r_resource_results rr,
4204: csf_r_plan_options pop,
4205: csf_r_plan_option_tasks pt,
4206: jtf_tasks_b t
4207: WHERE rt.request_task_id = rr.request_task_id
4208: AND rr.resource_result_id = POP.resource_result_id
4209: AND POP.plan_option_id = pt.plan_option_id
4210: AND pt.task_id = t.task_id(+)

Line 4214: , jtf_tasks_b t

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
4218: , csf_access_hours_b ca

Line 4246: INDEX (t,JTF_TASKS_B_U3)

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

Line 4286: jtf_tasks_b t

4282: FROM csf_r_request_tasks rt,
4283: csf_r_resource_results rr,
4284: csf_r_plan_options pop,
4285: csf_r_plan_option_tasks pt,
4286: jtf_tasks_b t
4287: WHERE rt.request_task_id = rr.request_task_id
4288: AND rr.resource_result_id = POP.resource_result_id
4289: AND POP.plan_option_id = pt.plan_option_id
4290: AND pt.task_id = t.task_id(+)

Line 4294: , jtf_tasks_b t

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
4298: , csf_access_hours_b ca

Line 4481: ||' JTF_TASKS_B T'

4477: ||' CSF_R_REQUEST_TASKS RT,'
4478: ||' CSF_R_RESOURCE_RESULTS RR,'
4479: ||' CSF_R_PLAN_OPTIONS POP,'
4480: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4481: ||' JTF_TASKS_B T'
4482: ||' WHERE RT.SCHED_REQUEST_ID =:1'
4483: ||' AND (NVL(T.TASK_TYPE_ID,0) NOT IN (20,21))'
4484: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4485: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'

Line 4500: ||' JTF_TASKS_B T'

4496: ||' CSF_R_REQUEST_TASKS RT,'
4497: ||' CSF_R_RESOURCE_RESULTS RR,'
4498: ||' CSF_R_PLAN_OPTIONS POP,'
4499: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4500: ||' JTF_TASKS_B T'
4501: ||' WHERE RT.SCHED_REQUEST_ID =:1'
4502: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4503: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'
4504: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID'

Line 4515: ||' JTF_TASKS_B T'

4511: ||' CSF_R_REQUEST_TASKS RT,'
4512: ||' CSF_R_RESOURCE_RESULTS RR,'
4513: ||' CSF_R_PLAN_OPTIONS POP,'
4514: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4515: ||' JTF_TASKS_B T'
4516: ||' WHERE RT.SCHED_REQUEST_ID =:2'
4517: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4518: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'
4519: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID'

Line 4535: ||' JTF_TASKS_B T '

4531: ||' CSF_R_REQUEST_TASKS RT, '
4532: ||' CSF_R_RESOURCE_RESULTS RR, '
4533: ||' CSF_R_PLAN_OPTIONS POP, '
4534: ||' CSF_R_PLAN_OPTION_TASKS PT, '
4535: ||' JTF_TASKS_B T '
4536: ||' WHERE RT.SCHED_REQUEST_ID = :1 '
4537: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
4538: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '
4539: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID '

Line 4550: ||' JTF_TASKS_B T '

4546: ||' CSF_R_REQUEST_TASKS RT, '
4547: ||' CSF_R_RESOURCE_RESULTS RR, '
4548: ||' CSF_R_PLAN_OPTIONS POP, '
4549: ||' CSF_R_PLAN_OPTION_TASKS PT, '
4550: ||' JTF_TASKS_B T '
4551: ||' WHERE RT.SCHED_REQUEST_ID = :2 '
4552: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
4553: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '
4554: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID '

Line 4566: ||' JTF_TASKS_B T '

4562: ||' CSF_R_REQUEST_TASKS RT, '
4563: ||' CSF_R_RESOURCE_RESULTS RR, '
4564: ||' CSF_R_PLAN_OPTIONS POP, '
4565: ||' CSF_R_PLAN_OPTION_TASKS PT, '
4566: ||' JTF_TASKS_B T '
4567: ||' WHERE RT.SCHED_REQUEST_ID = :4 '
4568: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
4569: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '
4570: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID '

Line 4587: ||' JTF_TASKS_B T'

4583: ||' CSF_R_REQUEST_TASKS RT,'
4584: ||' CSF_R_RESOURCE_RESULTS RR,'
4585: ||' CSF_R_PLAN_OPTIONS POP,'
4586: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4587: ||' JTF_TASKS_B T'
4588: ||' WHERE RT.SCHED_REQUEST_ID =:1'
4589: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4590: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'
4591: ||' AND POP.PLAN_OPTION_ID = PT.PLAN_OPTION_ID'