[Home] [Help]
321: , jtf_task_statuses_b sb
322: , jtf_task_statuses_tl sl
323: , hz_party_sites ps
324: , hz_locations hl
325: , hz_parties pi
326: , fnd_timezones_b tz
327: WHERE a.task_id = p_task_id
328: AND resource_id = p_resource_id
329: AND resource_type_code = p_resource_type
1461: , jtf_task_statuses_b sb
1462: , jtf_task_statuses_tl sl
1463: , hz_party_sites ps
1464: , hz_locations hl
1465: , hz_parties pi
1466: , fnd_timezones_b tz
1467: WHERE a.task_id = p_task_id
1468: AND resource_id = p_resource_id
1469: AND resource_type_code = p_resource_type
2431: , jtf_task_statuses_b sb
2432: , jtf_task_statuses_tl sl
2433: , hz_party_sites ps
2434: , hz_locations hl
2435: , hz_parties pi
2436: , fnd_timezones_b tz
2437: WHERE a.task_id = p_task_id
2438: AND resource_id = p_resource_id
2439: AND resource_type_code = p_resource_type
3158: , jtf_task_statuses_b sb
3159: , jtf_task_statuses_tl sl
3160: , hz_party_sites ps
3161: , hz_locations hl
3162: , hz_parties pi
3163: , fnd_timezones_b tz
3164: WHERE a.task_id = p_task_id
3165: AND resource_id = p_resource_id
3166: AND resource_type_code = p_resource_type
5265:
5266:
5267:
5268: ---------------------------------------------------------------------------------------------
5269: --Cursor C1 introduced when show labels on taskbar is true i.e join for hz_parties for showing
5270: --party name on taskbar and this cursor is without task dependenciea join.
5271: ---------------------------------------------------------------------------------------------
5272:
5273: CURSOR c1
5329: , jtf_task_priorities_B jtp
5330: , jtf_task_priorities_tl jtpl
5331: , jtf_task_statuses_b tsb
5332: , jtf_task_statuses_b tsa
5333: , hz_parties pi
5334: , hz_party_sites ps
5335: , hz_locations l
5336: , csf_access_hours_b ca
5337: , csp_requirement_headers cr
5361: AND booking_end_date >= booking_start_date;
5362:
5363: ---------------------------------------------------------------------------------------------
5364: --Cursor C3 introduced if task_dependency is set to active in scheduling chart icon setup form
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)
5423: , jtf_task_priorities_B jtp
5424: , jtf_task_priorities_tl jtpl
5425: , jtf_task_statuses_b tsb
5426: , jtf_task_statuses_b tsa
5427: , hz_parties pi
5428: , hz_party_sites ps
5429: , hz_locations l
5430: , csf_access_hours_b ca
5431: , jtf_task_depends jd
5457: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
5458: AND cr.task_id(+) = t.task_id
5459: AND booking_end_date >= booking_start_date;
5460: ---------------------------------------------------------------------------------------------
5461: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)
5458: AND cr.task_id(+) = t.task_id
5459: AND booking_end_date >= booking_start_date;
5460: ---------------------------------------------------------------------------------------------
5461: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)
5528: AND cr.task_id(+) = t.task_id
5529: AND booking_end_date >= booking_start_date;
5530: ---------------------------------------------------------------------------------------------
5531: --Cursor C4 introduced if task_dependency is set to active in scheduling chart icon setup form
5532: -- this cursor does not have hz_parties join like c2 but has dependencies join
5533: ---------------------------------------------------------------------------------------------
5534: CURSOR C4
5535: IS
5536: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)
6731: AND ca.start_date_time >= p_start_date -1
6732: AND ca.end_date_time <= p_end_date;
6733:
6734: ---------------------------------------------------------------------------------------------
6735: --Cursor c_real_task_1 introduced when show labels on taskbar is true i.e join for hz_parties for showing
6736: --party name on taskbar and this cursor is without task dependencies join.
6737: ---------------------------------------------------------------------------------------------
6738: CURSOR c_real_task_1 IS
6739:
6778: , jtf_tasks_tl tl
6779: , jtf_task_types_b tt
6780: , jtf_task_priorities_B jtp
6781: , jtf_task_priorities_tl jtpl
6782: , hz_parties pi
6783: , hz_party_sites ps
6784: , hz_locations l
6785: , csf_access_hours_b ca
6786: , csp_requirement_headers cr
6810: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
6811:
6812: ---------------------------------------------------------------------------------------------
6813: --Cursor c_real_task_3 introduced if task_dependency is set to active in scheduling chart icon setup form
6814: -- this cursor also has hz_parties join for party name to be shown on task bar
6815: ---------------------------------------------------------------------------------------------
6816: CURSOR c_real_task_3 IS
6817:
6818: SELECT
6858: , jtf_tasks_tl tl
6859: , jtf_task_types_b tt
6860: , jtf_task_priorities_B jtp
6861: , jtf_task_priorities_tl jtpl
6862: , hz_parties pi
6863: , hz_party_sites ps
6864: , hz_locations l
6865: , csf_access_hours_b ca
6866: , csp_requirement_headers cr
6898:
6899:
6900:
6901: ---------------------------------------------------------------------------------------------
6902: --Cursor c_real_task_2 introduced when show labels on taskbar is false i.e remove join for hz_parties
6903: -- the diffrence between c1 and c2 join for hz_parties
6904: ---------------------------------------------------------------------------------------------
6905: CURSOR c_real_task_2 IS
6906: SELECT
6899:
6900:
6901: ---------------------------------------------------------------------------------------------
6902: --Cursor c_real_task_2 introduced when show labels on taskbar is false i.e remove join for hz_parties
6903: -- the diffrence between c1 and c2 join for hz_parties
6904: ---------------------------------------------------------------------------------------------
6905: CURSOR c_real_task_2 IS
6906: SELECT
6907: cpv.task_id || '-' || cpv.plan_option_id real_task_key
6953: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
6954:
6955: ---------------------------------------------------------------------------------------------
6956: --Cursor c_real_task_4 introduced if task_dependency is set to active in scheduling chart icon setup form
6957: -- this cursor does not have hz_parties join like c2 but has dependencies join
6958: ---------------------------------------------------------------------------------------------
6959: CURSOR c_real_task_4 IS
6960: SELECT
6961: cpv.task_id || '-' || cpv.plan_option_id real_task_key
7032: AND end_time <= p_end_date
7033: AND (task_id = -1 OR task_id = p_task_id);
7034:
7035: ---------------------------------------------------------------------------------------------
7036: --Cursor C1 introduced when show labels on taskbar is true i.e join for hz_parties for showing
7037: --party name on taskbar and this cursor is without task dependenciea join.
7038: ---------------------------------------------------------------------------------------------
7039:
7040: CURSOR c1
7099: , jtf_task_priorities_B jtp
7100: , jtf_task_priorities_tl jtpl
7101: , jtf_task_statuses_b tsb
7102: , jtf_task_statuses_b tsa
7103: , hz_parties pi
7104: , hz_party_sites ps
7105: , hz_locations l
7106: , csf_access_hours_b ca
7107: , csp_requirement_headers cr
7132: AND a.object_capacity_id <>res_info.object_capacity_id;
7133:
7134: ---------------------------------------------------------------------------------------------
7135: --Cursor C3 introduced if task_dependency is set to active in scheduling chart icon setup form
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)
7198: , jtf_task_priorities_B jtp
7199: , jtf_task_priorities_tl jtpl
7200: , jtf_task_statuses_b tsb
7201: , jtf_task_statuses_b tsa
7202: , hz_parties pi
7203: , hz_party_sites ps
7204: , hz_locations l
7205: , csf_access_hours_b ca
7206: , jtf_task_depends jd
7234: AND booking_end_date >= booking_start_date
7235: AND a.object_capacity_id <>res_info.object_capacity_id;
7236:
7237: ---------------------------------------------------------------------------------------------
7238: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)
7235: AND a.object_capacity_id <>res_info.object_capacity_id;
7236:
7237: ---------------------------------------------------------------------------------------------
7238: --Cursor C2 introduced when show labels on taskbar is false i.e remove join for hz_parties
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)
7310: AND booking_end_date >= booking_start_date
7311: AND a.object_capacity_id <>res_info.object_capacity_id;
7312: ---------------------------------------------------------------------------------------------
7313: --Cursor C4 introduced if task_dependency is set to active in scheduling chart icon setup form
7314: -- this cursor does not have hz_parties join like c2 but has dependencies join
7315: ---------------------------------------------------------------------------------------------
7316: CURSOR C4
7317: IS
7318: SELECT /*+ ORDERED use_nl (res_info a t tt tsa tsb ca jd jdd cr)