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.

[Home] [Help]

APPS.PJI_PMV_UTLZ dependencies on PJI_PMV_WT_DIM_TMP

Line 710: PJI_PMV_WT_DIM_TMP wt,

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

Line 763: PJI_PMV_WT_DIM_TMP wt,

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

Line 833: FROM PJI_PMV_WT_DIM_TMP

829: 0 prior_billable_hours,
830: 0 prior_sch_util_hours,
831: 0 prior_actual_hours,
832: 0 prior_scheduled_hours
833: FROM PJI_PMV_WT_DIM_TMP
834: WHERE name <> '-1'
835: UNION ALL
836: SELECT '-1' org_id,
837: '-1' organization_id,

Line 922: FROM PJI_PMV_WT_DIM_TMP wt ) WT

918: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
919: AND time.id is not null
920: AND hou.id = imp.org_id ) FACT,
921: (SELECT distinct WT.name
922: FROM PJI_PMV_WT_DIM_TMP wt ) WT
923: UNION ALL -- added for prior year capacity_hours
924: /* Bug 3515594 */
925: SELECT
926: FACT.org_id,

Line 978: FROM PJI_PMV_WT_DIM_TMP wt ) WT

974: AND fct.period_type_id = time.period_type
975: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
976: AND hou.id = imp.org_id ) FACT,
977: (SELECT distinct WT.name
978: FROM PJI_PMV_WT_DIM_TMP wt ) WT
979: )
980: GROUP BY org_id,
981: organization_id,
982: time_id,

Line 1298: PJI_PMV_WT_DIM_TMP wt,

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

Line 1354: PJI_PMV_WT_DIM_TMP wt,

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

Line 1425: FROM PJI_PMV_WT_DIM_TMP

1421: 0 prior_billable_hours,
1422: 0 prior_sch_util_hours,
1423: 0 prior_actual_hours,
1424: 0 prior_scheduled_hours
1425: FROM PJI_PMV_WT_DIM_TMP
1426: WHERE name <> '-1'
1427: UNION ALL
1428: SELECT '-1' org_id,
1429: '-1' organization_id,

Line 1547: FROM PJI_PMV_WT_DIM_TMP wt ) WT

1543: AND fct.period_type_id = time.period_type
1544: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
1545: AND hou.id = imp.org_id ) FACT,
1546: (SELECT distinct WT.name
1547: FROM PJI_PMV_WT_DIM_TMP wt ) WT
1548: UNION ALL -- added for prior year capacity_hours
1549: /* Bug 3515594 */
1550: SELECT
1551: FACT.org_id,

Line 1608: FROM PJI_PMV_WT_DIM_TMP wt ) WT

1604: AND fct.period_type_id = time.period_type
1605: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
1606: AND hou.id = imp.org_id ) FACT,
1607: (SELECT distinct WT.name
1608: FROM PJI_PMV_WT_DIM_TMP wt ) WT
1609: )
1610: GROUP BY org_id,
1611: organization_id,
1612: time_id,

Line 2441: PJI_PMV_WT_DIM_TMP wt,

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

Line 2494: PJI_PMV_WT_DIM_TMP wt,

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

Line 2560: FROM PJI_PMV_WT_DIM_TMP

2556: 0 prior_utilization_hours,
2557: 0 prior_billable_hours,
2558: 0 prior_nonbillable_hours,
2559: 0 prior_training_hours
2560: FROM PJI_PMV_WT_DIM_TMP
2561: WHERE name <> '-1'
2562: UNION ALL
2563: SELECT '-1' org_id,
2564: '-1' organization_id,

Line 2644: FROM PJI_PMV_WT_DIM_TMP wt ) WT

2640: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
2641: AND time.id is not null
2642: AND hou.id = imp.org_id ) FACT,
2643: (SELECT distinct WT.name
2644: FROM PJI_PMV_WT_DIM_TMP wt ) WT
2645: UNION ALL -- added for prior year capacity_hours
2646: SELECT
2647: FACT.org_id,
2648: FACT.organization_id,

Line 2698: FROM PJI_PMV_WT_DIM_TMP wt ) WT

2694: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
2695: AND time.prior_id is not null
2696: AND hou.id = imp.org_id ) FACT,
2697: (SELECT distinct WT.name
2698: FROM PJI_PMV_WT_DIM_TMP wt ) WT
2699: )
2700: GROUP BY org_id,
2701: organization_id,
2702: time_id,

Line 2988: PJI_PMV_WT_DIM_TMP wt,

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

Line 3043: PJI_PMV_WT_DIM_TMP wt,

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

Line 3111: FROM PJI_PMV_WT_DIM_TMP

3107: 0 prior_utilization_hours,
3108: 0 prior_billable_hours,
3109: 0 prior_nonbillable_hours,
3110: 0 prior_training_hours
3111: FROM PJI_PMV_WT_DIM_TMP
3112: WHERE name <> '-1'
3113: UNION ALL
3114: SELECT '-1' org_id,
3115: '-1' organization_id,

Line 3226: FROM PJI_PMV_WT_DIM_TMP wt ) WT

3222: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
3223: AND time.id is not null
3224: AND hou.id = imp.org_id ) FACT,
3225: (SELECT distinct WT.name
3226: FROM PJI_PMV_WT_DIM_TMP wt ) WT
3227: UNION ALL -- added for prior year capacity_hours
3228: /* Bug 3515594 */
3229: SELECT
3230: FACT.org_id,

Line 3282: FROM PJI_PMV_WT_DIM_TMP wt ) WT

3278: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
3279: AND time.prior_id is not null
3280: AND hou.id = imp.org_id ) FACT,
3281: (SELECT distinct WT.name
3282: FROM PJI_PMV_WT_DIM_TMP wt ) WT
3283: )
3284: GROUP BY org_id,
3285: organization_id,
3286: time_id,

Line 4022: PJI_PMV_WT_DIM_TMP wt,

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

Line 4093: PJI_PMV_WT_DIM_TMP wt,

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

Line 4195: FROM PJI_PMV_WT_DIM_TMP

4191: 0 prior_conf_billable_hours,
4192: 0 prior_conf_nonbillable_hours,
4193: 0 prior_actual_util_hours,
4194: 0 prior_actual_hours
4195: FROM PJI_PMV_WT_DIM_TMP
4196: WHERE name <> '-1'
4197: UNION ALL
4198: SELECT '-1' org_id,
4199: '-1' organization_id,

Line 4324: FROM PJI_PMV_WT_DIM_TMP wt ) WT

4320: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
4321: AND time.id is not null
4322: AND hou.id = imp.org_id ) FACT,
4323: (SELECT distinct WT.name
4324: FROM PJI_PMV_WT_DIM_TMP wt ) WT
4325: UNION ALL -- added for prior year capacity_hours
4326: SELECT
4327: FACT.org_id,
4328: FACT.organization_id,

Line 4394: FROM PJI_PMV_WT_DIM_TMP wt ) WT

4390: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
4391: AND time.prior_id is not null
4392: AND hou.id = imp.org_id ) FACT,
4393: (SELECT distinct WT.name
4394: FROM PJI_PMV_WT_DIM_TMP wt ) WT
4395: )
4396: GROUP BY org_id,
4397: organization_id,
4398: time_id,

Line 4889: PJI_PMV_WT_DIM_TMP wt,

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

Line 4962: PJI_PMV_WT_DIM_TMP wt,

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

Line 5066: FROM PJI_PMV_WT_DIM_TMP

5062: 0 prior_conf_billable_hours,
5063: 0 prior_conf_nonbillable_hours,
5064: 0 prior_actual_util_hours,
5065: 0 prior_actual_hours
5066: FROM PJI_PMV_WT_DIM_TMP
5067: WHERE name <> '-1'
5068: UNION ALL
5069: SELECT '-1' org_id,
5070: '-1' organization_id,

Line 5242: FROM PJI_PMV_WT_DIM_TMP wt ) WT

5238: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
5239: AND time.id is not null
5240: AND hou.id = imp.org_id ) FACT,
5241: (SELECT distinct WT.name
5242: FROM PJI_PMV_WT_DIM_TMP wt ) WT
5243: UNION ALL -- added for prior year capacity_hours
5244: /* Bug 3515594 */
5245: SELECT
5246: FACT.org_id,

Line 5316: FROM PJI_PMV_WT_DIM_TMP wt ) WT

5312: AND fct.calendar_type = decode(fct.period_type_id,1, 'C',time.calendar_type)
5313: AND time.prior_id is not null
5314: AND hou.id = imp.org_id ) FACT,
5315: (SELECT distinct WT.name
5316: FROM PJI_PMV_WT_DIM_TMP wt ) WT
5317: )
5318: GROUP BY org_id,
5319: organization_id,
5320: time_id,

Line 6052: ,pji_pmv_wt_dim_tmp wt

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
6056: ,pa_resources_denorm resd

Line 6181: ,pji_pmv_wt_dim_tmp wt

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
6185: ,pa_work_types_b wtb

Line 6708: ,pji_pmv_wt_dim_tmp wt

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
6712: ,pa_resources_denorm resd

Line 6845: ,pji_pmv_wt_dim_tmp wt

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
6849: ,pa_work_types_b wtb

Line 7568: ,pji_pmv_wt_dim_tmp wt

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
7572: ,pa_resources_denorm resd

Line 7616: ,pji_pmv_wt_dim_tmp wt

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
7620: ,pa_resources_denorm resd

Line 7840: ,pji_pmv_wt_dim_tmp wt

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
7844: ,pa_work_types_b wtb

Line 7891: ,pji_pmv_wt_dim_tmp wt

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
7895: ,pa_work_types_b wtb