DBA Data[Home] [Help]

APPS.PJI_PMV_UTLZ dependencies on PJI_PMV_TCMP_DIM_TMP

Line 551: PJI_PMV_TCMP_DIM_TMP time,

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
555: WHERE fct.expenditure_org_id = hou.id

Line 762: PJI_PMV_TCMP_DIM_TMP time,

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,
766: PA_WORK_TYPES_B worktype,

Line 967: PJI_PMV_TCMP_DIM_TMP time,

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
971: WHERE fct.expenditure_org_id = hou.id

Line 1112: PJI_PMV_TCMP_DIM_TMP time,

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,
1116: PA_IMPLEMENTATIONS_ALL imp

Line 1353: PJI_PMV_TCMP_DIM_TMP time,

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,
1357: PJI_PMV_JB_DIM_TMP job,

Line 1595: PJI_PMV_TCMP_DIM_TMP time,

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,
1599: PA_IMPLEMENTATIONS_ALL imp