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:
1157: WHERE
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
1189: FCT.ORG_ID = HOU.ID
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:
1222: WHERE
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
1256: FCT.ORG_ID = HOU.ID
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
1289: FCT.ORG_ID = HOU.ID
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
1321: FCT.ORG_ID = HOU.ID
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
1710:
1711: WHERE
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
1745: WHERE
1746: FCT.PROJECT_ORG_ID = HOU.ID
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
1780:
1781: WHERE
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
1816: WHERE
1817: FCT.PROJECT_ORG_ID = HOU.ID
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
1851: WHERE
1852: FCT.PROJECT_ORG_ID = HOU.ID
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
1885: WHERE
1886: FCT.PROJECT_ORG_ID = HOU.ID
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
2003:
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
2037: WHERE
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
2073:
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
2109: WHERE
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
2142: WHERE
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
2174: WHERE
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
2573: , PJI_PMV_ORG_DIM_TMP HOU
2574:
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
2609: , PJI_PMV_ORG_DIM_TMP HOU
2610: WHERE
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
2646: , PJI_PMV_ORG_DIM_TMP HOU
2647:
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
2684: , PJI_PMV_ORG_DIM_TMP HOU
2685: WHERE
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
2719: , PJI_PMV_ORG_DIM_TMP HOU
2720: WHERE
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
2753: , PJI_PMV_ORG_DIM_TMP HOU
2754: WHERE
3464: , NULL AS FORECAST_REVENUE
3465: , NULL AS FORECAST_BURDENED_COST
3466: FROM PJI_PMV_TIME_DIM_TMP TIME
3467: , PJI_PMV_PRJ_DIM_TMP PRJ
3468: , PJI_PMV_ET_RT_DIM_TMP ET
3469: , PJI_FP_PROJ_ET_F FCT
3470: , PJI_PMV_ORG_DIM_TMP HOU
3471: WHERE 1=1
3472: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3584: , NULL AS FORECAST_REVENUE
3585: , NULL AS FORECAST_BURDENED_COST
3586: FROM PJI_PMV_TIME_DIM_TMP TIME
3587: , PJI_PMV_PRJ_DIM_TMP PRJ
3588: , PJI_PMV_ET_RT_DIM_TMP ET
3589: , PJI_FP_PROJ_ET_F FCT
3590: , PJI_PMV_ORG_DIM_TMP HOU
3591: WHERE 1=1
3592: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3645: , NULL AS FORECAST_REVENUE
3646: , NULL AS FORECAST_BURDENED_COST
3647: FROM PJI_PMV_TIME_DIM_TMP TIME
3648: , PJI_PMV_PRJ_DIM_TMP PRJ
3649: , PJI_PMV_ET_RT_DIM_TMP ET
3650: , PJI_PMV_WT_DIM_TMP WT
3651: , PJI_FP_PROJ_ET_WT_F FCT
3652: , PJI_PMV_ORG_DIM_TMP HOU
3653: WHERE 1=1
3765: , NULL AS FORECAST_REVENUE
3766: , NULL AS FORECAST_BURDENED_COST
3767: FROM PJI_PMV_TIME_DIM_TMP TIME
3768: , PJI_PMV_PRJ_DIM_TMP PRJ
3769: , PJI_PMV_ET_RT_DIM_TMP ET
3770: , PJI_PMV_WT_DIM_TMP WT
3771: , PJI_FP_PROJ_ET_WT_F FCT
3772: , PJI_PMV_ORG_DIM_TMP HOU
3773: WHERE 1=1
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
4557: fct.org_id = hou.id
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
4591: fct.org_id = hou.id
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
4628: fct.org_id = hou.id
4689: , 0 AS CT_REVENUE
4690: , 0 AS CT_BURDENED_COST
4691: , 0 AS CT_FORECAST_REVENUE
4692: , 0 AS CT_FORECAST_BURDENED_COST
4693: FROM PJI_PMV_ET_RT_DIM_TMP ET
4694: WHERE ET.NAME <> '-1'
4695: )
4696: WHERE 1 = 1
4697: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,EXPENDITURE_TYPE_ID,REVENUE_CATEGORY,
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
4958: WHERE
4959: fct.project_org_id = hou.id
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
4994: WHERE
4995: fct.project_org_id = hou.id
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
5033: WHERE
5034: fct.project_org_id = hou.id
5115: , 0 AS CT_REVENUE
5116: , 0 AS CT_BURDENED_COST
5117: , 0 AS CT_FORECAST_REVENUE
5118: , 0 AS CT_FORECAST_BURDENED_COST
5119: FROM PJI_PMV_ET_RT_DIM_TMP ET
5120: WHERE ET.NAME <> '-1'
5121:
5122: )
5123: WHERE 1 = 1
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
5185: WHERE
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
5221: WHERE
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
5260: WHERE
5323: , 0 AS CT_REVENUE
5324: , 0 AS CT_BURDENED_COST
5325: , 0 AS CT_FORECAST_REVENUE
5326: , 0 AS CT_FORECAST_BURDENED_COST
5327: FROM PJI_PMV_ET_RT_DIM_TMP ET
5328: WHERE ET.NAME <> '-1'
5329: UNION ALL -- FORCE Creation of Work Type Rows
5330: SELECT '-1' AS ORG_ID
5331: , '-1' AS ORGANIZATION_ID
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
5638: , PJI_PMV_ORG_DIM_TMP HOU
5639: WHERE
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
5676: , PJI_PMV_ORG_DIM_TMP HOU
5677: WHERE
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
5717: , PJI_PMV_ORG_DIM_TMP HOU
5718: WHERE
5801: , 0 AS CT_REVENUE
5802: , 0 AS CT_BURDENED_COST
5803: , 0 AS CT_FORECAST_REVENUE
5804: , 0 AS CT_FORECAST_BURDENED_COST
5805: FROM PJI_PMV_ET_RT_DIM_TMP ET
5806: WHERE ET.NAME <> '-1'
5807: UNION ALL -- FORCE Creation of Work Type Rows
5808: SELECT '-1' AS ORG_ID
5809: , '-1' AS ORGANIZATION_ID