[Home] [Help]
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,
714: PA_IMPLEMENTATIONS_ALL imp
715: WHERE fct.expenditure_org_id = hou.id
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,
766: PA_WORK_TYPES_B worktype,
767: PA_IMPLEMENTATIONS_ALL imp
768: WHERE fct.expenditure_org_id = hou.id
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,
2445: PA_IMPLEMENTATIONS_ALL imp
2446: WHERE fct.expenditure_org_id = hou.id
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,
2498: PA_IMPLEMENTATIONS_ALL imp
2499: WHERE fct.expenditure_org_id = hou.id
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,
4026: PA_IMPLEMENTATIONS_ALL imp
4027: WHERE fct.expenditure_org_id = hou.id
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,
4097: PA_IMPLEMENTATIONS_ALL imp
4098: WHERE fct.expenditure_org_id = hou.id