[Home] [Help]
498: 'Y', decode(sign(capacity_quantity*g_res_capacity_percentage-availability_quantity), 1, 0, availability_quantity),
499: 'N', decode(sign(capacity_quantity*g_overcommitment_percentage-overcommitment_quantity), 1, 0, 0, 0, overcommitment_quantity)) quantity, --For Bug 8812042
500: col.render_priority,
501: col.file_name color_file_name
502: from pa_forecast_items, pa_timeline_colors col
503: where resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
504: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
505: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
506: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
527: 'MONTH' scale_type,
528: fi.item_quantity quantity,
529: col.render_priority,
530: col.file_name color_file_name
531: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
532: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
533: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
534: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
535: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
566: 'MONTH' scale_type,
567: fi.item_quantity quantity,
568: col.render_priority,
569: col.file_name color_file_name
570: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
571: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
572: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
573: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
574: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
606: 'Y', decode(sign((capacity_quantity*g_res_capacity_percentage)-availability_quantity), 1, 0, availability_quantity),
607: 'N', decode(sign((capacity_quantity*g_overcommitment_percentage)-overcommitment_quantity), 1, 0, 0, 0, overcommitment_quantity))) quantity, --For Bug 8812042
608: col.render_priority,
609: col.file_name color_file_name
610: from pa_forecast_items, pa_timeline_colors col
611: where resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
612: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
613: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
614: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
637: 'THREE_MONTH' scale_type,
638: sum(fi.item_quantity) quantity,
639: col.render_priority,
640: col.file_name color_file_name
641: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
642: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
643: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
644: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
645: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
680: 'THREE_MONTH' scale_type,
681: sum(fi.item_quantity) quantity,
682: col.render_priority,
683: col.file_name color_file_name
684: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
685: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
686: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
687: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
688: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
723: 'MONTH' scale_type,
724: decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity) quantity,
725: col.render_priority,
726: col.file_name color_file_name
727: from pa_forecast_items fi, pa_timeline_colors col,
728: (select resource_id,
729: global_exp_period_end_date week_end_date,
730: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
731: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
769: 'MONTH' scale_type,
770: fi.item_quantity quantity,
771: col.render_priority,
772: col.file_name color_file_name
773: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
774: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
775: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
776: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
777: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
807: 'MONTH' scale_type,
808: fi.item_quantity quantity,
809: col.render_priority,
810: col.file_name color_file_name
811: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
812: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
813: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
814: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
815: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
845: 'THREE_MONTH' scale_type,
846: sum(decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity)) quantity,
847: col.render_priority,
848: col.file_name color_file_name
849: from pa_forecast_items fi, pa_timeline_colors col,
850: (select resource_id,
851: global_exp_period_end_date week_end_date,
852: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
853: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
897: 'THREE_MONTH' scale_type,
898: sum(fi.item_quantity) quantity,
899: col.render_priority,
900: col.file_name color_file_name
901: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
902: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
903: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
904: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
905: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
940: 'THREE_MONTH' scale_type,
941: sum(fi.item_quantity) quantity,
942: col.render_priority,
943: col.file_name color_file_name
944: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
945: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
946: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
947: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
948: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
989: 'Y', decode(sign(fi.availability_quantity-fi.capacity_quantity*g_res_capacity_percentage), -1, 0, fi.availability_quantity),
990: 'N', decode(sign(fi.overcommitment_quantity-fi.capacity_quantity*g_overcommitment_percentage), -1, 0, 0, 0, fi.overcommitment_quantity)) quantity, --Bug 8627070
991: col.render_priority,
992: col.file_name color_file_name
993: from pa_forecast_items fi, pa_timeline_colors col
994: where fi.resource_id = p_resource_id
995: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
996: and fi.error_flag in ('N','Y') --Bug#9479220
997: and fi.forecast_item_type = 'U'
1009: 'MONTH' scale_type,
1010: fi.item_quantity quantity,
1011: col.render_priority,
1012: col.file_name color_file_name
1013: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1014: where fi.resource_id = p_resource_id
1015: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1016: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1017: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1047: 'MONTH' scale_type,
1048: fi.item_quantity quantity,
1049: col.render_priority,
1050: col.file_name color_file_name
1051: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1052: where fi.resource_id = p_resource_id
1053: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1054: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1055: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1088: 'Y', decode(sign(fi.capacity_quantity*g_res_capacity_percentage-fi.availability_quantity), 1, 0, fi.availability_quantity),
1089: 'N', decode(sign(fi.capacity_quantity*g_overcommitment_percentage-fi.overcommitment_quantity), 1, 0, 0, 0, fi.overcommitment_quantity))) quantity, --Bug 8627070
1090: col.render_priority,
1091: col.file_name color_file_name
1092: from pa_forecast_items fi, pa_timeline_colors col
1093: where fi.resource_id = p_resource_id
1094: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
1095: and fi.error_flag in ('N','Y') --Bug#9479220
1096: and fi.forecast_item_type = 'U'
1114: 'THREE_MONTH' scale_type,
1115: sum(fi.item_quantity) quantity,
1116: col.render_priority,
1117: col.file_name color_file_name
1118: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1119: where fi.resource_id = p_resource_id
1120: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1121: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1122: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1157: 'THREE_MONTH' scale_type,
1158: sum(fi.item_quantity) quantity,
1159: col.render_priority,
1160: col.file_name color_file_name
1161: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1162: where fi.resource_id = p_resource_id
1163: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1164: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1165: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1201: 'MONTH' scale_type,
1202: decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity) quantity,
1203: col.render_priority,
1204: col.file_name color_file_name
1205: from pa_forecast_items fi, pa_timeline_colors col,
1206: (select resource_id,
1207: global_exp_period_end_date week_end_date,
1208: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
1209: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
1241: 'MONTH' scale_type,
1242: fi.item_quantity quantity,
1243: col.render_priority,
1244: col.file_name color_file_name
1245: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1246: where fi.resource_id = p_resource_id
1247: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1248: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1249: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1281: 'MONTH' scale_type,
1282: fi.item_quantity quantity,
1283: col.render_priority,
1284: col.file_name color_file_name
1285: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1286: where fi.resource_id = p_resource_id
1287: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1288: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1289: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1321: 'THREE_MONTH' scale_type,
1322: sum(decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity)) quantity,
1323: col.render_priority,
1324: col.file_name color_file_name
1325: from pa_forecast_items fi, pa_timeline_colors col,
1326: (select resource_id,
1327: global_exp_period_end_date week_end_date,
1328: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
1329: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
1366: 'THREE_MONTH' scale_type,
1367: sum(fi.item_quantity) quantity,
1368: col.render_priority,
1369: col.file_name color_file_name
1370: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1371: where fi.resource_id = p_resource_id
1372: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1373: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1374: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1410: 'THREE_MONTH' scale_type,
1411: sum(fi.item_quantity) quantity,
1412: col.render_priority,
1413: col.file_name color_file_name
1414: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1415: where fi.resource_id = p_resource_id
1416: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1417: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1418: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1458: 'MONTH' scale_type,
1459: (fi_assigned.assigned_quantity-fi.capacity_quantity) quantity,
1460: col.render_priority,
1461: col.file_name color_file_name
1462: from pa_forecast_items fi, pa_timeline_colors col,
1463: (select resource_id,
1464: sum(item_quantity) assigned_quantity,
1465: item_date,
1466: delete_flag
1536: 'MONTH' scale_type,
1537: fi.item_quantity quantity,
1538: col.render_priority,
1539: col.file_name color_file_name
1540: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1541: where fi.resource_id = p_resource_id
1542: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1543: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1544: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1574: 'MONTH' scale_type,
1575: fi.item_quantity quantity,
1576: col.render_priority,
1577: col.file_name color_file_name
1578: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1579: where fi.resource_id = p_resource_id
1580: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1581: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1582: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1613: 'THREE_MONTH' scale_type,
1614: sum(fi_assigned.assigned_quantity-fi.capacity_quantity) quantity,
1615: col.render_priority,
1616: col.file_name color_file_name
1617: from pa_forecast_items fi, pa_timeline_colors col,
1618: (select resource_id,
1619: sum(item_quantity) assigned_quantity,
1620: item_date,
1621: delete_flag
1696: 'THREE_MONTH' scale_type,
1697: sum(fi.item_quantity) quantity,
1698: col.render_priority,
1699: col.file_name color_file_name
1700: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1701: where fi.resource_id = p_resource_id
1702: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1703: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1704: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1739: 'THREE_MONTH' scale_type,
1740: sum(fi.item_quantity) quantity,
1741: col.render_priority,
1742: col.file_name color_file_name
1743: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1744: where fi.resource_id = p_resource_id
1745: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1746: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1747: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1782: 'MONTH' scale_type,
1783: (fi_assigned.assigned_quantity-fi.capacity_quantity) quantity,
1784: col.render_priority,
1785: col.file_name color_file_name
1786: from pa_forecast_items fi, pa_timeline_colors col,
1787: (select resource_id,
1788: sum(item_quantity) assigned_quantity,
1789: item_date,
1790: delete_flag
1935: 'MONTH' scale_type,
1936: fi.item_quantity quantity,
1937: col.render_priority,
1938: col.file_name color_file_name
1939: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1940: where fi.resource_id = p_resource_id
1941: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1942: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1943: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1974: 'MONTH' scale_type,
1975: fi.item_quantity quantity,
1976: col.render_priority,
1977: col.file_name color_file_name
1978: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1979: where fi.resource_id = p_resource_id
1980: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1981: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1982: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
2013: 'THREE_MONTH' scale_type,
2014: fi_week.overcom_quantity quantity,
2015: col.render_priority,
2016: col.file_name color_file_name
2017: from pa_timeline_colors col,
2018: (select
2019: fi_week_capacity.resource_id,
2020: decode(sign((fi_week_assigned.assigned_quantity-fi_week_capacity.capacity_quantity)-fi_week_capacity.capacity_quantity*G_OVERCOMMITMENT_PERCENTAGE),
2021: -1, 0, fi_week_assigned.assigned_quantity-fi_week_capacity.capacity_quantity) overcom_quantity,
2102: 'THREE_MONTH' scale_type,
2103: sum(fi.item_quantity) quantity,
2104: col.render_priority,
2105: col.file_name color_file_name
2106: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
2107: where fi.resource_id = p_resource_id
2108: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
2109: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
2110: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
2145: 'THREE_MONTH' scale_type,
2146: sum(fi.item_quantity) quantity,
2147: col.render_priority,
2148: col.file_name color_file_name
2149: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
2150: where fi.resource_id = p_resource_id
2151: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
2152: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
2153: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
2193: 'MONTH' scale_type,
2194: fi1.item_quantity quantity,
2195: col.render_priority,
2196: col.file_name color_file_name
2197: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2198: where fi1.forecast_item_type in ('A', 'R')
2199: and fi1.delete_flag = 'N'
2200: and fi1.item_date between p_start_date and p_end_date
2201: and fi1.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
2231: 'MONTH' scale_type,
2232: fi_admin.item_quantity quantity,
2233: col.render_priority,
2234: col.file_name color_file_name
2235: from pa_forecast_items fi1, pa_timeline_colors col,
2236: (select fi.resource_id,
2237: fi.assignment_id,
2238: fi.global_exp_period_end_date week_end_date,
2239: fi.item_date,
2272: 'MONTH' scale_type,
2273: fi_overcom.overcommitment_quantity quantity,
2274: col.render_priority,
2275: col.file_name color_file_name
2276: from pa_forecast_items fi1, pa_timeline_colors col,
2277: (select fi.resource_id,
2278: fi.item_date,
2279: fi.delete_flag,
2280: decode(sign(fi.capacity_quantity*g_overcommitment_percentage-fi.overcommitment_quantity), 1, 0, 0, 0, fi.overcommitment_quantity) overcommitment_quantity --For Bug 8812042
2312: 'MONTH' scale_type,
2313: fi1.item_quantity quantity,
2314: col.render_priority,
2315: col.file_name color_file_name
2316: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2317: where fi1.forecast_item_type in ('A', 'R')
2318: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2319: and fi1.error_flag in ('N','Y') --Bug#9479220
2320: and fi1.delete_flag = 'N'
2350: 'MONTH' scale_type,
2351: fi_admin.item_quantity quantity,
2352: col.render_priority,
2353: col.file_name color_file_name
2354: from pa_forecast_items fi1, pa_timeline_colors col,
2355: (select fi.resource_id,
2356: fi.assignment_id,
2357: fi.global_exp_period_end_date week_end_date,
2358: fi.item_date,
2394: 'THREE_MONTH' scale_type,
2395: sum(fi1.item_quantity) quantity,
2396: col.render_priority,
2397: col.file_name color_file_name
2398: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2399: where fi1.forecast_item_type in ('A', 'R')
2400: and fi1.delete_flag = 'N'
2401: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2402: and fi1.error_flag in ('N','Y') --Bug#9479220
2436: 'THREE_MONTH' scale_type,
2437: sum(fi_admin.item_quantity) quantity,
2438: col.render_priority,
2439: col.file_name color_file_name
2440: from pa_forecast_items fi1, pa_timeline_colors col,
2441: (select fi.resource_id,
2442: fi.assignment_id,
2443: fi.global_exp_period_end_date week_end_date,
2444: fi.item_date,
2482: 'THREE_MONTH' scale_type,
2483: sum(fi_overcom.overcommitment_quantity) quantity,
2484: col.render_priority,
2485: col.file_name color_file_name
2486: from pa_forecast_items fi1, pa_timeline_colors col,
2487: (select fi.resource_id,
2488: fi.item_date,
2489: fi.delete_flag,
2490: decode(sign(fi.capacity_quantity*g_overcommitment_percentage-fi.overcommitment_quantity), 1, 0, 0, 0, fi.overcommitment_quantity) overcommitment_quantity --For Bug 8812042
2526: 'THREE_MONTH' scale_type,
2527: sum(fi1.item_quantity) quantity,
2528: col.render_priority,
2529: col.file_name color_file_name
2530: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2531: where fi1.forecast_item_type in ('A', 'R')
2532: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2533: and fi1.error_flag in ('N','Y') --Bug#9479220
2534: and fi1.delete_flag = 'N'
2568: 'THREE_MONTH' scale_type,
2569: sum(fi_admin.item_quantity) quantity,
2570: col.render_priority,
2571: col.file_name color_file_name
2572: from pa_forecast_items fi1, pa_timeline_colors col,
2573: (select fi.resource_id,
2574: fi.assignment_id,
2575: fi.global_exp_period_end_date week_end_date,
2576: fi.item_date,
2626: 'MONTH' scale_type,
2627: fi1.item_quantity quantity,
2628: col.render_priority,
2629: col.file_name color_file_name
2630: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2631: where fi1.forecast_item_type in ('A', 'R')
2632: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2633: and fi1.error_flag in ('N','Y') --Bug#9479220
2634: and fi1.delete_flag = 'N'
2664: 'MONTH' scale_type,
2665: fi_admin.item_quantity quantity,
2666: col.render_priority,
2667: col.file_name color_file_name
2668: from pa_forecast_items fi1, pa_timeline_colors col,
2669: (select fi.resource_id,
2670: fi.assignment_id,
2671: fi.global_exp_period_end_date week_end_date,
2672: fi.item_date,
2705: 'MONTH' scale_type,
2706: fi_overcom.overcommitment_quantity quantity,
2707: col.render_priority,
2708: col.file_name color_file_name
2709: from pa_forecast_items fi1, pa_timeline_colors col,
2710: (select fi.resource_id,
2711: fi.item_date,
2712: fi.delete_flag,
2713: decode(fi_week.overcommitment_flag, 'Y', fi.overcommitment_quantity, 'N', 0) overcommitment_quantity
2789: 'MONTH' scale_type,
2790: fi1.item_quantity quantity,
2791: col.render_priority,
2792: col.file_name color_file_name
2793: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2794: where fi1.forecast_item_type in ('A', 'R')
2795: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2796: and fi1.error_flag in ('N','Y') --Bug#9479220
2797: and fi1.delete_flag = 'N'
2827: 'MONTH' scale_type,
2828: fi_admin.item_quantity quantity,
2829: col.render_priority,
2830: col.file_name color_file_name
2831: from pa_forecast_items fi1, pa_timeline_colors col,
2832: (select fi.resource_id,
2833: fi.assignment_id,
2834: fi.global_exp_period_end_date week_end_date,
2835: fi.item_date,
2879: 'THREE_MONTH' scale_type,
2880: sum(fi1.item_quantity) quantity,
2881: col.render_priority,
2882: col.file_name color_file_name
2883: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2884: where fi1.forecast_item_type in ('A', 'R')
2885: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2886: and fi1.error_flag in ('N','Y') --Bug#9479220
2887: and fi1.delete_flag = 'N'
2921: 'THREE_MONTH' scale_type,
2922: sum(fi_admin.item_quantity) quantity,
2923: col.render_priority,
2924: col.file_name color_file_name
2925: from pa_forecast_items fi1, pa_timeline_colors col,
2926: (select fi.resource_id,
2927: fi.assignment_id,
2928: fi.global_exp_period_end_date week_end_date,
2929: fi.item_date,
2967: 'THREE_MONTH' scale_type,
2968: sum(fi_overcom.overcommitment_quantity) quantity,
2969: col.render_priority,
2970: col.file_name color_file_name
2971: from pa_forecast_items fi1, pa_timeline_colors col,
2972: (select fi.resource_id,
2973: fi.item_date,
2974: fi.delete_flag,
2975: decode(fi_week.overcommitment_flag, 'Y', fi.overcommitment_quantity, 'N', 0) overcommitment_quantity
3055: 'THREE_MONTH' scale_type,
3056: sum(fi1.item_quantity) quantity,
3057: col.render_priority,
3058: col.file_name color_file_name
3059: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
3060: where fi1.forecast_item_type in ('A', 'R')
3061: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
3062: and fi1.error_flag in ('N','Y') --Bug#9479220
3063: and fi1.delete_flag = 'N'
3097: 'THREE_MONTH' scale_type,
3098: sum(fi_admin.item_quantity) quantity,
3099: col.render_priority,
3100: col.file_name color_file_name
3101: from pa_forecast_items fi1, pa_timeline_colors col,
3102: (select fi.resource_id,
3103: fi.assignment_id,
3104: fi.global_exp_period_end_date week_end_date,
3105: fi.item_date,