[Home] [Help]
497: 'Y', decode(sign(capacity_quantity*g_res_capacity_percentage-availability_quantity), 1, 0, availability_quantity),
498: 'N', decode(sign(capacity_quantity*g_overcommitment_percentage-overcommitment_quantity), 1, 0, overcommitment_quantity)) quantity,
499: col.render_priority,
500: col.file_name color_file_name
501: from pa_forecast_items, pa_timeline_colors col
502: where resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
503: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
504: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
505: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
524: 'MONTH' scale_type,
525: fi.item_quantity quantity,
526: col.render_priority,
527: col.file_name color_file_name
528: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
529: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
530: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
531: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
532: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
562: 'MONTH' scale_type,
563: fi.item_quantity quantity,
564: col.render_priority,
565: col.file_name color_file_name
566: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
567: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
568: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
569: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
570: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
601: 'Y', decode(sign((capacity_quantity*g_res_capacity_percentage)-availability_quantity), 1, 0, availability_quantity),
602: 'N', decode(sign((capacity_quantity*g_overcommitment_percentage)-overcommitment_quantity), 1, 0, overcommitment_quantity))) quantity,
603: col.render_priority,
604: col.file_name color_file_name
605: from pa_forecast_items, pa_timeline_colors col
606: where resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
607: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
608: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
609: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
630: 'THREE_MONTH' scale_type,
631: sum(fi.item_quantity) quantity,
632: col.render_priority,
633: col.file_name color_file_name
634: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
635: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
636: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
637: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
638: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
672: 'THREE_MONTH' scale_type,
673: sum(fi.item_quantity) quantity,
674: col.render_priority,
675: col.file_name color_file_name
676: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
677: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
678: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
679: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
680: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
714: 'MONTH' scale_type,
715: decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity) quantity,
716: col.render_priority,
717: col.file_name color_file_name
718: from pa_forecast_items fi, pa_timeline_colors col,
719: (select resource_id,
720: global_exp_period_end_date week_end_date,
721: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
722: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
759: 'MONTH' scale_type,
760: fi.item_quantity quantity,
761: col.render_priority,
762: col.file_name color_file_name
763: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
764: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
765: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
766: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
767: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
796: 'MONTH' scale_type,
797: fi.item_quantity quantity,
798: col.render_priority,
799: col.file_name color_file_name
800: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
801: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
802: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
803: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
804: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
833: 'THREE_MONTH' scale_type,
834: sum(decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity)) quantity,
835: col.render_priority,
836: col.file_name color_file_name
837: from pa_forecast_items fi, pa_timeline_colors col,
838: (select resource_id,
839: global_exp_period_end_date week_end_date,
840: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
841: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
883: 'THREE_MONTH' scale_type,
884: sum(fi.item_quantity) quantity,
885: col.render_priority,
886: col.file_name color_file_name
887: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
888: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
889: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
890: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
891: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
925: 'THREE_MONTH' scale_type,
926: sum(fi.item_quantity) quantity,
927: col.render_priority,
928: col.file_name color_file_name
929: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
930: where fi.resource_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
931: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
932: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
933: l_row_label_id_tbl(9), l_row_label_id_tbl(10),l_row_label_id_tbl(11),
973: 'Y', decode(sign(fi.availability_quantity-fi.capacity_quantity*g_res_capacity_percentage), -1, 0, fi.availability_quantity),
974: 'N', decode(sign(fi.overcommitment_quantity-fi.capacity_quantity*g_overcommitment_percentage), -1, 0, fi.overcommitment_quantity)) quantity,
975: col.render_priority,
976: col.file_name color_file_name
977: from pa_forecast_items fi, pa_timeline_colors col
978: where fi.resource_id = p_resource_id
979: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
980: and fi.forecast_item_type = 'U'
981: and fi.item_date between p_start_date and p_end_date
991: 'MONTH' scale_type,
992: fi.item_quantity quantity,
993: col.render_priority,
994: col.file_name color_file_name
995: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
996: where fi.resource_id = p_resource_id
997: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
998: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
999: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1028: 'MONTH' scale_type,
1029: fi.item_quantity quantity,
1030: col.render_priority,
1031: col.file_name color_file_name
1032: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1033: where fi.resource_id = p_resource_id
1034: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1035: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1036: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1068: 'Y', decode(sign(fi.capacity_quantity*g_res_capacity_percentage-fi.availability_quantity), 1, 0, fi.availability_quantity),
1069: 'N', decode(sign(fi.capacity_quantity*g_overcommitment_percentage-fi.overcommitment_quantity), 1, 0, fi.overcommitment_quantity))) quantity,
1070: col.render_priority,
1071: col.file_name color_file_name
1072: from pa_forecast_items fi, pa_timeline_colors col
1073: where fi.resource_id = p_resource_id
1074: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
1075: and fi.forecast_item_type = 'U'
1076: and fi.item_date between p_start_date and p_end_date
1092: 'THREE_MONTH' scale_type,
1093: sum(fi.item_quantity) quantity,
1094: col.render_priority,
1095: col.file_name color_file_name
1096: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1097: where fi.resource_id = p_resource_id
1098: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1099: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1100: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1134: 'THREE_MONTH' scale_type,
1135: sum(fi.item_quantity) quantity,
1136: col.render_priority,
1137: col.file_name color_file_name
1138: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1139: where fi.resource_id = p_resource_id
1140: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1141: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1142: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1177: 'MONTH' scale_type,
1178: decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity) quantity,
1179: col.render_priority,
1180: col.file_name color_file_name
1181: from pa_forecast_items fi, pa_timeline_colors col,
1182: (select resource_id,
1183: global_exp_period_end_date week_end_date,
1184: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
1185: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
1215: 'MONTH' scale_type,
1216: fi.item_quantity quantity,
1217: col.render_priority,
1218: col.file_name color_file_name
1219: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1220: where fi.resource_id = p_resource_id
1221: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1222: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1223: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1254: 'MONTH' scale_type,
1255: fi.item_quantity quantity,
1256: col.render_priority,
1257: col.file_name color_file_name
1258: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1259: where fi.resource_id = p_resource_id
1260: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1261: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1262: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1293: 'THREE_MONTH' scale_type,
1294: sum(decode(fi_week.availability_flag, 'Y', fi.availability_quantity, 'N', fi.overcommitment_quantity)) quantity,
1295: col.render_priority,
1296: col.file_name color_file_name
1297: from pa_forecast_items fi, pa_timeline_colors col,
1298: (select resource_id,
1299: global_exp_period_end_date week_end_date,
1300: decode(sign(sum(capacity_quantity)*g_res_capacity_percentage-sum(availability_quantity)),1, 'N', 'Y') availability_flag,
1301: decode(sign(sum(capacity_quantity)*g_overcommitment_percentage-sum(overcommitment_quantity)), 1, 'N',
1336: 'THREE_MONTH' scale_type,
1337: sum(fi.item_quantity) quantity,
1338: col.render_priority,
1339: col.file_name color_file_name
1340: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1341: where fi.resource_id = p_resource_id
1342: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1343: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1344: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1379: 'THREE_MONTH' scale_type,
1380: sum(fi.item_quantity) quantity,
1381: col.render_priority,
1382: col.file_name color_file_name
1383: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1384: where fi.resource_id = p_resource_id
1385: and fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1386: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1387: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1426: 'MONTH' scale_type,
1427: (fi_assigned.assigned_quantity-fi.capacity_quantity) quantity,
1428: col.render_priority,
1429: col.file_name color_file_name
1430: from pa_forecast_items fi, pa_timeline_colors col,
1431: (select resource_id,
1432: sum(item_quantity) assigned_quantity,
1433: item_date,
1434: delete_flag
1503: 'MONTH' scale_type,
1504: fi.item_quantity quantity,
1505: col.render_priority,
1506: col.file_name color_file_name
1507: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1508: where fi.resource_id = p_resource_id
1509: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1510: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1511: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1540: 'MONTH' scale_type,
1541: fi.item_quantity quantity,
1542: col.render_priority,
1543: col.file_name color_file_name
1544: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1545: where fi.resource_id = p_resource_id
1546: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1547: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1548: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1578: 'THREE_MONTH' scale_type,
1579: sum(fi_assigned.assigned_quantity-fi.capacity_quantity) quantity,
1580: col.render_priority,
1581: col.file_name color_file_name
1582: from pa_forecast_items fi, pa_timeline_colors col,
1583: (select resource_id,
1584: sum(item_quantity) assigned_quantity,
1585: item_date,
1586: delete_flag
1660: 'THREE_MONTH' scale_type,
1661: sum(fi.item_quantity) quantity,
1662: col.render_priority,
1663: col.file_name color_file_name
1664: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1665: where fi.resource_id = p_resource_id
1666: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1667: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1668: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1702: 'THREE_MONTH' scale_type,
1703: sum(fi.item_quantity) quantity,
1704: col.render_priority,
1705: col.file_name color_file_name
1706: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1707: where fi.resource_id = p_resource_id
1708: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1709: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1710: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1744: 'MONTH' scale_type,
1745: (fi_assigned.assigned_quantity-fi.capacity_quantity) quantity,
1746: col.render_priority,
1747: col.file_name color_file_name
1748: from pa_forecast_items fi, pa_timeline_colors col,
1749: (select resource_id,
1750: sum(item_quantity) assigned_quantity,
1751: item_date,
1752: delete_flag
1896: 'MONTH' scale_type,
1897: fi.item_quantity quantity,
1898: col.render_priority,
1899: col.file_name color_file_name
1900: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1901: where fi.resource_id = p_resource_id
1902: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1903: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1904: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1934: 'MONTH' scale_type,
1935: fi.item_quantity quantity,
1936: col.render_priority,
1937: col.file_name color_file_name
1938: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
1939: where fi.resource_id = p_resource_id
1940: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
1941: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
1942: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
1972: 'THREE_MONTH' scale_type,
1973: fi_week.overcom_quantity quantity,
1974: col.render_priority,
1975: col.file_name color_file_name
1976: from pa_timeline_colors col,
1977: (select
1978: fi_week_capacity.resource_id,
1979: decode(sign((fi_week_assigned.assigned_quantity-fi_week_capacity.capacity_quantity)-fi_week_capacity.capacity_quantity*G_OVERCOMMITMENT_PERCENTAGE),
1980: -1, 0, fi_week_assigned.assigned_quantity-fi_week_capacity.capacity_quantity) overcom_quantity,
2061: 'THREE_MONTH' scale_type,
2062: sum(fi.item_quantity) quantity,
2063: col.render_priority,
2064: col.file_name color_file_name
2065: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
2066: where fi.resource_id = p_resource_id
2067: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
2068: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
2069: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
2103: 'THREE_MONTH' scale_type,
2104: sum(fi.item_quantity) quantity,
2105: col.render_priority,
2106: col.file_name color_file_name
2107: from pa_forecast_items fi, pa_timeline_colors col, pa_project_assignments asgn
2108: where fi.resource_id = p_resource_id
2109: and (fi.assignment_id = p_assignment_id or fi.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
2110: l_row_label_id_tbl(3), l_row_label_id_tbl(4),l_row_label_id_tbl(5),
2111: l_row_label_id_tbl(6), l_row_label_id_tbl(7),l_row_label_id_tbl(8),
2150: 'MONTH' scale_type,
2151: fi1.item_quantity quantity,
2152: col.render_priority,
2153: col.file_name color_file_name
2154: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2155: where fi1.forecast_item_type in ('A', 'R')
2156: and fi1.delete_flag = 'N'
2157: and fi1.item_date between p_start_date and p_end_date
2158: and fi1.assignment_id in (l_row_label_id_tbl(1), l_row_label_id_tbl(2),
2187: 'MONTH' scale_type,
2188: fi_admin.item_quantity quantity,
2189: col.render_priority,
2190: col.file_name color_file_name
2191: from pa_forecast_items fi1, pa_timeline_colors col,
2192: (select fi.resource_id,
2193: fi.assignment_id,
2194: fi.global_exp_period_end_date week_end_date,
2195: fi.item_date,
2228: 'MONTH' scale_type,
2229: fi_overcom.overcommitment_quantity quantity,
2230: col.render_priority,
2231: col.file_name color_file_name
2232: from pa_forecast_items fi1, pa_timeline_colors col,
2233: (select fi.resource_id,
2234: fi.item_date,
2235: fi.delete_flag,
2236: decode(sign(fi.capacity_quantity*g_overcommitment_percentage-fi.overcommitment_quantity), 1, 0, fi.overcommitment_quantity) overcommitment_quantity
2267: 'MONTH' scale_type,
2268: fi1.item_quantity quantity,
2269: col.render_priority,
2270: col.file_name color_file_name
2271: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2272: where fi1.forecast_item_type in ('A', 'R')
2273: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2274: and fi1.delete_flag = 'N'
2275: and fi1.item_date between p_start_date and p_end_date
2304: 'MONTH' scale_type,
2305: fi_admin.item_quantity quantity,
2306: col.render_priority,
2307: col.file_name color_file_name
2308: from pa_forecast_items fi1, pa_timeline_colors col,
2309: (select fi.resource_id,
2310: fi.assignment_id,
2311: fi.global_exp_period_end_date week_end_date,
2312: fi.item_date,
2348: 'THREE_MONTH' scale_type,
2349: sum(fi1.item_quantity) quantity,
2350: col.render_priority,
2351: col.file_name color_file_name
2352: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2353: where fi1.forecast_item_type in ('A', 'R')
2354: and fi1.delete_flag = 'N'
2355: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2356: and fi1.item_date between p_start_date and p_end_date
2389: 'THREE_MONTH' scale_type,
2390: sum(fi_admin.item_quantity) quantity,
2391: col.render_priority,
2392: col.file_name color_file_name
2393: from pa_forecast_items fi1, pa_timeline_colors col,
2394: (select fi.resource_id,
2395: fi.assignment_id,
2396: fi.global_exp_period_end_date week_end_date,
2397: fi.item_date,
2435: 'THREE_MONTH' scale_type,
2436: sum(fi_overcom.overcommitment_quantity) quantity,
2437: col.render_priority,
2438: col.file_name color_file_name
2439: from pa_forecast_items fi1, pa_timeline_colors col,
2440: (select fi.resource_id,
2441: fi.item_date,
2442: fi.delete_flag,
2443: decode(sign(fi.capacity_quantity*g_overcommitment_percentage-fi.overcommitment_quantity), 1, 0, fi.overcommitment_quantity) overcommitment_quantity
2478: 'THREE_MONTH' scale_type,
2479: sum(fi1.item_quantity) quantity,
2480: col.render_priority,
2481: col.file_name color_file_name
2482: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2483: where fi1.forecast_item_type in ('A', 'R')
2484: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2485: and fi1.delete_flag = 'N'
2486: and fi1.item_date between p_start_date and p_end_date
2519: 'THREE_MONTH' scale_type,
2520: sum(fi_admin.item_quantity) quantity,
2521: col.render_priority,
2522: col.file_name color_file_name
2523: from pa_forecast_items fi1, pa_timeline_colors col,
2524: (select fi.resource_id,
2525: fi.assignment_id,
2526: fi.global_exp_period_end_date week_end_date,
2527: fi.item_date,
2577: 'MONTH' scale_type,
2578: fi1.item_quantity quantity,
2579: col.render_priority,
2580: col.file_name color_file_name
2581: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2582: where fi1.forecast_item_type in ('A', 'R')
2583: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2584: and fi1.delete_flag = 'N'
2585: and fi1.item_date between p_start_date and p_end_date
2614: 'MONTH' scale_type,
2615: fi_admin.item_quantity quantity,
2616: col.render_priority,
2617: col.file_name color_file_name
2618: from pa_forecast_items fi1, pa_timeline_colors col,
2619: (select fi.resource_id,
2620: fi.assignment_id,
2621: fi.global_exp_period_end_date week_end_date,
2622: fi.item_date,
2655: 'MONTH' scale_type,
2656: fi_overcom.overcommitment_quantity quantity,
2657: col.render_priority,
2658: col.file_name color_file_name
2659: from pa_forecast_items fi1, pa_timeline_colors col,
2660: (select fi.resource_id,
2661: fi.item_date,
2662: fi.delete_flag,
2663: decode(fi_week.overcommitment_flag, 'Y', fi.overcommitment_quantity, 'N', 0) overcommitment_quantity
2738: 'MONTH' scale_type,
2739: fi1.item_quantity quantity,
2740: col.render_priority,
2741: col.file_name color_file_name
2742: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2743: where fi1.forecast_item_type in ('A', 'R')
2744: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2745: and fi1.delete_flag = 'N'
2746: and fi1.item_date between p_start_date and p_end_date
2775: 'MONTH' scale_type,
2776: fi_admin.item_quantity quantity,
2777: col.render_priority,
2778: col.file_name color_file_name
2779: from pa_forecast_items fi1, pa_timeline_colors col,
2780: (select fi.resource_id,
2781: fi.assignment_id,
2782: fi.global_exp_period_end_date week_end_date,
2783: fi.item_date,
2827: 'THREE_MONTH' scale_type,
2828: sum(fi1.item_quantity) quantity,
2829: col.render_priority,
2830: col.file_name color_file_name
2831: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
2832: where fi1.forecast_item_type in ('A', 'R')
2833: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
2834: and fi1.delete_flag = 'N'
2835: and fi1.item_date between p_start_date and p_end_date
2868: 'THREE_MONTH' scale_type,
2869: sum(fi_admin.item_quantity) quantity,
2870: col.render_priority,
2871: col.file_name color_file_name
2872: from pa_forecast_items fi1, pa_timeline_colors col,
2873: (select fi.resource_id,
2874: fi.assignment_id,
2875: fi.global_exp_period_end_date week_end_date,
2876: fi.item_date,
2914: 'THREE_MONTH' scale_type,
2915: sum(fi_overcom.overcommitment_quantity) quantity,
2916: col.render_priority,
2917: col.file_name color_file_name
2918: from pa_forecast_items fi1, pa_timeline_colors col,
2919: (select fi.resource_id,
2920: fi.item_date,
2921: fi.delete_flag,
2922: decode(fi_week.overcommitment_flag, 'Y', fi.overcommitment_quantity, 'N', 0) overcommitment_quantity
3001: 'THREE_MONTH' scale_type,
3002: sum(fi1.item_quantity) quantity,
3003: col.render_priority,
3004: col.file_name color_file_name
3005: from pa_forecast_items fi1, pa_timeline_colors col, pa_project_assignments asgn
3006: where fi1.forecast_item_type in ('A', 'R')
3007: and col.lookup_type = 'TIMELINE_STATUS' -- Added for Bug 5079783
3008: and fi1.delete_flag = 'N'
3009: and fi1.item_date between p_start_date and p_end_date
3042: 'THREE_MONTH' scale_type,
3043: sum(fi_admin.item_quantity) quantity,
3044: col.render_priority,
3045: col.file_name color_file_name
3046: from pa_forecast_items fi1, pa_timeline_colors col,
3047: (select fi.resource_id,
3048: fi.assignment_id,
3049: fi.global_exp_period_end_date week_end_date,
3050: fi.item_date,