eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_UTLZ dependencies on PA_IMPLEMENTATIONS_ALL

Line 497: PA_IMPLEMENTATIONS_ALL imp

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
501: AND fct.period_type_id = time.period_type

Line 554: PA_IMPLEMENTATIONS_ALL imp

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
558: AND fct.period_type_id = time.period_type

Line 714: PA_IMPLEMENTATIONS_ALL imp

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
717: AND wt.id = worktype.work_type_id
718: AND fct.work_type_id = wt.id

Line 767: PA_IMPLEMENTATIONS_ALL imp

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
770: AND wt.id = worktype.work_type_id
771: AND fct.work_type_id = wt.id

Line 913: PA_IMPLEMENTATIONS_ALL imp

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
917: AND fct.period_type_id = time.period_type

Line 970: PA_IMPLEMENTATIONS_ALL imp

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
974: AND fct.period_type_id = time.period_type

Line 1069: PA_IMPLEMENTATIONS_ALL imp

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
1073: AND fct.time_id = time.id

Line 1116: PA_IMPLEMENTATIONS_ALL imp

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
1120: AND fct.time_id = time.id

Line 1303: PA_IMPLEMENTATIONS_ALL imp

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
1305: AND fct.expenditure_organization_id = horg.id
1306: AND wt.id = worktype.work_type_id
1307: AND fct.work_type_id = wt.id

Line 1359: PA_IMPLEMENTATIONS_ALL imp

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
1361: AND fct.expenditure_organization_id = horg.id
1362: AND wt.id = worktype.work_type_id
1363: AND fct.work_type_id = wt.id

Line 1537: PA_IMPLEMENTATIONS_ALL imp

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
1541: AND time.id is not null

Line 1599: PA_IMPLEMENTATIONS_ALL imp

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
1603: AND fct.job_id = job.id

Line 2021: PA_IMPLEMENTATIONS_ALL imp

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
2025: AND fct.period_type_id = time.period_type

Line 2057: PA_IMPLEMENTATIONS_ALL imp

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
2061: AND fct.period_type_id = time.period_type

Line 2262: PA_IMPLEMENTATIONS_ALL imp

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
2266: AND fct.period_type_id = time.period_type

Line 2303: PA_IMPLEMENTATIONS_ALL imp

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
2307: AND fct.period_type_id = time.period_type

Line 2445: PA_IMPLEMENTATIONS_ALL imp

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
2448: AND wt.id = worktype.work_type_id
2449: AND fct.work_type_id = wt.id

Line 2498: PA_IMPLEMENTATIONS_ALL imp

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
2501: AND wt.id = worktype.work_type_id
2502: AND fct.work_type_id = wt.id

Line 2635: PA_IMPLEMENTATIONS_ALL imp

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
2639: AND fct.period_type_id = time.period_type

Line 2689: PA_IMPLEMENTATIONS_ALL imp

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
2693: AND fct.period_type_id = time.period_type

Line 2779: PA_IMPLEMENTATIONS_ALL imp

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
2783: AND fct.time_id = time.id

Line 2823: PA_IMPLEMENTATIONS_ALL imp

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
2827: AND fct.time_id = time.prior_id

Line 2993: PA_IMPLEMENTATIONS_ALL imp

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
2995: AND fct.expenditure_organization_id = horg.id
2996: AND wt.id = worktype.work_type_id
2997: AND fct.work_type_id = wt.id

Line 3048: PA_IMPLEMENTATIONS_ALL imp

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
3050: AND fct.expenditure_organization_id = horg.id
3051: AND wt.id = worktype.work_type_id
3052: AND fct.work_type_id = wt.id

Line 3216: PA_IMPLEMENTATIONS_ALL imp

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
3220: AND fct.period_type_id = time.period_type

Line 3272: PA_IMPLEMENTATIONS_ALL imp

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
3276: AND fct.period_type_id = time.period_type

Line 3716: PA_IMPLEMENTATIONS_ALL imp

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
3720: AND fct.period_type_id = time.period_type

Line 3778: PA_IMPLEMENTATIONS_ALL imp

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
3782: AND fct.period_type_id = time.period_type

Line 4026: PA_IMPLEMENTATIONS_ALL imp

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
4029: AND fct.work_type_id = wt.id
4030: AND wt.id = worktype.work_type_id

Line 4097: PA_IMPLEMENTATIONS_ALL imp

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
4100: AND fct.work_type_id = wt.id
4101: AND wt.id = worktype.work_type_id

Line 4315: PA_IMPLEMENTATIONS_ALL imp

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
4319: AND fct.period_type_id = time.period_type

Line 4385: PA_IMPLEMENTATIONS_ALL imp

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
4389: AND fct.period_type_id = time.period_type

Line 4542: PA_IMPLEMENTATIONS_ALL imp

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
4546: AND fct.time_id = time.id

Line 4605: PA_IMPLEMENTATIONS_ALL imp

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
4609: AND fct.time_id = time.prior_id

Line 4894: PA_IMPLEMENTATIONS_ALL imp

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
4896: AND fct.expenditure_organization_id = horg.id
4897: AND fct.work_type_id = wt.id
4898: AND wt.id = worktype.work_type_id

Line 4967: PA_IMPLEMENTATIONS_ALL imp

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
4969: AND fct.expenditure_organization_id = horg.id
4970: AND fct.work_type_id = wt.id
4971: AND wt.id = worktype.work_type_id

Line 5232: PA_IMPLEMENTATIONS_ALL imp

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
5236: AND fct.period_type_id = time.period_type

Line 5306: PA_IMPLEMENTATIONS_ALL imp

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
5310: AND fct.period_type_id = time.period_type

Line 5878: ,pa_implementations_all imp

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
5881: AND fct.expenditure_organization_id = horg.id
5882: AND fct.time_id = time.id

Line 5964: ,pa_implementations_all imp

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
5967: AND fct.expenditure_organization_id = horg.id
5968: AND fct.time_id = time.id

Line 6057: ,pa_implementations_all imp

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
6059: fct.expenditure_org_id = hou.id
6060: AND fct.expenditure_organization_id = horg.id
6061: AND fct.time_id = time.id

Line 6117: ,pa_implementations_all imp

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
6120: AND fct.expenditure_organization_id = horg.id
6121: AND fct.time_id = time.id

Line 6187: ,pa_implementations_all imp

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
6189: fct.expenditure_org_id = hou.id
6190: AND fct.expenditure_organization_id = horg.id
6191: AND fct.time_id = time.id

Line 6251: ,pa_implementations_all imp

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
6254: AND fct.expenditure_organization_id = horg.id
6255: AND fct.time_id = time.id

Line 6523: ,pa_implementations_all imp

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
6526: AND fct.expenditure_organization_id = horg.id
6527: AND fct.time_id = time.id

Line 6615: ,pa_implementations_all imp

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
6618: AND fct.expenditure_organization_id = horg.id
6619: AND fct.time_id = time.id

Line 6713: ,pa_implementations_all imp

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
6715: fct.expenditure_org_id = hou.id
6716: AND fct.expenditure_organization_id = horg.id
6717: AND fct.time_id = time.id

Line 6778: ,pa_implementations_all imp

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
6781: AND fct.expenditure_organization_id = horg.id
6782: AND fct.time_id = time.id

Line 6851: ,pa_implementations_all imp

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
6853: fct.expenditure_org_id = hou.id
6854: AND fct.expenditure_organization_id = horg.id
6855: AND fct.time_id = time.id

Line 6919: ,pa_implementations_all imp

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
6922: AND fct.expenditure_organization_id = horg.id
6923: AND fct.time_id = time.id

Line 7234: ,pa_implementations_all imp

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
7237: AND fct.expenditure_organization_id = horg.id
7238: AND fct.time_id = time.id

Line 7278: ,pa_implementations_all imp

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
7281: AND fct.expenditure_organization_id = horg.id
7282: AND fct.time_id = time.prior_id

Line 7400: ,pa_implementations_all imp

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
7403: AND fct.expenditure_organization_id = horg.id
7404: AND fct.time_id = time.id

Line 7445: ,pa_implementations_all imp

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
7448: AND fct.expenditure_organization_id = horg.id
7449: AND fct.time_id = time.prior_id

Line 7573: ,pa_implementations_all imp

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
7575: fct.expenditure_org_id = hou.id
7576: AND fct.expenditure_organization_id = horg.id
7577: AND fct.time_id = time.id

Line 7621: ,pa_implementations_all imp

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
7623: fct.expenditure_org_id = hou.id
7624: AND fct.expenditure_organization_id = horg.id
7625: AND fct.time_id = time.prior_id

Line 7705: ,pa_implementations_all imp

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
7708: AND fct.expenditure_organization_id = horg.id
7709: AND fct.time_id = time.id

Line 7748: ,pa_implementations_all imp

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
7751: AND fct.expenditure_organization_id = horg.id
7752: AND fct.time_id = time.prior_id

Line 7846: ,pa_implementations_all imp

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
7848: fct.expenditure_org_id = hou.id
7849: AND fct.expenditure_organization_id = horg.id
7850: AND fct.time_id = time.id

Line 7897: ,pa_implementations_all imp

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
7899: fct.expenditure_org_id = hou.id
7900: AND fct.expenditure_organization_id = horg.id
7901: AND fct.time_id = time.prior_id

Line 7984: ,pa_implementations_all imp

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
7987: AND fct.expenditure_organization_id = horg.id
7988: AND fct.time_id = time.id

Line 8030: ,pa_implementations_all imp

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
8033: AND fct.expenditure_organization_id = horg.id
8034: AND fct.time_id = time.prior_id