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 HZ_PARTIES

Line 270: , hz_parties pi

266: , jtf_task_statuses_b sb
267: , jtf_task_statuses_tl sl
268: , hz_party_sites ps
269: , hz_locations hl
270: , hz_parties pi
271: , fnd_timezones_b tz
272: WHERE a.task_id = p_task_id
273: AND resource_id = p_resource_id
274: AND resource_type_code = p_resource_type

Line 855: , hz_parties pi

851: , jtf_task_statuses_b sb
852: , jtf_task_statuses_tl sl
853: , hz_party_sites ps
854: , hz_locations hl
855: , hz_parties pi
856: , fnd_timezones_b tz
857: WHERE a.task_id = p_task_id
858: AND resource_id = p_resource_id
859: AND resource_type_code = p_resource_type

Line 2508: --Cursor C1 introduced when show labels on taskbar is true i.e join for hz_parties for showing

2504: FROM csf_gnticons_setup_v
2505: WHERE seq_id = 6;
2506:
2507: ---------------------------------------------------------------------------------------------
2508: --Cursor C1 introduced when show labels on taskbar is true i.e join for hz_parties for showing
2509: --party name on taskbar and this cursor is without task dependenciea join.
2510: ---------------------------------------------------------------------------------------------
2511:
2512: CURSOR c1

Line 2561: , hz_parties pi

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
2562: , csf_access_hours_b ca
2563: , csp_requirement_headers cr
2564: WHERE t.task_id = a.task_id
2565: AND t.source_object_type_code in( 'SR','TASK')

Line 2586: -- this cursor also has hz_parties join for party name to be shown on task bar

2582: AND booking_end_date >= booking_start_date;
2583:
2584: ---------------------------------------------------------------------------------------------
2585: --Cursor C3 introduced if task_dependency is set to active in scheduling chart icon setup form
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)

Line 2638: , hz_parties pi

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
2639: , csf_access_hours_b ca
2640: , jtf_task_depends jd
2641: , jtf_task_depends jdd
2642: , csp_requirement_headers cr

Line 2665: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties

2661: AND pi.party_id(+) = t.customer_id
2662: AND cr.task_id(+) = t.task_id
2663: AND booking_end_date >= booking_start_date;
2664: ---------------------------------------------------------------------------------------------
2665: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)

Line 2666: -- the diffrence between c1 and c2 join for hz_parties

2662: AND cr.task_id(+) = t.task_id
2663: AND booking_end_date >= booking_start_date;
2664: ---------------------------------------------------------------------------------------------
2665: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)

Line 2738: -- this cursor does not have hz_parties join like c2 but has dependencies join

2734: AND cr.task_id(+) = t.task_id
2735: AND booking_end_date >= booking_start_date;
2736: ---------------------------------------------------------------------------------------------
2737: --Cursor C4 introduced if task_dependency is set to active in scheduling chart icon setup form
2738: -- this cursor does not have hz_parties join like c2 but has dependencies join
2739: ---------------------------------------------------------------------------------------------
2740: CURSOR C4
2741: IS
2742: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)

Line 3745: --Cursor c_real_task_1 introduced when show labels on taskbar is true i.e join for hz_parties for showing

3741: AND ca.start_date_time >= p_start_date -1
3742: AND ca.end_date_time <= p_end_date;
3743:
3744: ---------------------------------------------------------------------------------------------
3745: --Cursor c_real_task_1 introduced when show labels on taskbar is true i.e join for hz_parties for showing
3746: --party name on taskbar and this cursor is without task dependencies join.
3747: ---------------------------------------------------------------------------------------------
3748: CURSOR c_real_task_1 IS
3749: SELECT

Line 3780: , hz_parties pi

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

Line 3802: -- this cursor also has hz_parties join for party name to be shown on task bar

3798: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
3799:
3800: ---------------------------------------------------------------------------------------------
3801: --Cursor c_real_task_3 introduced if task_dependency is set to active in scheduling chart icon setup form
3802: -- this cursor also has hz_parties join for party name to be shown on task bar
3803: ---------------------------------------------------------------------------------------------
3804: CURSOR c_real_task_3 IS
3805: SELECT
3806: cpv.task_id || '-' || cpv.plan_option_id real_task_key

Line 3837: , hz_parties pi

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

Line 3862: --Cursor c_real_task_2 introduced when show labels on taskbar is false i.e remove join for hz_parties

3858: AND NVL(tsa.cancelled_flag, 'N') <> 'Y'
3859: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
3860:
3861: ---------------------------------------------------------------------------------------------
3862: --Cursor c_real_task_2 introduced when show labels on taskbar is false i.e remove join for hz_parties
3863: -- the diffrence between c1 and c2 join for hz_parties
3864: ---------------------------------------------------------------------------------------------
3865: CURSOR c_real_task_2 IS
3866: SELECT

Line 3863: -- the diffrence between c1 and c2 join for hz_parties

3859: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
3860:
3861: ---------------------------------------------------------------------------------------------
3862: --Cursor c_real_task_2 introduced when show labels on taskbar is false i.e remove join for hz_parties
3863: -- the diffrence between c1 and c2 join for hz_parties
3864: ---------------------------------------------------------------------------------------------
3865: CURSOR c_real_task_2 IS
3866: SELECT
3867: cpv.task_id || '-' || cpv.plan_option_id real_task_key

Line 3917: -- this cursor does not have hz_parties join like c2 but has dependencies join

3913: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
3914:
3915: ---------------------------------------------------------------------------------------------
3916: --Cursor c_real_task_4 introduced if task_dependency is set to active in scheduling chart icon setup form
3917: -- this cursor does not have hz_parties join like c2 but has dependencies join
3918: ---------------------------------------------------------------------------------------------
3919: CURSOR c_real_task_4 IS
3920: SELECT
3921: cpv.task_id || '-' || cpv.plan_option_id real_task_key

Line 3996: --Cursor C1 introduced when show labels on taskbar is true i.e join for hz_parties for showing

3992: AND end_time <= p_end_date
3993: AND (task_id = -1 OR task_id = p_task_id);
3994:
3995: ---------------------------------------------------------------------------------------------
3996: --Cursor C1 introduced when show labels on taskbar is true i.e join for hz_parties for showing
3997: --party name on taskbar and this cursor is without task dependenciea join.
3998: ---------------------------------------------------------------------------------------------
3999:
4000: CURSOR c1

Line 4053: , hz_parties pi

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
4054: , csf_access_hours_b ca
4055: , csp_requirement_headers cr
4056: WHERE t.task_id = a.task_id
4057: AND t.source_object_type_code in( 'SR','TASK')

Line 4079: -- this cursor also has hz_parties join for party name to be shown on task bar

4075: AND a.object_capacity_id <>res_info.object_capacity_id;
4076:
4077: ---------------------------------------------------------------------------------------------
4078: --Cursor C3 introduced if task_dependency is set to active in scheduling chart icon setup form
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)

Line 4135: , hz_parties pi

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
4136: , csf_access_hours_b ca
4137: , jtf_task_depends jd
4138: , jtf_task_depends jdd
4139: , csp_requirement_headers cr

Line 4163: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties

4159: AND cr.task_id(+) = t.task_id
4160: AND booking_end_date >= booking_start_date
4161: AND a.object_capacity_id <>res_info.object_capacity_id;
4162: ---------------------------------------------------------------------------------------------
4163: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)

Line 4164: -- the diffrence between c1 and c2 join for hz_parties

4160: AND booking_end_date >= booking_start_date
4161: AND a.object_capacity_id <>res_info.object_capacity_id;
4162: ---------------------------------------------------------------------------------------------
4163: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)

Line 4241: -- this cursor does not have hz_parties join like c2 but has dependencies join

4237: AND booking_end_date >= booking_start_date
4238: AND a.object_capacity_id <>res_info.object_capacity_id;
4239: ---------------------------------------------------------------------------------------------
4240: --Cursor C4 introduced if task_dependency is set to active in scheduling chart icon setup form
4241: -- this cursor does not have hz_parties join like c2 but has dependencies join
4242: ---------------------------------------------------------------------------------------------
4243: CURSOR C4
4244: IS
4245: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)