[Home] [Help]
588: , null AS P_CHANGE21
589: , null AS P_CHANGE22
590: FROM
591: PJI_PMV_TIME_DIM_TMP TIME
592: , PJI_PMV_ORGZ_DIM_TMP HORG
593: , pji_fp_orgo_f_mv fct
594: , PJI_PMV_ORG_DIM_TMP HOU
595: WHERE
596: fct.org_id = hou.id
616: , null AS P_CHANGE21
617: , null AS P_CHANGE22
618: FROM
619: PJI_PMV_TIME_DIM_TMP TIME
620: , PJI_PMV_ORGZ_DIM_TMP HORG
621: , pji_fp_orgo_f_mv fct
622: , PJI_PMV_ORG_DIM_TMP HOU
623:
624: WHERE
649: , null AS P_CHANGE21
650: , null AS P_CHANGE22
651: FROM
652: PJI_PMV_TIME_DIM_TMP TIME
653: , PJI_PMV_ORGZ_DIM_TMP HORG
654: , pji_fp_orgo_f_mv fct
655: , PJI_PMV_ORG_DIM_TMP HOU
656:
657: WHERE
682: , null AS P_CHANGE21
683: , null AS P_CHANGE22
684: FROM
685: PJI_PMV_TIME_DIM_TMP TIME
686: , PJI_PMV_ORGZ_DIM_TMP HORG
687: , pji_fp_orgo_f_mv fct
688: , PJI_PMV_ORG_DIM_TMP HOU
689:
690: WHERE
716: , null AS P_CHANGE21
717: , null AS P_CHANGE22
718: FROM
719: PJI_PMV_TIME_DIM_TMP TIME
720: , PJI_PMV_ORGZ_DIM_TMP HORG
721: , pji_fp_orgo_f_mv fct
722: , PJI_PMV_ORG_DIM_TMP HOU
723: WHERE
724: fct.org_id = hou.id
748: , null AS P_CHANGE21
749: , null AS P_CHANGE22
750: FROM
751: PJI_PMV_TIME_DIM_TMP TIME
752: , PJI_PMV_ORGZ_DIM_TMP HORG
753: , pji_fp_orgo_f_mv fct
754: , PJI_PMV_ORG_DIM_TMP HOU
755: WHERE
756: fct.org_id = hou.id
864: , null AS P_CHANGE21
865: , null AS P_CHANGE22
866: FROM
867: PJI_PMV_TIME_DIM_TMP TIME
868: , PJI_PMV_ORGZ_DIM_TMP HORG
869: , PJI_PMV_CLS_DIM_TMP CLS
870: , pji_fp_clso_f_mv fct
871: , PJI_PMV_ORG_DIM_TMP HOU
872:
895: , null AS P_CHANGE21
896: , null AS P_CHANGE22
897: FROM
898: PJI_PMV_TIME_DIM_TMP TIME
899: , PJI_PMV_ORGZ_DIM_TMP HORG
900: , PJI_PMV_CLS_DIM_TMP CLS
901: , pji_fp_clso_f_mv fct
902: , PJI_PMV_ORG_DIM_TMP HOU
903: WHERE
929: , null AS P_CHANGE21
930: , null AS P_CHANGE22
931: FROM
932: PJI_PMV_TIME_DIM_TMP TIME
933: , PJI_PMV_ORGZ_DIM_TMP HORG
934: , PJI_PMV_CLS_DIM_TMP CLS
935: , pji_fp_clso_f_mv fct
936: , PJI_PMV_ORG_DIM_TMP HOU
937:
964: , null AS P_CHANGE21
965: , null AS P_CHANGE22
966: FROM
967: PJI_PMV_TIME_DIM_TMP TIME
968: , PJI_PMV_ORGZ_DIM_TMP HORG
969: , PJI_PMV_CLS_DIM_TMP CLS
970: , pji_fp_clso_f_mv fct
971: , PJI_PMV_ORG_DIM_TMP HOU
972: WHERE
998: , null AS P_CHANGE21
999: , null AS P_CHANGE22
1000: FROM
1001: PJI_PMV_TIME_DIM_TMP TIME
1002: , PJI_PMV_ORGZ_DIM_TMP HORG
1003: , PJI_PMV_CLS_DIM_TMP CLS
1004: , pji_fp_clso_f_mv fct
1005: , PJI_PMV_ORG_DIM_TMP HOU
1006: WHERE
1031: , null AS P_CHANGE2
1032: , null AS P_CHANGE21
1033: , null AS P_CHANGE22
1034: FROM PJI_PMV_TIME_DIM_TMP TIME
1035: , PJI_PMV_ORGZ_DIM_TMP HORG
1036: , PJI_PMV_CLS_DIM_TMP CLS
1037: , pji_fp_clso_f_mv fct
1038: , PJI_PMV_ORG_DIM_TMP HOU
1039: WHERE
1148: , null AS P_CHANGE21
1149: , null AS P_CHANGE22
1150: FROM
1151: PJI_PMV_TIME_DIM_TMP TIME
1152: , PJI_PMV_ORGZ_DIM_TMP HORG
1153: , PJI_PMV_ET_RT_DIM_TMP ET
1154: , PJI_FP_ORGO_ET_F_MV fct
1155: , PJI_PMV_ORG_DIM_TMP HOU
1156:
1180: , null AS P_CHANGE21
1181: , null AS P_CHANGE22
1182: FROM
1183: PJI_PMV_TIME_DIM_TMP TIME
1184: , PJI_PMV_ORGZ_DIM_TMP HORG
1185: , PJI_PMV_ET_RT_DIM_TMP ET
1186: , PJI_FP_ORGO_ET_F_MV fct
1187: , PJI_PMV_ORG_DIM_TMP HOU
1188: WHERE
1213: , null AS P_CHANGE21
1214: , null AS P_CHANGE22
1215: FROM
1216: PJI_PMV_TIME_DIM_TMP TIME
1217: , PJI_PMV_ORGZ_DIM_TMP HORG
1218: , PJI_PMV_ET_RT_DIM_TMP ET
1219: , PJI_FP_ORGO_ET_F_MV fct
1220: , PJI_PMV_ORG_DIM_TMP HOU
1221:
1247: , null AS P_CHANGE21
1248: , null AS P_CHANGE22
1249: FROM
1250: PJI_PMV_TIME_DIM_TMP TIME
1251: , PJI_PMV_ORGZ_DIM_TMP HORG
1252: , PJI_PMV_ET_RT_DIM_TMP ET
1253: , PJI_FP_ORGO_ET_F_MV fct
1254: , PJI_PMV_ORG_DIM_TMP HOU
1255: WHERE
1280: , null AS P_CHANGE21
1281: , null AS P_CHANGE22
1282: FROM
1283: PJI_PMV_TIME_DIM_TMP TIME
1284: , PJI_PMV_ORGZ_DIM_TMP HORG
1285: , PJI_PMV_ET_RT_DIM_TMP ET
1286: , PJI_FP_ORGO_ET_F_MV fct
1287: , PJI_PMV_ORG_DIM_TMP HOU
1288: WHERE
1312: , null AS P_CHANGE2
1313: , null AS P_CHANGE21
1314: , null AS P_CHANGE22
1315: FROM PJI_PMV_TIME_DIM_TMP TIME
1316: , PJI_PMV_ORGZ_DIM_TMP HORG
1317: , PJI_PMV_ET_RT_DIM_TMP ET
1318: , PJI_FP_ORGO_ET_F_MV fct
1319: , PJI_PMV_ORG_DIM_TMP HOU
1320: WHERE
1429: , null AS P_CHANGE21
1430: , null AS P_CHANGE22
1431: FROM
1432: PJI_PMV_TIME_DIM_TMP TIME
1433: , PJI_PMV_ORGZ_DIM_TMP HORG
1434: , PJI_PMV_WT_DIM_TMP WT
1435: , PJI_FP_ORGO_ET_WT_F_MV fct
1436: , PJI_PMV_ORG_DIM_TMP HOU
1437:
1460: , null AS P_CHANGE21
1461: , null AS P_CHANGE22
1462: FROM
1463: PJI_PMV_TIME_DIM_TMP TIME
1464: , PJI_PMV_ORGZ_DIM_TMP HORG
1465: , PJI_PMV_WT_DIM_TMP WT
1466: , PJI_FP_ORGO_ET_WT_F_MV fct
1467: , PJI_PMV_ORG_DIM_TMP HOU
1468: WHERE
1492: , null AS P_CHANGE21
1493: , null AS P_CHANGE22
1494: FROM
1495: PJI_PMV_TIME_DIM_TMP TIME
1496: , PJI_PMV_ORGZ_DIM_TMP HORG
1497: , PJI_PMV_WT_DIM_TMP WT
1498: , PJI_FP_ORGO_ET_WT_F_MV fct
1499: , PJI_PMV_ORG_DIM_TMP HOU
1500:
1525: , null AS P_CHANGE21
1526: , null AS P_CHANGE22
1527: FROM
1528: PJI_PMV_TIME_DIM_TMP TIME
1529: , PJI_PMV_ORGZ_DIM_TMP HORG
1530: , PJI_PMV_WT_DIM_TMP WT
1531: , PJI_FP_ORGO_ET_WT_F_MV fct
1532: , PJI_PMV_ORG_DIM_TMP HOU
1533: WHERE
1555: , null AS P_CHANGE21
1556: , null AS P_CHANGE22
1557: FROM
1558: PJI_PMV_TIME_DIM_TMP TIME
1559: , PJI_PMV_ORGZ_DIM_TMP HORG
1560: , PJI_PMV_WT_DIM_TMP WT
1561: , PJI_FP_ORGO_ET_WT_F_MV fct
1562: , PJI_PMV_ORG_DIM_TMP HOU
1563: WHERE
1584: , null AS P_CHANGE2
1585: , null AS P_CHANGE21
1586: , null AS P_CHANGE22
1587: FROM PJI_PMV_TIME_DIM_TMP TIME
1588: , PJI_PMV_ORGZ_DIM_TMP HORG
1589: , PJI_PMV_WT_DIM_TMP WT
1590: , PJI_FP_ORGO_ET_WT_F_MV fct
1591: , PJI_PMV_ORG_DIM_TMP HOU
1592: WHERE
1701: , null AS P_CHANGE21
1702: , null AS P_CHANGE22
1703: FROM
1704: PJI_PMV_TIME_DIM_TMP TIME
1705: , PJI_PMV_ORGZ_DIM_TMP HORG
1706: , PJI_PMV_CLS_DIM_TMP CLS
1707: , PJI_PMV_ET_RT_DIM_TMP ET
1708: , PJI_FP_CLSO_ET_F_MV fct
1709: , PJI_PMV_ORG_DIM_TMP HOU
1736: , null AS P_CHANGE21
1737: , null AS P_CHANGE22
1738: FROM
1739: PJI_PMV_TIME_DIM_TMP TIME
1740: , PJI_PMV_ORGZ_DIM_TMP HORG
1741: , PJI_PMV_CLS_DIM_TMP CLS
1742: , PJI_PMV_ET_RT_DIM_TMP ET
1743: , PJI_FP_CLSO_ET_F_MV fct
1744: , PJI_PMV_ORG_DIM_TMP HOU
1771: , null AS P_CHANGE21
1772: , null AS P_CHANGE22
1773: FROM
1774: PJI_PMV_TIME_DIM_TMP TIME
1775: , PJI_PMV_ORGZ_DIM_TMP HORG
1776: , PJI_PMV_CLS_DIM_TMP CLS
1777: , PJI_PMV_ET_RT_DIM_TMP ET
1778: , PJI_FP_CLSO_ET_F_MV fct
1779: , PJI_PMV_ORG_DIM_TMP HOU
1807: , null AS P_CHANGE21
1808: , null AS P_CHANGE22
1809: FROM
1810: PJI_PMV_TIME_DIM_TMP TIME
1811: , PJI_PMV_ORGZ_DIM_TMP HORG
1812: , PJI_PMV_CLS_DIM_TMP CLS
1813: , PJI_PMV_ET_RT_DIM_TMP ET
1814: , PJI_FP_CLSO_ET_F_MV fct
1815: , PJI_PMV_ORG_DIM_TMP HOU
1842: , null AS P_CHANGE21
1843: , null AS P_CHANGE22
1844: FROM
1845: PJI_PMV_TIME_DIM_TMP TIME
1846: , PJI_PMV_ORGZ_DIM_TMP HORG
1847: , PJI_PMV_CLS_DIM_TMP CLS
1848: , PJI_PMV_ET_RT_DIM_TMP ET
1849: , PJI_FP_CLSO_ET_F_MV fct
1850: , PJI_PMV_ORG_DIM_TMP HOU
1876: , null AS P_CHANGE2
1877: , null AS P_CHANGE21
1878: , null AS P_CHANGE22
1879: FROM PJI_PMV_TIME_DIM_TMP TIME
1880: , PJI_PMV_ORGZ_DIM_TMP HORG
1881: , PJI_PMV_CLS_DIM_TMP CLS
1882: , PJI_PMV_ET_RT_DIM_TMP ET
1883: , PJI_FP_CLSO_ET_F_MV fct
1884: , PJI_PMV_ORG_DIM_TMP HOU
1994: , null AS P_CHANGE21
1995: , null AS P_CHANGE22
1996: FROM
1997: PJI_PMV_TIME_DIM_TMP TIME
1998: , PJI_PMV_ORGZ_DIM_TMP HORG
1999: , PJI_PMV_ET_RT_DIM_TMP ET
2000: , PJI_PMV_WT_DIM_TMP WT
2001: , PJI_FP_ORGO_ET_WT_F_MV fct
2002: , PJI_PMV_ORG_DIM_TMP HOU
2028: , null AS P_CHANGE21
2029: , null AS P_CHANGE22
2030: FROM
2031: PJI_PMV_TIME_DIM_TMP TIME
2032: , PJI_PMV_ORGZ_DIM_TMP HORG
2033: , PJI_PMV_ET_RT_DIM_TMP ET
2034: , PJI_PMV_WT_DIM_TMP WT
2035: , PJI_FP_ORGO_ET_WT_F_MV fct
2036: , PJI_PMV_ORG_DIM_TMP HOU
2064: , null AS P_CHANGE21
2065: , null AS P_CHANGE22
2066: FROM
2067: PJI_PMV_TIME_DIM_TMP TIME
2068: , PJI_PMV_ORGZ_DIM_TMP HORG
2069: , PJI_PMV_ET_RT_DIM_TMP ET
2070: , PJI_PMV_WT_DIM_TMP WT
2071: , PJI_FP_ORGO_ET_WT_F_MV fct
2072: , PJI_PMV_ORG_DIM_TMP HOU
2100: , null AS P_CHANGE21
2101: , null AS P_CHANGE22
2102: FROM
2103: PJI_PMV_TIME_DIM_TMP TIME
2104: , PJI_PMV_ORGZ_DIM_TMP HORG
2105: , PJI_PMV_ET_RT_DIM_TMP ET
2106: , PJI_PMV_WT_DIM_TMP WT
2107: , PJI_FP_ORGO_ET_WT_F_MV fct
2108: , PJI_PMV_ORG_DIM_TMP HOU
2133: , null AS P_CHANGE21
2134: , null AS P_CHANGE22
2135: FROM
2136: PJI_PMV_TIME_DIM_TMP TIME
2137: , PJI_PMV_ORGZ_DIM_TMP HORG
2138: , PJI_PMV_ET_RT_DIM_TMP ET
2139: , PJI_PMV_WT_DIM_TMP WT
2140: , PJI_FP_ORGO_ET_WT_F_MV fct
2141: , PJI_PMV_ORG_DIM_TMP HOU
2165: , null AS P_CHANGE2
2166: , null AS P_CHANGE21
2167: , null AS P_CHANGE22
2168: FROM PJI_PMV_TIME_DIM_TMP TIME
2169: , PJI_PMV_ORGZ_DIM_TMP HORG
2170: , PJI_PMV_ET_RT_DIM_TMP ET
2171: , PJI_PMV_WT_DIM_TMP WT
2172: , PJI_FP_ORGO_ET_WT_F_MV fct
2173: , PJI_PMV_ORG_DIM_TMP HOU
2283: , null AS P_CHANGE21
2284: , null AS P_CHANGE22
2285: FROM
2286: PJI_PMV_TIME_DIM_TMP TIME
2287: , PJI_PMV_ORGZ_DIM_TMP HORG
2288: , PJI_PMV_CLS_DIM_TMP CLS
2289: , PJI_PMV_WT_DIM_TMP WT
2290: , PJI_FP_CLSO_ET_WT_F_MV fct
2291: , PJI_PMV_ORG_DIM_TMP HOU
2316: , null AS P_CHANGE21
2317: , null AS P_CHANGE22
2318: FROM
2319: PJI_PMV_TIME_DIM_TMP TIME
2320: , PJI_PMV_ORGZ_DIM_TMP HORG
2321: , PJI_PMV_CLS_DIM_TMP CLS
2322: , PJI_PMV_WT_DIM_TMP WT
2323: , PJI_FP_CLSO_ET_WT_F_MV fct
2324: , PJI_PMV_ORG_DIM_TMP HOU
2350: , null AS P_CHANGE21
2351: , null AS P_CHANGE22
2352: FROM
2353: PJI_PMV_TIME_DIM_TMP TIME
2354: , PJI_PMV_ORGZ_DIM_TMP HORG
2355: , PJI_PMV_CLS_DIM_TMP CLS
2356: , PJI_PMV_WT_DIM_TMP WT
2357: , PJI_FP_CLSO_ET_WT_F_MV fct
2358: , PJI_PMV_ORG_DIM_TMP HOU
2385: , null AS P_CHANGE21
2386: , null AS P_CHANGE22
2387: FROM
2388: PJI_PMV_TIME_DIM_TMP TIME
2389: , PJI_PMV_ORGZ_DIM_TMP HORG
2390: , PJI_PMV_CLS_DIM_TMP CLS
2391: , PJI_PMV_WT_DIM_TMP WT
2392: , PJI_FP_CLSO_ET_WT_F_MV fct
2393: , PJI_PMV_ORG_DIM_TMP HOU
2417: , null AS P_CHANGE21
2418: , null AS P_CHANGE22
2419: FROM
2420: PJI_PMV_TIME_DIM_TMP TIME
2421: , PJI_PMV_ORGZ_DIM_TMP HORG
2422: , PJI_PMV_CLS_DIM_TMP CLS
2423: , PJI_PMV_WT_DIM_TMP WT
2424: , PJI_FP_CLSO_ET_WT_F_MV fct
2425: , PJI_PMV_ORG_DIM_TMP HOU
2448: , null AS P_CHANGE2
2449: , null AS P_CHANGE21
2450: , null AS P_CHANGE22
2451: FROM PJI_PMV_TIME_DIM_TMP TIME
2452: , PJI_PMV_ORGZ_DIM_TMP HORG
2453: , PJI_PMV_CLS_DIM_TMP CLS
2454: , PJI_PMV_WT_DIM_TMP WT
2455: , PJI_FP_CLSO_ET_WT_F_MV fct
2456: , PJI_PMV_ORG_DIM_TMP HOU
2564: , null AS P_CHANGE21
2565: , null AS P_CHANGE22
2566: FROM
2567: PJI_PMV_TIME_DIM_TMP TIME
2568: , PJI_PMV_ORGZ_DIM_TMP HORG
2569: , PJI_PMV_CLS_DIM_TMP CLS
2570: , PJI_PMV_ET_RT_DIM_TMP ET
2571: , PJI_PMV_WT_DIM_TMP WT
2572: , PJI_FP_CLSO_ET_WT_F_MV fct
2600: , null AS P_CHANGE21
2601: , null AS P_CHANGE22
2602: FROM
2603: PJI_PMV_TIME_DIM_TMP TIME
2604: , PJI_PMV_ORGZ_DIM_TMP HORG
2605: , PJI_PMV_CLS_DIM_TMP CLS
2606: , PJI_PMV_ET_RT_DIM_TMP ET
2607: , PJI_PMV_WT_DIM_TMP WT
2608: , PJI_FP_CLSO_ET_WT_F_MV fct
2637: , null AS P_CHANGE21
2638: , null AS P_CHANGE22
2639: FROM
2640: PJI_PMV_TIME_DIM_TMP TIME
2641: , PJI_PMV_ORGZ_DIM_TMP HORG
2642: , PJI_PMV_CLS_DIM_TMP CLS
2643: , PJI_PMV_ET_RT_DIM_TMP ET
2644: , PJI_PMV_WT_DIM_TMP WT
2645: , PJI_FP_CLSO_ET_WT_F_MV fct
2675: , null AS P_CHANGE21
2676: , null AS P_CHANGE22
2677: FROM
2678: PJI_PMV_TIME_DIM_TMP TIME
2679: , PJI_PMV_ORGZ_DIM_TMP HORG
2680: , PJI_PMV_CLS_DIM_TMP CLS
2681: , PJI_PMV_ET_RT_DIM_TMP ET
2682: , PJI_PMV_WT_DIM_TMP WT
2683: , PJI_FP_CLSO_ET_WT_F_MV fct
2710: , null AS P_CHANGE21
2711: , null AS P_CHANGE22
2712: FROM
2713: PJI_PMV_TIME_DIM_TMP TIME
2714: , PJI_PMV_ORGZ_DIM_TMP HORG
2715: , PJI_PMV_CLS_DIM_TMP CLS
2716: , PJI_PMV_ET_RT_DIM_TMP ET
2717: , PJI_PMV_WT_DIM_TMP WT
2718: , PJI_FP_CLSO_ET_WT_F_MV fct
2744: , null AS P_CHANGE2
2745: , null AS P_CHANGE21
2746: , null AS P_CHANGE22
2747: FROM PJI_PMV_TIME_DIM_TMP TIME
2748: , PJI_PMV_ORGZ_DIM_TMP HORG
2749: , PJI_PMV_CLS_DIM_TMP CLS
2750: , PJI_PMV_ET_RT_DIM_TMP ET
2751: , PJI_PMV_WT_DIM_TMP WT
2752: , PJI_FP_CLSO_ET_WT_F_MV fct
3268: SELECT DISTINCT prj.project_id, '-1' name
3269: FROM
3270: pji_project_classes PJM
3271: , pji_pmv_cls_dim_tmp PTM
3272: , pji_pmv_orgz_dim_tmp org
3273: , pa_projects_all prj
3274: WHERE
3275: pjm.project_class_id = ptm.id
3276: AND prj.project_id = pjm.project_id
3278: else
3279: INSERT into pji_pmv_prj_dim_tmp (id, name)
3280: SELECT DISTINCT prj.project_id, '-1' name
3281: FROM
3282: pji_pmv_orgz_dim_tmp org
3283: , pa_projects_all prj
3284: WHERE
3285: prj.carrying_out_organization_id = org.ID;
3286: end if;
3344: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
3345: 'RC', fct.forecast_raw_cost, 0), 0) AS FORECAST_BURDENED_COST
3346: FROM PJI_PMV_TIME_DIM_TMP TIME
3347: , PJI_PMV_PRJ_DIM_TMP PRJ
3348: , PJI_PMV_ORGZ_DIM_TMP HORG
3349: , PJI_FP_PROJ_F FCT
3350: , PJI_PMV_ORG_DIM_TMP HOU
3351: WHERE 1=1
3352: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
4148: , 0 AS CT_FORECAST_REVENUE
4149: , 0 AS CT_FORECAST_BURDENED_COST
4150: FROM
4151: PJI_PMV_TIME_DIM_TMP TIME
4152: , PJI_PMV_ORGZ_DIM_TMP HORG
4153: , PJI_FP_ORGO_F_MV fct
4154: , PJI_PMV_ORG_DIM_TMP HOU
4155:
4156: WHERE
4186: 'RC', fct.curr_bgt_raw_cost, 0)
4187: ,0) AS CT_FORECAST_BURDENED_COST
4188: FROM
4189: PJI_PMV_TIME_DIM_TMP TIME
4190: , PJI_PMV_ORGZ_DIM_TMP HORG
4191: , PJI_FP_ORGO_F_MV fct
4192: , PJI_PMV_ORG_DIM_TMP HOU
4193: WHERE
4194: fct.org_id = hou.id
4222: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
4223: 'RC', fct.forecast_raw_cost, 0),0) AS CT_FORECAST_BURDENED_COST
4224: FROM
4225: PJI_PMV_TCMP_DIM_TMP TIME
4226: , PJI_PMV_ORGZ_DIM_TMP HORG
4227: , PJI_FP_ORGO_F_MV fct
4228: , PJI_PMV_ORG_DIM_TMP HOU
4229: WHERE
4230: fct.org_id = hou.id
4270: , 0 AS CT_REVENUE
4271: , 0 AS CT_BURDENED_COST
4272: , 0 AS CT_FORECAST_REVENUE
4273: , 0 AS CT_FORECAST_BURDENED_COST
4274: FROM PJI_PMV_ORGZ_DIM_TMP HORG
4275: WHERE HORG.NAME <> '-1'
4276: )
4277: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,EXPENDITURE_TYPE_ID,REVENUE_CATEGORY,
4278: REVENUE_TYPE_ID, WORK_TYPE_ID;
4339: , 0 AS CT_FORECAST_REVENUE
4340: , 0 AS CT_FORECAST_BURDENED_COST
4341: FROM
4342: PJI_PMV_TIME_DIM_TMP TIME
4343: , PJI_PMV_ORGZ_DIM_TMP HORG
4344: , PJI_PMV_CLS_DIM_TMP CLS
4345: , PJI_FP_CLSO_F_MV fct
4346: , PJI_PMV_ORG_DIM_TMP HOU
4347: WHERE
4378:
4379: CT_FORECAST_BURDENED_COST
4380: FROM
4381: PJI_PMV_TIME_DIM_TMP TIME
4382: , PJI_PMV_ORGZ_DIM_TMP HORG
4383: , PJI_PMV_CLS_DIM_TMP CLS
4384: , PJI_FP_CLSO_F_MV fct
4385: , PJI_PMV_ORG_DIM_TMP HOU
4386: WHERE
4418:
4419: CT_FORECAST_BURDENED_COST
4420: FROM
4421: PJI_PMV_TCMP_DIM_TMP TIME
4422: , PJI_PMV_ORGZ_DIM_TMP HORG
4423: , PJI_PMV_CLS_DIM_TMP CLS
4424: , PJI_FP_CLSO_F_MV fct
4425: , PJI_PMV_ORG_DIM_TMP HOU
4426: WHERE
4468: , 0 AS CT_REVENUE
4469: , 0 AS CT_BURDENED_COST
4470: , 0 AS CT_FORECAST_REVENUE
4471: , 0 AS CT_FORECAST_BURDENED_COST
4472: FROM PJI_PMV_ORGZ_DIM_TMP HORG
4473: WHERE HORG.NAME <> '-1'
4474: UNION ALL -- FORCE Creation of Class/Code Rows
4475: SELECT '-1' AS ORG_ID
4476: , '-1' AS ORGANIZATION_ID
4548: , NULL AS CT_FORECAST_REVENUE
4549: , NULL AS CT_FORECAST_BURDENED_COST
4550: FROM
4551: PJI_PMV_TIME_DIM_TMP TIME
4552: , PJI_PMV_ORGZ_DIM_TMP HORG
4553: , PJI_PMV_ET_RT_DIM_TMP ET
4554: , PJI_FP_ORGO_ET_F_MV fct
4555: , PJI_PMV_ORG_DIM_TMP HOU
4556: WHERE
4582: , NULL AS CT_FORECAST_REVENUE
4583: , NULL AS CT_FORECAST_BURDENED_COST
4584: FROM
4585: PJI_PMV_TIME_DIM_TMP TIME
4586: , PJI_PMV_ORGZ_DIM_TMP HORG
4587: , PJI_PMV_ET_RT_DIM_TMP ET
4588: , PJI_FP_ORGO_ET_F_MV fct
4589: , PJI_PMV_ORG_DIM_TMP HOU
4590: WHERE
4619: , NULL AS CT_FORECAST_REVENUE
4620: , NULL AS CT_FORECAST_BURDENED_COST
4621: FROM
4622: PJI_PMV_TCMP_DIM_TMP TIME
4623: , PJI_PMV_ORGZ_DIM_TMP HORG
4624: , PJI_PMV_ET_RT_DIM_TMP ET
4625: , PJI_FP_ORGO_ET_F_MV fct
4626: , PJI_PMV_ORG_DIM_TMP HOU
4627: WHERE
4670: , 0 AS CT_REVENUE
4671: , 0 AS CT_BURDENED_COST
4672: , 0 AS CT_FORECAST_REVENUE
4673: , 0 AS CT_FORECAST_BURDENED_COST
4674: FROM PJI_PMV_ORGZ_DIM_TMP HORG
4675: WHERE HORG.NAME <> '-1'
4676: UNION ALL -- FORCE Creation of Expenditure Category/Type Rows
4677: SELECT '-1' AS ORG_ID
4678: , '-1' AS ORGANIZATION_ID
4751: , NULL AS CT_FORECAST_REVENUE
4752: , NULL AS CT_FORECAST_BURDENED_COST
4753: FROM
4754: PJI_PMV_TIME_DIM_TMP TIME
4755: , PJI_PMV_ORGZ_DIM_TMP HORG
4756: , PJI_PMV_WT_DIM_TMP WT
4757: , PJI_FP_ORGO_ET_WT_F_MV fct
4758: , PJI_PMV_ORG_DIM_TMP HOU
4759: WHERE
4784: , NULL AS CT_FORECAST_REVENUE
4785: , NULL AS CT_FORECAST_BURDENED_COST
4786: FROM
4787: PJI_PMV_TIME_DIM_TMP TIME
4788: , PJI_PMV_ORGZ_DIM_TMP HORG
4789: , PJI_PMV_WT_DIM_TMP WT
4790: , PJI_FP_ORGO_ET_WT_F_MV fct
4791: , PJI_PMV_ORG_DIM_TMP HOU
4792: WHERE
4820: , NULL AS CT_FORECAST_REVENUE
4821: , NULL AS CT_FORECAST_BURDENED_COST
4822: FROM
4823: PJI_PMV_TCMP_DIM_TMP TIME
4824: , PJI_PMV_ORGZ_DIM_TMP HORG
4825: , PJI_PMV_WT_DIM_TMP WT
4826: , PJI_FP_ORGO_ET_WT_F_MV fct
4827: , PJI_PMV_ORG_DIM_TMP HOU
4828: WHERE
4870: , 0 AS CT_REVENUE
4871: , 0 AS CT_BURDENED_COST
4872: , 0 AS CT_FORECAST_REVENUE
4873: , 0 AS CT_FORECAST_BURDENED_COST
4874: FROM PJI_PMV_ORGZ_DIM_TMP HORG
4875: WHERE HORG.NAME <> '-1'
4876: UNION ALL -- FORCE Creation of Work Type Rows
4877: SELECT '-1' AS ORG_ID
4878: , '-1' AS ORGANIZATION_ID
4949: , NULL AS CT_FORECAST_REVENUE
4950: , NULL AS CT_FORECAST_BURDENED_COST
4951: FROM
4952: PJI_PMV_TIME_DIM_TMP TIME
4953: , PJI_PMV_ORGZ_DIM_TMP HORG
4954: , PJI_PMV_CLS_DIM_TMP CLS
4955: , PJI_PMV_ET_RT_DIM_TMP ET
4956: , PJI_FP_CLSO_ET_F_MV fct
4957: , PJI_PMV_ORG_DIM_TMP HOU
4985: , NULL AS CT_FORECAST_REVENUE
4986: , NULL AS CT_FORECAST_BURDENED_COST
4987: FROM
4988: PJI_PMV_TIME_DIM_TMP TIME
4989: , PJI_PMV_ORGZ_DIM_TMP HORG
4990: , PJI_PMV_CLS_DIM_TMP CLS
4991: , PJI_PMV_ET_RT_DIM_TMP ET
4992: , PJI_FP_CLSO_ET_F_MV fct
4993: , PJI_PMV_ORG_DIM_TMP HOU
5024: , NULL AS CT_FORECAST_REVENUE
5025: , NULL AS CT_FORECAST_BURDENED_COST
5026: FROM
5027: PJI_PMV_TCMP_DIM_TMP TIME
5028: , PJI_PMV_ORGZ_DIM_TMP HORG
5029: , PJI_PMV_CLS_DIM_TMP CLS
5030: , PJI_PMV_ET_RT_DIM_TMP ET
5031: , PJI_FP_CLSO_ET_F_MV fct
5032: , PJI_PMV_ORG_DIM_TMP HOU
5077: , 0 AS CT_REVENUE
5078: , 0 AS CT_BURDENED_COST
5079: , 0 AS CT_FORECAST_REVENUE
5080: , 0 AS CT_FORECAST_BURDENED_COST
5081: FROM PJI_PMV_ORGZ_DIM_TMP HORG
5082: WHERE HORG.NAME <> '-1'
5083: UNION ALL -- FORCE Creation of Class/Code Rows
5084: SELECT '-1' AS ORG_ID
5085: , '-1' AS ORGANIZATION_ID
5176: , NULL AS CT_FORECAST_REVENUE
5177: , NULL AS CT_FORECAST_BURDENED_COST
5178: FROM
5179: PJI_PMV_TIME_DIM_TMP TIME
5180: , PJI_PMV_ORGZ_DIM_TMP HORG
5181: , PJI_PMV_ET_RT_DIM_TMP ET
5182: , PJI_PMV_WT_DIM_TMP WT
5183: , PJI_FP_ORGO_ET_WT_F_MV fct
5184: , PJI_PMV_ORG_DIM_TMP HOU
5212: , NULL AS CT_FORECAST_REVENUE
5213: , NULL AS CT_FORECAST_BURDENED_COST
5214: FROM
5215: PJI_PMV_TIME_DIM_TMP TIME
5216: , PJI_PMV_ORGZ_DIM_TMP HORG
5217: , PJI_PMV_ET_RT_DIM_TMP ET
5218: , PJI_PMV_WT_DIM_TMP WT
5219: , PJI_FP_ORGO_ET_WT_F_MV fct
5220: , PJI_PMV_ORG_DIM_TMP HOU
5251: , NULL AS CT_FORECAST_REVENUE
5252: , NULL AS CT_FORECAST_BURDENED_COST
5253: FROM
5254: PJI_PMV_TCMP_DIM_TMP TIME
5255: , PJI_PMV_ORGZ_DIM_TMP HORG
5256: , PJI_PMV_ET_RT_DIM_TMP ET
5257: , PJI_PMV_WT_DIM_TMP WT
5258: , PJI_FP_ORGO_ET_WT_F_MV fct
5259: , PJI_PMV_ORG_DIM_TMP HOU
5304: , 0 AS CT_REVENUE
5305: , 0 AS CT_BURDENED_COST
5306: , 0 AS CT_FORECAST_REVENUE
5307: , 0 AS CT_FORECAST_BURDENED_COST
5308: FROM PJI_PMV_ORGZ_DIM_TMP HORG
5309: WHERE HORG.NAME <> '-1'
5310: UNION ALL -- FORCE Creation of Expenditure Category/Type Rows
5311: SELECT '-1' AS ORG_ID
5312: , '-1' AS ORGANIZATION_ID
5405: , NULL AS CT_FORECAST_REVENUE
5406: , NULL AS CT_FORECAST_BURDENED_COST
5407: FROM
5408: PJI_PMV_TIME_DIM_TMP TIME
5409: , PJI_PMV_ORGZ_DIM_TMP HORG
5410: , PJI_PMV_CLS_DIM_TMP CLS
5411: , PJI_PMV_WT_DIM_TMP WT
5412: , PJI_FP_CLSO_ET_WT_F_MV fct
5413: , PJI_PMV_ORG_DIM_TMP HOU
5440: , NULL AS CT_FORECAST_REVENUE
5441: , NULL AS CT_FORECAST_BURDENED_COST
5442: FROM
5443: PJI_PMV_TIME_DIM_TMP TIME
5444: , PJI_PMV_ORGZ_DIM_TMP HORG
5445: , PJI_PMV_CLS_DIM_TMP CLS
5446: , PJI_PMV_WT_DIM_TMP WT
5447: , PJI_FP_CLSO_ET_WT_F_MV fct
5448: , PJI_PMV_ORG_DIM_TMP HOU
5478: , NULL AS CT_FORECAST_REVENUE
5479: , NULL AS CT_FORECAST_BURDENED_COST
5480: FROM
5481: PJI_PMV_TCMP_DIM_TMP TIME
5482: , PJI_PMV_ORGZ_DIM_TMP HORG
5483: , PJI_PMV_CLS_DIM_TMP CLS
5484: , PJI_PMV_WT_DIM_TMP WT
5485: , PJI_FP_CLSO_ET_WT_F_MV fct
5486: , PJI_PMV_ORG_DIM_TMP HOU
5530: , 0 AS CT_REVENUE
5531: , 0 AS CT_BURDENED_COST
5532: , 0 AS CT_FORECAST_REVENUE
5533: , 0 AS CT_FORECAST_BURDENED_COST
5534: FROM PJI_PMV_ORGZ_DIM_TMP HORG
5535: WHERE HORG.NAME <> '-1'
5536: UNION ALL -- FORCE Creation of Class/Code Rows
5537: SELECT '-1' AS ORG_ID
5538: , '-1' AS ORGANIZATION_ID
5629: , NULL AS CT_FORECAST_REVENUE
5630: , NULL AS CT_FORECAST_BURDENED_COST
5631: FROM
5632: PJI_PMV_TIME_DIM_TMP TIME
5633: , PJI_PMV_ORGZ_DIM_TMP HORG
5634: , PJI_PMV_CLS_DIM_TMP CLS
5635: , PJI_PMV_ET_RT_DIM_TMP ET
5636: , PJI_PMV_WT_DIM_TMP WT
5637: , PJI_FP_CLSO_ET_WT_F_MV fct
5667: , NULL AS CT_FORECAST_REVENUE
5668: , NULL AS CT_FORECAST_BURDENED_COST
5669: FROM
5670: PJI_PMV_TIME_DIM_TMP TIME
5671: , PJI_PMV_ORGZ_DIM_TMP HORG
5672: , PJI_PMV_CLS_DIM_TMP CLS
5673: , PJI_PMV_ET_RT_DIM_TMP ET
5674: , PJI_PMV_WT_DIM_TMP WT
5675: , PJI_FP_CLSO_ET_WT_F_MV fct
5708: , NULL AS CT_FORECAST_REVENUE
5709: , NULL AS CT_FORECAST_BURDENED_COST
5710: FROM
5711: PJI_PMV_TCMP_DIM_TMP TIME
5712: , PJI_PMV_ORGZ_DIM_TMP HORG
5713: , PJI_PMV_CLS_DIM_TMP CLS
5714: , PJI_PMV_ET_RT_DIM_TMP ET
5715: , PJI_PMV_WT_DIM_TMP WT
5716: , PJI_FP_CLSO_ET_WT_F_MV fct
5763: , 0 AS CT_REVENUE
5764: , 0 AS CT_BURDENED_COST
5765: , 0 AS CT_FORECAST_REVENUE
5766: , 0 AS CT_FORECAST_BURDENED_COST
5767: FROM PJI_PMV_ORGZ_DIM_TMP HORG
5768: WHERE HORG.NAME <> '-1'
5769: UNION ALL -- FORCE Creation of Class/Code Rows
5770: SELECT '-1' AS ORG_ID
5771: , '-1' AS ORGANIZATION_ID