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 PJI_PMV_TIME_DIM_TMP

Line 494: PJI_PMV_TIME_DIM_TMP time,

490: 0 prior_scheduled_hours,
491: 0 prior_resource_hours,
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

Line 619: FROM PJI_PMV_TIME_DIM_TMP

615: 0 prior_actual_hours,
616: 0 prior_scheduled_hours,
617: 0 prior_resource_hours,
618: 0 prior_total_resource_hours
619: FROM PJI_PMV_TIME_DIM_TMP
620: WHERE name <> '-1'
621: )
622: GROUP BY org_id,
623: organization_id,

Line 709: PJI_PMV_TIME_DIM_TMP time,

705: 0 prior_sch_util_hours,
706: 0 prior_actual_hours,
707: 0 prior_scheduled_hours
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,

Line 862: FROM PJI_PMV_TIME_DIM_TMP

858: 0 prior_billable_hours,
859: 0 prior_sch_util_hours,
860: 0 prior_actual_hours,
861: 0 prior_scheduled_hours
862: FROM PJI_PMV_TIME_DIM_TMP
863: WHERE name <> '-1'
864: UNION ALL -- added for current year capacity_hours
865: SELECT
866: FACT.org_id,

Line 910: PJI_PMV_TIME_DIM_TMP time,

906: reduce_capacity_hrs_a,
907: fct.reduce_capacity_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 1065: PJI_PMV_TIME_DIM_TMP time,

1061: 0 prior_sch_util_hours,
1062: 0 prior_actual_hours,
1063: 0 prior_scheduled_hours
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

Line 1206: FROM PJI_PMV_TIME_DIM_TMP

1202: 0 prior_billable_hours,
1203: 0 prior_sch_util_hours,
1204: 0 prior_actual_hours,
1205: 0 prior_scheduled_hours
1206: FROM PJI_PMV_TIME_DIM_TMP
1207: WHERE name <> '-1'
1208: )
1209: GROUP BY org_id,
1210: organization_id,

Line 1297: PJI_PMV_TIME_DIM_TMP time,

1293: -- 0 prior_sch_capacity_hours,
1294: 0 prior_actual_hours,
1295: 0 prior_scheduled_hours
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,

Line 1483: FROM PJI_PMV_TIME_DIM_TMP

1479: 0 prior_billable_hours,
1480: 0 prior_sch_util_hours,
1481: 0 prior_actual_hours,
1482: 0 prior_scheduled_hours
1483: FROM PJI_PMV_TIME_DIM_TMP
1484: WHERE name <> '-1'
1485: UNION ALL -- added for current year capacity_hours
1486: /* Bug 3515594 */
1487: SELECT

Line 1533: PJI_PMV_TIME_DIM_TMP time,

1529: reduce_capacity_hrs_a,
1530: reduce_capacity_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1531: reduce_capacity_hrs_s
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

Line 2018: PJI_PMV_TIME_DIM_TMP time,

2014: 0 prior_actual_util_hours,
2015: 0 prior_actual_capacity_hours,
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

Line 2054: PJI_PMV_TIME_DIM_TMP time,

2050: prior_actual_capacity_hours,
2051: total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 2084: FROM PJI_PMV_TIME_DIM_TMP

2080: 0 actual_hours,
2081: 0 prior_actual_util_hours,
2082: 0 prior_actual_capacity_hours,
2083: 0 prior_actual_hours
2084: FROM PJI_PMV_TIME_DIM_TMP
2085: WHERE name <> '-1'
2086: )
2087: GROUP BY org_id,
2088: organization_id,

Line 2259: PJI_PMV_TIME_DIM_TMP time,

2255: 0 prior_billable_hours,
2256: 0 prior_nonbillable_hours,
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

Line 2300: PJI_PMV_TIME_DIM_TMP time,

2296: prior_nonbillable_hours,
2297: training_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 2355: FROM PJI_PMV_TIME_DIM_TMP

2351: 0 prior_utilization_hours,
2352: 0 prior_billable_hours,
2353: 0 prior_nonbillable_hours,
2354: 0 prior_training_hours
2355: FROM PJI_PMV_TIME_DIM_TMP
2356: WHERE name <> '-1'
2357: )
2358: GROUP BY org_id,
2359: organization_id,

Line 2440: PJI_PMV_TIME_DIM_TMP time,

2436: 0 prior_billable_hours,
2437: 0 prior_nonbillable_hours,
2438: 0 prior_training_hours
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,

Line 2493: PJI_PMV_TIME_DIM_TMP time,

2489: fct.total_hrs_a
2490: ELSE 0 END) / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
2491: prior_training_hours
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,

Line 2587: FROM PJI_PMV_TIME_DIM_TMP

2583: 0 prior_utilization_hours,
2584: 0 prior_billable_hours,
2585: 0 prior_nonbillable_hours,
2586: 0 prior_training_hours
2587: FROM PJI_PMV_TIME_DIM_TMP
2588: WHERE name <> '-1'
2589: UNION ALL -- added for current year capacity_hours
2590: SELECT
2591: FACT.org_id,

Line 2632: PJI_PMV_TIME_DIM_TMP time,

2628: missing_hrs_a,
2629: fct.reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 2686: PJI_PMV_TIME_DIM_TMP time,

2682:
2683: fct.reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 2775: PJI_PMV_TIME_DIM_TMP time,

2771: 0 prior_billable_hours,
2772: 0 prior_nonbillable_hours,
2773: 0 prior_training_hours
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

Line 2819: PJI_PMV_TIME_DIM_TMP time,

2815: prior_nonbillable_hours,
2816: training_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
2817: prior_training_hours
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

Line 2905: FROM PJI_PMV_TIME_DIM_TMP

2901: 0 prior_utilization_hours,
2902: 0 prior_billable_hours,
2903: 0 prior_nonbillable_hours,
2904: 0 prior_training_hours
2905: FROM PJI_PMV_TIME_DIM_TMP
2906: WHERE name <> '-1'
2907: )
2908: GROUP BY org_id,
2909: organization_id,

Line 2987: PJI_PMV_TIME_DIM_TMP time,

2983: 0 prior_billable_hours,
2984: 0 prior_nonbillable_hours,
2985: 0 prior_training_hours
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,

Line 3042: PJI_PMV_TIME_DIM_TMP time,

3038: fct.total_hrs_a
3039: ELSE 0 END) / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
3040: prior_training_hours
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,

Line 3166: FROM PJI_PMV_TIME_DIM_TMP

3162: 0 prior_utilization_hours,
3163: 0 prior_billable_hours,
3164: 0 prior_nonbillable_hours,
3165: 0 prior_training_hours
3166: FROM PJI_PMV_TIME_DIM_TMP
3167: WHERE name <> '-1'
3168: UNION ALL -- added for current year capacity_hours
3169: SELECT
3170: FACT.org_id,

Line 3212: PJI_PMV_TIME_DIM_TMP time,

3208: missing_hrs_a,
3209: fct.reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
3210: reduce_capacity_hrs_a
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

Line 3268: PJI_PMV_TIME_DIM_TMP time,

3264: total_actual_hours,
3265: fct.reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
3266: reduce_capacity_hrs_a
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

Line 3713: PJI_PMV_TIME_DIM_TMP time,

3709: 0 prior_actual_capacity_hours,
3710: 0 prior_actual_util_hours,
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

Line 3775: PJI_PMV_TIME_DIM_TMP time,

3771: prior_actual_util_hours,
3772: total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 3868: FROM PJI_PMV_TIME_DIM_TMP

3864: 0 prior_conf_nonbillable_hours,
3865: 0 prior_actual_capacity_hours,
3866: 0 prior_actual_util_hours,
3867: 0 prior_actual_hours
3868: FROM PJI_PMV_TIME_DIM_TMP
3869: WHERE name <> '-1'
3870: )
3871: GROUP BY org_id,
3872: organization_id,

Line 4021: PJI_PMV_TIME_DIM_TMP time,

4017: 0 prior_conf_nonbillable_hours,
4018: 0 prior_actual_util_hours,
4019: 0 prior_actual_hours
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,

Line 4092: PJI_PMV_TIME_DIM_TMP time,

4088: worktype.org_utilization_percentage / 100 prior_actual_util_hours,
4089: fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
4090: prior_actual_hours
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,

Line 4240: FROM PJI_PMV_TIME_DIM_TMP

4236: 0 prior_conf_billable_hours,
4237: 0 prior_conf_nonbillable_hours,
4238: 0 prior_actual_util_hours,
4239: 0 prior_actual_hours
4240: FROM PJI_PMV_TIME_DIM_TMP
4241: WHERE name <> '-1'
4242: UNION ALL -- added for current year capacity_hours
4243: SELECT
4244: FACT.org_id,

Line 4312: PJI_PMV_TIME_DIM_TMP time,

4308: decode(time.amount_type, 1, fct.reduce_capacity_hrs_s, 0)
4309: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 4382: PJI_PMV_TIME_DIM_TMP time,

4378: total_actual_hours,
4379: fct.reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 4538: PJI_PMV_TIME_DIM_TMP time,

4534: 0 prior_conf_nonbillable_hours,
4535: 0 prior_actual_util_hours,
4536: 0 prior_actual_hours
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

Line 4601: PJI_PMV_TIME_DIM_TMP time,

4597: prior_actual_util_hours,
4598: total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
4599: prior_actual_hours
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

Line 4741: FROM PJI_PMV_TIME_DIM_TMP

4737: 0 prior_conf_billable_hours,
4738: 0 prior_conf_nonbillable_hours,
4739: 0 prior_actual_util_hours,
4740: 0 prior_actual_hours
4741: FROM PJI_PMV_TIME_DIM_TMP
4742: WHERE name <> '-1'
4743: )
4744: GROUP BY org_id,
4745: organization_id,

Line 4888: PJI_PMV_TIME_DIM_TMP time,

4884: 0 prior_conf_nonbillable_hours,
4885: 0 prior_actual_util_hours,
4886: 0 prior_actual_hours
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,

Line 4961: PJI_PMV_TIME_DIM_TMP time,

4957: worktype.org_utilization_percentage / 100 prior_actual_util_hours,
4958: total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
4959: prior_actual_hours
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,

Line 5156: FROM PJI_PMV_TIME_DIM_TMP

5152: 0 prior_conf_billable_hours,
5153: 0 prior_conf_nonbillable_hours,
5154: 0 prior_actual_util_hours,
5155: 0 prior_actual_hours
5156: FROM PJI_PMV_TIME_DIM_TMP
5157: WHERE name <> '-1'
5158: UNION ALL -- added for current year capacity_hours
5159: /* Bug 3515594 */
5160: SELECT

Line 5228: PJI_PMV_TIME_DIM_TMP time,

5224: decode(time.amount_type, 1, reduce_capacity_hrs_s,0)
5225: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
5226: exp_sch_red_capacity_hours
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

Line 5302: PJI_PMV_TIME_DIM_TMP time,

5298: total_actual_hours,
5299: fct.reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
5300: prior_red_capacity_hours
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

Line 5874: ,pji_pmv_time_dim_tmp time

5870: ,(fct.total_wtd_org_hrs_a-fct.bill_wtd_org_hrs_a)
5871: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) nonbillable_weighted_hours
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

Line 5959: ,pji_pmv_time_dim_tmp time

5955: ,(fct.total_wtd_org_hrs_a-fct.bill_wtd_org_hrs_a)
5956: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) nonbillable_weighted_hours
5957: FROM
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

Line 6051: ,pji_pmv_time_dim_tmp time

6047: *wtb.org_utilization_percentage/100 / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
6048: nonbillable_weighted_hours
6049: FROM
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

Line 6113: ,pji_pmv_time_dim_tmp time

6109: ,0 billable_weighted_hours
6110: ,0 nonbillable_weighted_hours
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

Line 6180: ,pji_pmv_time_dim_tmp time

6176: *wtb.org_utilization_percentage/100 / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
6177: nonbillable_weighted_hours
6178: FROM
6179: pji_pmv_orgz_dim_tmp horg
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

Line 6246: ,pji_pmv_time_dim_tmp time

6242: ,0 billable_weighted_hours
6243: ,0 nonbillable_weighted_hours
6244: FROM
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

Line 6519: ,pji_pmv_time_dim_tmp time

6515: ,fct.unassigned_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) unassigned_hours
6516: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) actual_hours
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

Line 6610: ,pji_pmv_time_dim_tmp time

6606: ,fct.unassigned_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) unassigned_hours
6607: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) actual_hours
6608: FROM
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

Line 6707: ,pji_pmv_time_dim_tmp time

6703: unassigned_hours
6704: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) actual_hours
6705: FROM
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

Line 6774: ,pji_pmv_time_dim_tmp time

6770: ,0 unassigned_hours
6771: ,0 actual_hours
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

Line 6844: ,pji_pmv_time_dim_tmp time

6840: unassigned_hours
6841: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) actual_hours
6842: FROM
6843: pji_pmv_orgz_dim_tmp horg
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

Line 6914: ,pji_pmv_time_dim_tmp time

6910: ,0 unassigned_hours
6911: ,0 actual_hours
6912: FROM
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

Line 7230: ,pji_pmv_time_dim_tmp time

7226: ,0 prior_capacity_hours
7227: ,0 prior_actual_hours
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

Line 7274: ,pji_pmv_time_dim_tmp time

7270: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
7271: prior_actual_hours
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

Line 7395: ,pji_pmv_time_dim_tmp time

7391: ,0 prior_capacity_hours
7392: ,0 prior_actual_hours
7393: FROM
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

Line 7440: ,pji_pmv_time_dim_tmp time

7436: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
7437: prior_actual_hours
7438: FROM
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

Line 7567: ,pji_pmv_time_dim_tmp time

7563: ,0 prior_red_capacity_hours
7564: ,0 prior_actual_hours
7565: FROM
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

Line 7615: ,pji_pmv_time_dim_tmp time

7611: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
7612: prior_actual_hours
7613: FROM
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

Line 7701: ,pji_pmv_time_dim_tmp time

7697: ,0 prior_red_capacity_hours
7698: ,0 prior_actual_hours
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

Line 7744: ,pji_pmv_time_dim_tmp time

7740: prior_red_capacity_hours
7741: ,0 prior_actual_hours
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

Line 7839: ,pji_pmv_time_dim_tmp time

7835: ,0 prior_red_capacity_hours
7836: ,0 prior_actual_hours
7837: FROM
7838: pji_pmv_orgz_dim_tmp horg
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

Line 7890: ,pji_pmv_time_dim_tmp time

7886: ,fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
7887: prior_actual_hours
7888: FROM
7889: pji_pmv_orgz_dim_tmp horg
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

Line 7979: ,pji_pmv_time_dim_tmp time

7975: ,0 prior_red_capacity_hours
7976: ,0 prior_actual_hours
7977: FROM
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

Line 8025: ,pji_pmv_time_dim_tmp time

8021: prior_red_capacity_hours
8022: ,0 prior_actual_hours
8023: FROM
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