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_ORGZ_DIM_TMP

Line 493: FROM PJI_PMV_ORGZ_DIM_TMP horg,

489: 0 prior_actual_hours,
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

Line 550: FROM PJI_PMV_ORGZ_DIM_TMP horg,

546: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
547: prior_resource_hours,
548: capacity_hrs / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 589: FROM PJI_PMV_ORGZ_DIM_TMP

585: 0 prior_actual_hours,
586: 0 prior_scheduled_hours,
587: 0 prior_resource_hours,
588: 0 prior_total_resource_hours
589: FROM PJI_PMV_ORGZ_DIM_TMP
590: WHERE name <> '-1'
591: UNION ALL
592: SELECT '-1' org_id,
593: '-1' organization_id,

Line 708: FROM PJI_PMV_ORGZ_DIM_TMP horg,

704: 0 prior_billable_hours,
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,

Line 761: FROM PJI_PMV_ORGZ_DIM_TMP horg,

757: fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
758: prior_actual_hours,
759: fct.conf_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
760: prior_scheduled_hours
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,

Line 803: FROM PJI_PMV_ORGZ_DIM_TMP

799: 0 prior_billable_hours,
800: 0 prior_sch_util_hours,
801: 0 prior_actual_hours,
802: 0 prior_scheduled_hours
803: FROM PJI_PMV_ORGZ_DIM_TMP
804: WHERE name <> '-1'
805: UNION ALL
806: SELECT '-1' org_id,
807: '-1' organization_id,

Line 909: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 966: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 1064: FROM PJI_PMV_ORGZ_DIM_TMP horg,

1060: 0 prior_billable_hours,
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,

Line 1111: FROM PJI_PMV_ORGZ_DIM_TMP horg,

1107: total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1108: prior_actual_hours,
1109: conf_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1110: prior_scheduled_hours
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,

Line 1150: FROM PJI_PMV_ORGZ_DIM_TMP

1146: 0 prior_billable_hours,
1147: 0 prior_sch_util_hours,
1148: 0 prior_actual_hours,
1149: 0 prior_scheduled_hours
1150: FROM PJI_PMV_ORGZ_DIM_TMP
1151: WHERE name <> '-1'
1152: UNION ALL
1153: SELECT '-1' org_id,
1154: '-1' organization_id,

Line 1296: FROM PJI_PMV_ORGZ_DIM_TMP horg,

1292: 0 prior_sch_util_hours,
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,

Line 1352: FROM PJI_PMV_ORGZ_DIM_TMP horg,

1348: fct.total_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1349: prior_actual_hours,
1350: fct.conf_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1351: prior_scheduled_hours
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,

Line 1396: FROM PJI_PMV_ORGZ_DIM_TMP

1392: 0 prior_billable_hours,
1393: 0 prior_sch_util_hours,
1394: 0 prior_actual_hours,
1395: 0 prior_scheduled_hours
1396: FROM PJI_PMV_ORGZ_DIM_TMP
1397: WHERE name <> '-1'
1398: UNION ALL
1399: SELECT '-1' org_id,
1400: '-1' organization_id,

Line 1532: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 1594: FROM PJI_PMV_ORGZ_DIM_TMP horg,

1590: missing_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1591: missing_hrs_a,
1592: reduce_capacity_hrs_a / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
1593: prior_reduce_capacity_hrs_a
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,

Line 2017: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2013: actual_hours,
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

Line 2053: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 2258: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2254: 0 prior_utilization_hours,
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

Line 2299: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 2332: FROM PJI_PMV_ORGZ_DIM_TMP

2328: 0 prior_utilization_hours,
2329: 0 prior_billable_hours,
2330: 0 prior_nonbillable_hours,
2331: 0 prior_training_hours
2332: FROM PJI_PMV_ORGZ_DIM_TMP
2333: WHERE name <> '-1'
2334: UNION ALL
2335: SELECT '-1' org_id,
2336: '-1' organization_id,

Line 2439: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2435: 0 prior_utilization_hours,
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,

Line 2492: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2488: (CASE WHEN worktype.training_flag = 'Y' THEN
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,

Line 2533: FROM PJI_PMV_ORGZ_DIM_TMP

2529: 0 prior_utilization_hours,
2530: 0 prior_billable_hours,
2531: 0 prior_nonbillable_hours,
2532: 0 prior_training_hours
2533: FROM PJI_PMV_ORGZ_DIM_TMP
2534: WHERE name <> '-1'
2535: UNION ALL
2536: SELECT '-1' org_id,
2537: '-1' organization_id,

Line 2631: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 2685: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2681: total_actual_hours,
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

Line 2774: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2770: 0 prior_utilization_hours,
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,

Line 2818: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 2855: FROM PJI_PMV_ORGZ_DIM_TMP

2851: 0 prior_utilization_hours,
2852: 0 prior_billable_hours,
2853: 0 prior_nonbillable_hours,
2854: 0 prior_training_hours
2855: FROM PJI_PMV_ORGZ_DIM_TMP
2856: WHERE name <> '-1'
2857: UNION ALL
2858: SELECT '-1' org_id,
2859: '-1' organization_id,

Line 2986: FROM PJI_PMV_ORGZ_DIM_TMP horg,

2982: 0 prior_utilization_hours,
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,

Line 3041: FROM PJI_PMV_ORGZ_DIM_TMP horg,

3037: (CASE WHEN worktype.training_flag = 'Y' THEN
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,

Line 3084: FROM PJI_PMV_ORGZ_DIM_TMP

3080: 0 prior_utilization_hours,
3081: 0 prior_billable_hours,
3082: 0 prior_nonbillable_hours,
3083: 0 prior_training_hours
3084: FROM PJI_PMV_ORGZ_DIM_TMP
3085: WHERE name <> '-1'
3086: UNION ALL
3087: SELECT '-1' org_id,
3088: '-1' organization_id,

Line 3211: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 3267: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 3712: FROM PJI_PMV_ORGZ_DIM_TMP horg,

3708: 0 prior_conf_nonbillable_hours,
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

Line 3774: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 3826: FROM PJI_PMV_ORGZ_DIM_TMP

3822: 0 prior_conf_nonbillable_hours,
3823: 0 prior_actual_capacity_hours,
3824: 0 prior_actual_util_hours,
3825: 0 prior_actual_hours
3826: FROM PJI_PMV_ORGZ_DIM_TMP
3827: WHERE name <> '-1'
3828: UNION ALL
3829: SELECT '-1' org_id,
3830: '-1' organization_id,

Line 4020: FROM PJI_PMV_ORGZ_DIM_TMP horg,

4016: 0 prior_conf_billable_hours,
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,

Line 4091: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 4150: FROM PJI_PMV_ORGZ_DIM_TMP

4146: 0 prior_conf_billable_hours,
4147: 0 prior_conf_nonbillable_hours,
4148: 0 prior_actual_util_hours,
4149: 0 prior_actual_hours
4150: FROM PJI_PMV_ORGZ_DIM_TMP
4151: WHERE name <> '-1'
4152: UNION ALL
4153: SELECT '-1' org_id,
4154: '-1' organization_id,

Line 4311: FROM PJI_PMV_ORGZ_DIM_TMP horg,

4307: exp_ac_red_capacity_hours,
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

Line 4381: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 4537: FROM PJI_PMV_ORGZ_DIM_TMP horg,

4533: 0 prior_conf_billable_hours,
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,

Line 4600: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 4655: FROM PJI_PMV_ORGZ_DIM_TMP

4651: 0 prior_conf_billable_hours,
4652: 0 prior_conf_nonbillable_hours,
4653: 0 prior_actual_util_hours,
4654: 0 prior_actual_hours
4655: FROM PJI_PMV_ORGZ_DIM_TMP
4656: WHERE name <> '-1'
4657: UNION ALL
4658: SELECT '-1' org_id,
4659: '-1' organization_id,

Line 4887: FROM PJI_PMV_ORGZ_DIM_TMP horg,

4883: 0 prior_conf_billable_hours,
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,

Line 4960: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 5021: FROM PJI_PMV_ORGZ_DIM_TMP

5017: 0 prior_conf_billable_hours,
5018: 0 prior_conf_nonbillable_hours,
5019: 0 prior_actual_util_hours,
5020: 0 prior_actual_hours
5021: FROM PJI_PMV_ORGZ_DIM_TMP
5022: WHERE name <> '-1'
5023: UNION ALL
5024: SELECT '-1' org_id,
5025: '-1' organization_id,

Line 5227: FROM PJI_PMV_ORGZ_DIM_TMP horg,

5223: exp_ac_red_capacity_hours,
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,

Line 5301: FROM PJI_PMV_ORGZ_DIM_TMP horg,

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

Line 5873: pji_pmv_orgz_dim_tmp horg

5869: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) billable_weighted_hours
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

Line 5906: ,pji_pmv_orgz_dim_tmp horg

5902: ,0 billable_weighted_hours
5903: ,0 nonbillable_weighted_hours
5904: FROM
5905: pa_resources_denorm resd
5906: ,pji_pmv_orgz_dim_tmp horg
5907: WHERE
5908: resd.resource_organization_id = horg.id
5909: AND resd.utilization_flag = 'Y'
5910: AND TO_DATE(p_as_of_date,'j') between resd.resource_effective_start_date and

Line 5958: pji_pmv_orgz_dim_tmp horg

5954: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) billable_weighted_hours
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

Line 5993: ,pji_pmv_orgz_dim_tmp horg

5989: ,0 billable_weighted_hours
5990: ,0 nonbillable_weighted_hours
5991: FROM
5992: pa_resources_denorm resd
5993: ,pji_pmv_orgz_dim_tmp horg
5994: ,pji_pmv_jb_dim_tmp jbt
5995: WHERE
5996: resd.resource_organization_id = horg.id
5997: AND resd.utilization_flag = 'Y'

Line 6050: pji_pmv_orgz_dim_tmp horg

6046: ,(fct.total_hrs_a-fct.bill_hrs_a)
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

Line 6088: ,pji_pmv_orgz_dim_tmp horg

6084: ,0 billable_weighted_hours
6085: ,0 nonbillable_weighted_hours
6086: FROM
6087: pa_resources_denorm resd
6088: ,pji_pmv_orgz_dim_tmp horg
6089: WHERE
6090: resd.resource_organization_id = horg.id
6091: AND resd.utilization_flag = 'Y'
6092: AND TO_DATE(p_as_of_date,'j') between resd.resource_effective_start_date and

Line 6112: pji_pmv_orgz_dim_tmp horg

6108: ,0 actual_weighted_hours
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

Line 6179: pji_pmv_orgz_dim_tmp horg

6175: ,(fct.total_hrs_a - fct.bill_hrs_a)
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

Line 6219: ,pji_pmv_orgz_dim_tmp horg

6215: ,0 billable_weighted_hours
6216: ,0 nonbillable_weighted_hours
6217: FROM
6218: pa_resources_denorm resd
6219: ,pji_pmv_orgz_dim_tmp horg
6220: ,pji_pmv_jb_dim_tmp jbt
6221: WHERE
6222: resd.resource_organization_id = horg.id
6223: AND resd.utilization_flag = 'Y'

Line 6245: pji_pmv_orgz_dim_tmp horg

6241: ,0 actual_weighted_hours
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

Line 6518: pji_pmv_orgz_dim_tmp horg

6514: billable_conf_weighted_hours
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

Line 6552: pji_pmv_orgz_dim_tmp horg

6548: ,0 billable_conf_weighted_hours
6549: ,0 unassigned_hours
6550: ,0 actual_hours
6551: FROM
6552: pji_pmv_orgz_dim_tmp horg
6553: ,pa_resources_denorm resd
6554: WHERE
6555: resd.resource_organization_id = horg.id
6556: AND resd.utilization_flag = 'Y'

Line 6609: pji_pmv_orgz_dim_tmp horg

6605: billable_conf_weighted_hours
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

Line 6645: pji_pmv_orgz_dim_tmp horg

6641: ,0 billable_conf_weighted_hours
6642: ,0 unassigned_hours
6643: ,0 actual_hours
6644: FROM
6645: pji_pmv_orgz_dim_tmp horg
6646: ,pji_pmv_jb_dim_tmp jbt
6647: ,pa_resources_denorm resd
6648: WHERE
6649: resd.resource_organization_id = horg.id

Line 6706: pji_pmv_orgz_dim_tmp horg

6702: ,unassigned_hrs_s / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 6745: pji_pmv_orgz_dim_tmp horg

6741: ,0 billable_conf_weighted_hours
6742: ,0 unassigned_hours
6743: ,0 actual_hours
6744: FROM
6745: pji_pmv_orgz_dim_tmp horg
6746: ,pa_resources_denorm resd
6747: WHERE
6748: resd.resource_organization_id = horg.id
6749: AND resd.utilization_flag = 'Y'

Line 6773: pji_pmv_orgz_dim_tmp horg

6769: ,0 billable_conf_weighted_hours
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

Line 6843: pji_pmv_orgz_dim_tmp horg

6839: ,unassigned_hrs_s * decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1)
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

Line 6884: pji_pmv_orgz_dim_tmp horg

6880: ,0 billable_conf_weighted_hours
6881: ,0 unassigned_hours
6882: ,0 actual_hours
6883: FROM
6884: pji_pmv_orgz_dim_tmp horg
6885: ,pji_pmv_jb_dim_tmp jbt
6886: ,pa_resources_denorm resd
6887: WHERE
6888: resd.resource_organization_id = horg.id

Line 6913: pji_pmv_orgz_dim_tmp horg

6909: ,0 billable_conf_weighted_hours
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

Line 7229: pji_pmv_orgz_dim_tmp horg

7225: ,0 prior_actual_weighted_hours
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

Line 7273: pji_pmv_orgz_dim_tmp horg

7269: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) prior_capacity_hours
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

Line 7313: pji_pmv_orgz_dim_tmp horg

7309: ,0 prior_actual_weighted_hours
7310: ,0 prior_capacity_hours
7311: ,0 prior_actual_hours
7312: FROM
7313: pji_pmv_orgz_dim_tmp horg
7314: ,pa_resources_denorm resd
7315: WHERE
7316: resd.resource_organization_id = horg.id
7317: AND resd.utilization_flag = 'Y'

Line 7394: pji_pmv_orgz_dim_tmp horg

7390: ,0 prior_actual_weighted_hours
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

Line 7439: pji_pmv_orgz_dim_tmp horg

7435: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) prior_capacity_hours
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

Line 7481: pji_pmv_orgz_dim_tmp horg

7477: ,0 prior_actual_weighted_hours
7478: ,0 prior_capacity_hours
7479: ,0 prior_actual_hours
7480: FROM
7481: pji_pmv_orgz_dim_tmp horg
7482: ,pji_pmv_jb_dim_tmp jbt
7483: ,pa_resources_denorm resd
7484: WHERE
7485: resd.resource_organization_id = horg.id

Line 7566: pji_pmv_orgz_dim_tmp horg

7562: ,0 prior_capacity_hours
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

Line 7614: pji_pmv_orgz_dim_tmp horg

7610: ,0 prior_red_capacity_hours
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

Line 7660: pji_pmv_orgz_dim_tmp horg

7656: ,0 prior_capacity_hours
7657: ,0 prior_red_capacity_hours
7658: ,0 prior_actual_hours
7659: FROM
7660: pji_pmv_orgz_dim_tmp horg
7661: ,pa_resources_denorm resd
7662: WHERE
7663: resd.resource_organization_id = horg.id
7664: AND resd.utilization_flag = 'Y'

Line 7700: pji_pmv_orgz_dim_tmp horg

7696: ,0 prior_capacity_hours
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

Line 7743: pji_pmv_orgz_dim_tmp horg

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

Line 7838: pji_pmv_orgz_dim_tmp horg

7834: ,0 prior_capacity_hours
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

Line 7889: pji_pmv_orgz_dim_tmp horg

7885: / decode(l_labor_unit, 'DAYS', imp.FTE_DAY, 'WEEKS',imp.FTE_WEEK, 1) prior_red_capacity_hours
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

Line 7938: ,pji_pmv_orgz_dim_tmp horg

7934: ,0 prior_red_capacity_hours
7935: ,0 prior_actual_hours
7936: FROM
7937: pa_resources_denorm resd
7938: ,pji_pmv_orgz_dim_tmp horg
7939: ,pji_pmv_jb_dim_tmp jbt
7940: WHERE
7941: resd.resource_organization_id = horg.id
7942: AND resd.utilization_flag = 'Y'

Line 7978: pji_pmv_orgz_dim_tmp horg

7974: ,0 prior_capacity_hours
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

Line 8024: pji_pmv_orgz_dim_tmp horg

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