[Home] [Help]
492: 0 prior_total_resource_hours
493: FROM PJI_PMV_ORGZ_DIM_TMP horg,
494: PJI_PMV_TIME_DIM_TMP time,
495: PJI_RM_ORGO_F_MV fct,
496: PJI_PMV_ORG_DIM_TMP hou,
497: PA_IMPLEMENTATIONS_ALL imp
498: WHERE fct.expenditure_org_id = hou.id
499: AND fct.expenditure_organization_id = horg.id
500: AND fct.time_id = time.id
549: prior_total_resource_hours
550: FROM PJI_PMV_ORGZ_DIM_TMP horg,
551: PJI_PMV_TCMP_DIM_TMP time,
552: PJI_RM_ORGO_F_MV fct,
553: PJI_PMV_ORG_DIM_TMP hou,
554: PA_IMPLEMENTATIONS_ALL imp
555: WHERE fct.expenditure_org_id = hou.id
556: AND fct.expenditure_organization_id = horg.id
557: AND fct.time_id = time.id
708: FROM PJI_PMV_ORGZ_DIM_TMP horg,
709: PJI_PMV_TIME_DIM_TMP time,
710: PJI_PMV_WT_DIM_TMP wt,
711: PJI_RM_WTO_F_MV fct,
712: PJI_PMV_ORG_DIM_TMP hou,
713: PA_WORK_TYPES_B worktype,
714: PA_IMPLEMENTATIONS_ALL imp
715: WHERE fct.expenditure_org_id = hou.id
716: AND fct.expenditure_organization_id = horg.id
761: FROM PJI_PMV_ORGZ_DIM_TMP horg,
762: PJI_PMV_TCMP_DIM_TMP time,
763: PJI_PMV_WT_DIM_TMP wt,
764: PJI_RM_WTO_F_MV fct,
765: PJI_PMV_ORG_DIM_TMP hou,
766: PA_WORK_TYPES_B worktype,
767: PA_IMPLEMENTATIONS_ALL imp
768: WHERE fct.expenditure_org_id = hou.id
769: AND fct.expenditure_organization_id = horg.id
908: reduce_capacity_hrs_s
909: FROM PJI_PMV_ORGZ_DIM_TMP horg,
910: PJI_PMV_TIME_DIM_TMP time,
911: PJI_RM_ORGO_F_MV fct,
912: PJI_PMV_ORG_DIM_TMP hou,
913: PA_IMPLEMENTATIONS_ALL imp
914: WHERE fct.expenditure_org_id = hou.id
915: AND fct.expenditure_organization_id = horg.id
916: AND fct.time_id = time.id
965: reduce_capacity_hrs_a
966: FROM PJI_PMV_ORGZ_DIM_TMP horg,
967: PJI_PMV_TCMP_DIM_TMP time,
968: PJI_RM_ORGO_F_MV fct,
969: PJI_PMV_ORG_DIM_TMP hou,
970: PA_IMPLEMENTATIONS_ALL imp
971: WHERE fct.expenditure_org_id = hou.id
972: AND fct.expenditure_organization_id = horg.id
973: AND fct.time_id = time.id
1064: FROM PJI_PMV_ORGZ_DIM_TMP horg,
1065: PJI_PMV_TIME_DIM_TMP time,
1066: PJI_PMV_JB_DIM_TMP job,
1067: PJI_RM_JOBO_F_MV fct,
1068: PJI_PMV_ORG_DIM_TMP hou,
1069: PA_IMPLEMENTATIONS_ALL imp
1070: WHERE fct.expenditure_org_id = hou.id
1071: AND fct.expenditure_organization_id = horg.id
1072: AND fct.job_id = job.id
1111: FROM PJI_PMV_ORGZ_DIM_TMP horg,
1112: PJI_PMV_TCMP_DIM_TMP time,
1113: PJI_PMV_JB_DIM_TMP job,
1114: PJI_RM_JOBO_F_MV fct,
1115: PJI_PMV_ORG_DIM_TMP hou,
1116: PA_IMPLEMENTATIONS_ALL imp
1117: WHERE fct.expenditure_org_id = hou.id
1118: AND fct.expenditure_organization_id = horg.id
1119: AND fct.job_id = job.id
1296: FROM PJI_PMV_ORGZ_DIM_TMP horg,
1297: PJI_PMV_TIME_DIM_TMP time,
1298: PJI_PMV_WT_DIM_TMP wt,
1299: PJI_RM_RES_WT_F fct,
1300: PJI_PMV_ORG_DIM_TMP hou,
1301: PJI_PMV_JB_DIM_TMP job,
1302: PA_WORK_TYPES_B worktype,
1303: PA_IMPLEMENTATIONS_ALL imp
1304: WHERE fct.expenditure_org_id = hou.id
1352: FROM PJI_PMV_ORGZ_DIM_TMP horg,
1353: PJI_PMV_TCMP_DIM_TMP time,
1354: PJI_PMV_WT_DIM_TMP wt,
1355: PJI_RM_RES_WT_F fct,
1356: PJI_PMV_ORG_DIM_TMP hou,
1357: PJI_PMV_JB_DIM_TMP job,
1358: PA_WORK_TYPES_B worktype,
1359: PA_IMPLEMENTATIONS_ALL imp
1360: WHERE fct.expenditure_org_id = hou.id
1532: FROM PJI_PMV_ORGZ_DIM_TMP horg,
1533: PJI_PMV_TIME_DIM_TMP time,
1534: PJI_PMV_JB_DIM_TMP job,
1535: PJI_RM_JOB_F_MV fct,
1536: PJI_PMV_ORG_DIM_TMP hou,
1537: PA_IMPLEMENTATIONS_ALL imp
1538: WHERE fct.expenditure_org_id = hou.id
1539: AND fct.expenditure_organization_id = horg.id
1540: AND fct.time_id = time.id
1594: FROM PJI_PMV_ORGZ_DIM_TMP horg,
1595: PJI_PMV_TCMP_DIM_TMP time,
1596: PJI_PMV_JB_DIM_TMP job,
1597: PJI_RM_JOB_F_MV fct,
1598: PJI_PMV_ORG_DIM_TMP hou,
1599: PA_IMPLEMENTATIONS_ALL imp
1600: WHERE fct.expenditure_org_id = hou.id
1601: AND fct.expenditure_organization_id = horg.id
1602: AND fct.time_id = time.id
2016: 0 prior_actual_hours
2017: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2018: PJI_PMV_TIME_DIM_TMP time,
2019: PJI_RM_ORGO_F_MV fct,
2020: PJI_PMV_ORG_DIM_TMP hou,
2021: PA_IMPLEMENTATIONS_ALL imp
2022: WHERE fct.expenditure_org_id = hou.id
2023: AND fct.expenditure_organization_id = horg.id
2024: AND fct.time_id = time.id
2052: prior_actual_hours
2053: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2054: PJI_PMV_TIME_DIM_TMP time,
2055: PJI_RM_ORGO_F_MV fct,
2056: PJI_PMV_ORG_DIM_TMP hou,
2057: PA_IMPLEMENTATIONS_ALL imp
2058: WHERE fct.expenditure_org_id = hou.id
2059: AND fct.expenditure_organization_id = horg.id
2060: AND fct.time_id = time.prior_id
2257: 0 prior_training_hours
2258: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2259: PJI_PMV_TIME_DIM_TMP time,
2260: PJI_RM_ORGO_F_MV fct,
2261: PJI_PMV_ORG_DIM_TMP hou,
2262: PA_IMPLEMENTATIONS_ALL imp
2263: WHERE fct.expenditure_org_id = hou.id
2264: AND fct.expenditure_organization_id = horg.id
2265: AND fct.time_id = time.id
2298: prior_training_hours
2299: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2300: PJI_PMV_TIME_DIM_TMP time,
2301: PJI_RM_ORGO_F_MV fct,
2302: PJI_PMV_ORG_DIM_TMP hou,
2303: PA_IMPLEMENTATIONS_ALL imp
2304: WHERE fct.expenditure_org_id = hou.id
2305: AND fct.expenditure_organization_id = horg.id
2306: AND fct.time_id = time.prior_id
2439: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2440: PJI_PMV_TIME_DIM_TMP time,
2441: PJI_PMV_WT_DIM_TMP wt,
2442: PJI_RM_WTO_F_MV fct,
2443: PJI_PMV_ORG_DIM_TMP hou,
2444: PA_WORK_TYPES_B worktype,
2445: PA_IMPLEMENTATIONS_ALL imp
2446: WHERE fct.expenditure_org_id = hou.id
2447: AND fct.expenditure_organization_id = horg.id
2492: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2493: PJI_PMV_TIME_DIM_TMP time,
2494: PJI_PMV_WT_DIM_TMP wt,
2495: PJI_RM_WTO_F_MV fct,
2496: PJI_PMV_ORG_DIM_TMP hou,
2497: PA_WORK_TYPES_B worktype,
2498: PA_IMPLEMENTATIONS_ALL imp
2499: WHERE fct.expenditure_org_id = hou.id
2500: AND fct.expenditure_organization_id = horg.id
2630: reduce_capacity_hrs_a
2631: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2632: PJI_PMV_TIME_DIM_TMP time,
2633: PJI_RM_ORGO_F_MV fct,
2634: PJI_PMV_ORG_DIM_TMP hou,
2635: PA_IMPLEMENTATIONS_ALL imp
2636: WHERE fct.expenditure_org_id = hou.id
2637: AND fct.expenditure_organization_id = horg.id
2638: AND fct.time_id = time.id
2684: reduce_capacity_hrs_a
2685: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2686: PJI_PMV_TIME_DIM_TMP time,
2687: PJI_RM_ORGO_F_MV fct,
2688: PJI_PMV_ORG_DIM_TMP hou,
2689: PA_IMPLEMENTATIONS_ALL imp
2690: WHERE fct.expenditure_org_id = hou.id
2691: AND fct.expenditure_organization_id = horg.id
2692: AND fct.time_id = time.prior_id
2774: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2775: PJI_PMV_TIME_DIM_TMP time,
2776: PJI_PMV_JB_DIM_TMP job,
2777: PJI_RM_JOBO_F_MV fct,
2778: PJI_PMV_ORG_DIM_TMP hou,
2779: PA_IMPLEMENTATIONS_ALL imp
2780: WHERE fct.expenditure_org_id = hou.id
2781: AND fct.expenditure_organization_id = horg.id
2782: AND fct.job_id = job.id
2818: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2819: PJI_PMV_TIME_DIM_TMP time,
2820: PJI_PMV_JB_DIM_TMP job,
2821: PJI_RM_JOBO_F_MV fct,
2822: PJI_PMV_ORG_DIM_TMP hou,
2823: PA_IMPLEMENTATIONS_ALL imp
2824: WHERE fct.expenditure_org_id = hou.id
2825: AND fct.expenditure_organization_id = horg.id
2826: AND fct.job_id = job.id
2986: FROM PJI_PMV_ORGZ_DIM_TMP horg,
2987: PJI_PMV_TIME_DIM_TMP time,
2988: PJI_PMV_WT_DIM_TMP wt,
2989: PJI_RM_RES_WT_F fct,
2990: PJI_PMV_ORG_DIM_TMP hou,
2991: PJI_PMV_JB_DIM_TMP job,
2992: PA_WORK_TYPES_B worktype,
2993: PA_IMPLEMENTATIONS_ALL imp
2994: WHERE fct.expenditure_org_id = hou.id
3041: FROM PJI_PMV_ORGZ_DIM_TMP horg,
3042: PJI_PMV_TIME_DIM_TMP time,
3043: PJI_PMV_WT_DIM_TMP wt,
3044: PJI_RM_RES_WT_F fct,
3045: PJI_PMV_ORG_DIM_TMP hou,
3046: PJI_PMV_JB_DIM_TMP job,
3047: PA_WORK_TYPES_B worktype,
3048: PA_IMPLEMENTATIONS_ALL imp
3049: WHERE fct.expenditure_org_id = hou.id
3211: FROM PJI_PMV_ORGZ_DIM_TMP horg,
3212: PJI_PMV_TIME_DIM_TMP time,
3213: PJI_PMV_JB_DIM_TMP job,
3214: PJI_RM_JOB_F_MV fct,
3215: PJI_PMV_ORG_DIM_TMP hou,
3216: PA_IMPLEMENTATIONS_ALL imp
3217: WHERE fct.expenditure_org_id = hou.id
3218: AND fct.expenditure_organization_id = horg.id
3219: AND fct.time_id = time.id
3267: FROM PJI_PMV_ORGZ_DIM_TMP horg,
3268: PJI_PMV_TIME_DIM_TMP time,
3269: PJI_PMV_JB_DIM_TMP job,
3270: PJI_RM_JOB_F_MV fct,
3271: PJI_PMV_ORG_DIM_TMP hou,
3272: PA_IMPLEMENTATIONS_ALL imp
3273: WHERE fct.expenditure_org_id = hou.id
3274: AND fct.expenditure_organization_id = horg.id
3275: AND fct.time_id = time.prior_id
3711: 0 prior_actual_hours
3712: FROM PJI_PMV_ORGZ_DIM_TMP horg,
3713: PJI_PMV_TIME_DIM_TMP time,
3714: PJI_RM_ORGO_F_MV fct,
3715: PJI_PMV_ORG_DIM_TMP hou,
3716: PA_IMPLEMENTATIONS_ALL imp
3717: WHERE fct.expenditure_org_id = hou.id
3718: AND fct.expenditure_organization_id = horg.id
3719: AND fct.time_id = time.id
3773: prior_actual_hours
3774: FROM PJI_PMV_ORGZ_DIM_TMP horg,
3775: PJI_PMV_TIME_DIM_TMP time,
3776: PJI_RM_ORGO_F_MV fct,
3777: PJI_PMV_ORG_DIM_TMP hou,
3778: PA_IMPLEMENTATIONS_ALL imp
3779: WHERE fct.expenditure_org_id = hou.id
3780: AND fct.expenditure_organization_id = horg.id
3781: AND fct.time_id = time.prior_id
4020: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4021: PJI_PMV_TIME_DIM_TMP time,
4022: PJI_PMV_WT_DIM_TMP wt,
4023: PJI_RM_WTO_F_MV fct,
4024: PJI_PMV_ORG_DIM_TMP hou,
4025: PA_WORK_TYPES_B worktype,
4026: PA_IMPLEMENTATIONS_ALL imp
4027: WHERE fct.expenditure_org_id = hou.id
4028: AND fct.expenditure_organization_id = horg.id
4091: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4092: PJI_PMV_TIME_DIM_TMP time,
4093: PJI_PMV_WT_DIM_TMP wt,
4094: PJI_RM_WTO_F_MV fct,
4095: PJI_PMV_ORG_DIM_TMP hou,
4096: PA_WORK_TYPES_B worktype,
4097: PA_IMPLEMENTATIONS_ALL imp
4098: WHERE fct.expenditure_org_id = hou.id
4099: AND fct.expenditure_organization_id = horg.id
4310: exp_sch_red_capacity_hours
4311: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4312: PJI_PMV_TIME_DIM_TMP time,
4313: PJI_RM_ORGO_F_MV fct,
4314: PJI_PMV_ORG_DIM_TMP hou,
4315: PA_IMPLEMENTATIONS_ALL imp
4316: WHERE fct.expenditure_org_id = hou.id
4317: AND fct.expenditure_organization_id = horg.id
4318: AND fct.time_id = time.id
4380: prior_red_capacity_hours
4381: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4382: PJI_PMV_TIME_DIM_TMP time,
4383: PJI_RM_ORGO_F_MV fct,
4384: PJI_PMV_ORG_DIM_TMP hou,
4385: PA_IMPLEMENTATIONS_ALL imp
4386: WHERE fct.expenditure_org_id = hou.id
4387: AND fct.expenditure_organization_id = horg.id
4388: AND fct.time_id = time.prior_id
4537: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4538: PJI_PMV_TIME_DIM_TMP time,
4539: PJI_PMV_JB_DIM_TMP job,
4540: PJI_RM_JOBO_F_MV fct,
4541: PJI_PMV_ORG_DIM_TMP hou,
4542: PA_IMPLEMENTATIONS_ALL imp
4543: WHERE fct.expenditure_org_id = hou.id
4544: AND fct.expenditure_organization_id = horg.id
4545: AND fct.job_id = job.id
4600: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4601: PJI_PMV_TIME_DIM_TMP time,
4602: PJI_PMV_JB_DIM_TMP job,
4603: PJI_RM_JOBO_F_MV fct,
4604: PJI_PMV_ORG_DIM_TMP hou,
4605: PA_IMPLEMENTATIONS_ALL imp
4606: WHERE fct.expenditure_org_id = hou.id
4607: AND fct.expenditure_organization_id = horg.id
4608: AND fct.job_id = job.id
4887: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4888: PJI_PMV_TIME_DIM_TMP time,
4889: PJI_PMV_WT_DIM_TMP wt,
4890: PJI_RM_RES_WT_F fct,
4891: PJI_PMV_ORG_DIM_TMP hou,
4892: PJI_PMV_JB_DIM_TMP job,
4893: PA_WORK_TYPES_B worktype,
4894: PA_IMPLEMENTATIONS_ALL imp
4895: WHERE fct.expenditure_org_id = hou.id
4960: FROM PJI_PMV_ORGZ_DIM_TMP horg,
4961: PJI_PMV_TIME_DIM_TMP time,
4962: PJI_PMV_WT_DIM_TMP wt,
4963: PJI_RM_RES_WT_F fct,
4964: PJI_PMV_ORG_DIM_TMP hou,
4965: PJI_PMV_JB_DIM_TMP job,
4966: PA_WORK_TYPES_B worktype,
4967: PA_IMPLEMENTATIONS_ALL imp
4968: WHERE fct.expenditure_org_id = hou.id
5227: FROM PJI_PMV_ORGZ_DIM_TMP horg,
5228: PJI_PMV_TIME_DIM_TMP time,
5229: PJI_PMV_JB_DIM_TMP job,
5230: PJI_RM_JOB_F_MV fct,
5231: PJI_PMV_ORG_DIM_TMP hou,
5232: PA_IMPLEMENTATIONS_ALL imp
5233: WHERE fct.expenditure_org_id = hou.id
5234: AND fct.expenditure_organization_id = horg.id
5235: AND fct.time_id = time.id
5301: FROM PJI_PMV_ORGZ_DIM_TMP horg,
5302: PJI_PMV_TIME_DIM_TMP time,
5303: PJI_PMV_JB_DIM_TMP job,
5304: PJI_RM_JOB_F_MV fct,
5305: PJI_PMV_ORG_DIM_TMP hou,
5306: PA_IMPLEMENTATIONS_ALL imp
5307: WHERE fct.expenditure_org_id = hou.id
5308: AND fct.expenditure_organization_id = horg.id
5309: AND fct.time_id = time.prior_id
5872: FROM
5873: pji_pmv_orgz_dim_tmp horg
5874: ,pji_pmv_time_dim_tmp time
5875: ,pji_rm_res_f fct
5876: ,pji_pmv_org_dim_tmp hou
5877: ,pa_resources_denorm resd
5878: ,pa_implementations_all imp
5879: WHERE
5880: fct.expenditure_org_id = hou.id
5958: pji_pmv_orgz_dim_tmp horg
5959: ,pji_pmv_time_dim_tmp time
5960: ,pji_pmv_jb_dim_tmp jbt
5961: ,pji_rm_res_f fct
5962: ,pji_pmv_org_dim_tmp hou
5963: ,pa_resources_denorm resd
5964: ,pa_implementations_all imp
5965: WHERE
5966: fct.expenditure_org_id = hou.id
6050: pji_pmv_orgz_dim_tmp horg
6051: ,pji_pmv_time_dim_tmp time
6052: ,pji_pmv_wt_dim_tmp wt
6053: ,pji_rm_res_wt_f fct
6054: ,pji_pmv_org_dim_tmp hou
6055: ,pa_work_types_b wtb
6056: ,pa_resources_denorm resd
6057: ,pa_implementations_all imp
6058: WHERE
6111: FROM
6112: pji_pmv_orgz_dim_tmp horg
6113: ,pji_pmv_time_dim_tmp time
6114: ,pji_rm_res_f fct
6115: ,pji_pmv_org_dim_tmp hou
6116: ,pa_resources_denorm resd
6117: ,pa_implementations_all imp
6118: WHERE
6119: fct.expenditure_org_id = hou.id
6180: ,pji_pmv_time_dim_tmp time
6181: ,pji_pmv_wt_dim_tmp wt
6182: ,pji_rm_res_wt_f fct
6183: ,pji_pmv_jb_dim_tmp jbt
6184: ,pji_pmv_org_dim_tmp hou
6185: ,pa_work_types_b wtb
6186: ,pa_resources_denorm resd
6187: ,pa_implementations_all imp
6188: WHERE
6245: pji_pmv_orgz_dim_tmp horg
6246: ,pji_pmv_time_dim_tmp time
6247: ,pji_pmv_jb_dim_tmp jbt
6248: ,pji_rm_res_f fct
6249: ,pji_pmv_org_dim_tmp hou
6250: ,pa_resources_denorm resd
6251: ,pa_implementations_all imp
6252: WHERE
6253: fct.expenditure_org_id = hou.id
6517: FROM
6518: pji_pmv_orgz_dim_tmp horg
6519: ,pji_pmv_time_dim_tmp time
6520: ,pji_rm_res_f fct
6521: ,pji_pmv_org_dim_tmp hou
6522: ,pa_resources_denorm resd
6523: ,pa_implementations_all imp
6524: WHERE
6525: fct.expenditure_org_id = hou.id
6609: pji_pmv_orgz_dim_tmp horg
6610: ,pji_pmv_time_dim_tmp time
6611: ,pji_pmv_jb_dim_tmp jbt
6612: ,pji_rm_res_f fct
6613: ,pji_pmv_org_dim_tmp hou
6614: ,pa_resources_denorm resd
6615: ,pa_implementations_all imp
6616: WHERE
6617: fct.expenditure_org_id = hou.id
6706: pji_pmv_orgz_dim_tmp horg
6707: ,pji_pmv_time_dim_tmp time
6708: ,pji_pmv_wt_dim_tmp wt
6709: ,pji_rm_res_wt_f fct
6710: ,pji_pmv_org_dim_tmp hou
6711: ,pa_work_types_b wtb
6712: ,pa_resources_denorm resd
6713: ,pa_implementations_all imp
6714: WHERE
6772: FROM
6773: pji_pmv_orgz_dim_tmp horg
6774: ,pji_pmv_time_dim_tmp time
6775: ,pji_rm_res_f fct
6776: ,pji_pmv_org_dim_tmp hou
6777: ,pa_resources_denorm resd
6778: ,pa_implementations_all imp
6779: WHERE
6780: fct.expenditure_org_id = hou.id
6844: ,pji_pmv_time_dim_tmp time
6845: ,pji_pmv_wt_dim_tmp wt
6846: ,pji_rm_res_wt_f fct
6847: ,pji_pmv_jb_dim_tmp jbt
6848: ,pji_pmv_org_dim_tmp hou
6849: ,pa_work_types_b wtb
6850: ,pa_resources_denorm resd
6851: ,pa_implementations_all imp
6852: WHERE
6913: pji_pmv_orgz_dim_tmp horg
6914: ,pji_pmv_time_dim_tmp time
6915: ,pji_pmv_jb_dim_tmp jbt
6916: ,pji_rm_res_f fct
6917: ,pji_pmv_org_dim_tmp hou
6918: ,pa_resources_denorm resd
6919: ,pa_implementations_all imp
6920: WHERE
6921: fct.expenditure_org_id = hou.id
7228: FROM
7229: pji_pmv_orgz_dim_tmp horg
7230: ,pji_pmv_time_dim_tmp time
7231: ,pji_rm_res_f fct
7232: ,pji_pmv_org_dim_tmp hou
7233: ,pa_resources_denorm resd
7234: ,pa_implementations_all imp
7235: WHERE
7236: fct.expenditure_org_id = hou.id
7272: FROM
7273: pji_pmv_orgz_dim_tmp horg
7274: ,pji_pmv_time_dim_tmp time
7275: ,pji_rm_res_f fct
7276: ,pji_pmv_org_dim_tmp hou
7277: ,pa_resources_denorm resd
7278: ,pa_implementations_all imp
7279: WHERE
7280: fct.expenditure_org_id = hou.id
7394: pji_pmv_orgz_dim_tmp horg
7395: ,pji_pmv_time_dim_tmp time
7396: ,pji_pmv_jb_dim_tmp jbt
7397: ,pji_rm_res_f fct
7398: ,pji_pmv_org_dim_tmp hou
7399: ,pa_resources_denorm resd
7400: ,pa_implementations_all imp
7401: WHERE
7402: fct.expenditure_org_id = hou.id
7439: pji_pmv_orgz_dim_tmp horg
7440: ,pji_pmv_time_dim_tmp time
7441: ,pji_pmv_jb_dim_tmp jbt
7442: ,pji_rm_res_f fct
7443: ,pji_pmv_org_dim_tmp hou
7444: ,pa_resources_denorm resd
7445: ,pa_implementations_all imp
7446: WHERE
7447: fct.expenditure_org_id = hou.id
7566: pji_pmv_orgz_dim_tmp horg
7567: ,pji_pmv_time_dim_tmp time
7568: ,pji_pmv_wt_dim_tmp wt
7569: ,pji_rm_res_wt_f fct
7570: ,pji_pmv_org_dim_tmp hou
7571: ,pa_work_types_b wtb
7572: ,pa_resources_denorm resd
7573: ,pa_implementations_all imp
7574: WHERE
7614: pji_pmv_orgz_dim_tmp horg
7615: ,pji_pmv_time_dim_tmp time
7616: ,pji_pmv_wt_dim_tmp wt
7617: ,pji_rm_res_wt_f fct
7618: ,pji_pmv_org_dim_tmp hou
7619: ,pa_work_types_b wtb
7620: ,pa_resources_denorm resd
7621: ,pa_implementations_all imp
7622: WHERE
7699: FROM
7700: pji_pmv_orgz_dim_tmp horg
7701: ,pji_pmv_time_dim_tmp time
7702: ,pji_rm_res_f fct
7703: ,pji_pmv_org_dim_tmp hou
7704: ,pa_resources_denorm resd
7705: ,pa_implementations_all imp
7706: WHERE
7707: fct.expenditure_org_id = hou.id
7742: FROM
7743: pji_pmv_orgz_dim_tmp horg
7744: ,pji_pmv_time_dim_tmp time
7745: ,pji_rm_res_f fct
7746: ,pji_pmv_org_dim_tmp hou
7747: ,pa_resources_denorm resd
7748: ,pa_implementations_all imp
7749: WHERE
7750: fct.expenditure_org_id = hou.id
7839: ,pji_pmv_time_dim_tmp time
7840: ,pji_pmv_wt_dim_tmp wt
7841: ,pji_rm_res_wt_f fct
7842: ,pji_pmv_jb_dim_tmp jbt
7843: ,pji_pmv_org_dim_tmp hou
7844: ,pa_work_types_b wtb
7845: ,pa_resources_denorm resd
7846: ,pa_implementations_all imp
7847: WHERE
7890: ,pji_pmv_time_dim_tmp time
7891: ,pji_pmv_wt_dim_tmp wt
7892: ,pji_rm_res_wt_f fct
7893: ,pji_pmv_jb_dim_tmp jbt
7894: ,pji_pmv_org_dim_tmp hou
7895: ,pa_work_types_b wtb
7896: ,pa_resources_denorm resd
7897: ,pa_implementations_all imp
7898: WHERE
7978: pji_pmv_orgz_dim_tmp horg
7979: ,pji_pmv_time_dim_tmp time
7980: ,pji_pmv_jb_dim_tmp jbt
7981: ,pji_rm_res_f fct
7982: ,pji_pmv_org_dim_tmp hou
7983: ,pa_resources_denorm resd
7984: ,pa_implementations_all imp
7985: WHERE
7986: fct.expenditure_org_id = hou.id
8024: pji_pmv_orgz_dim_tmp horg
8025: ,pji_pmv_time_dim_tmp time
8026: ,pji_pmv_jb_dim_tmp jbt
8027: ,pji_rm_res_f fct
8028: ,pji_pmv_org_dim_tmp hou
8029: ,pa_resources_denorm resd
8030: ,pa_implementations_all imp
8031: WHERE
8032: fct.expenditure_org_id = hou.id