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_JB_DIM_TMP

Line 1066: PJI_PMV_JB_DIM_TMP job,

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

Line 1113: PJI_PMV_JB_DIM_TMP job,

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

Line 1178: FROM PJI_PMV_JB_DIM_TMP

1174: 0 prior_billable_hours,
1175: 0 prior_sch_util_hours,
1176: 0 prior_actual_hours,
1177: 0 prior_scheduled_hours
1178: FROM PJI_PMV_JB_DIM_TMP
1179: WHERE name <> '-1'
1180: UNION ALL
1181: SELECT '-1' org_id,
1182: '-1' organization_id,

Line 1301: PJI_PMV_JB_DIM_TMP job,

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,
1303: PA_IMPLEMENTATIONS_ALL imp
1304: WHERE fct.expenditure_org_id = hou.id
1305: AND fct.expenditure_organization_id = horg.id

Line 1357: PJI_PMV_JB_DIM_TMP job,

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,
1359: PA_IMPLEMENTATIONS_ALL imp
1360: WHERE fct.expenditure_org_id = hou.id
1361: AND fct.expenditure_organization_id = horg.id

Line 1454: FROM PJI_PMV_JB_DIM_TMP

1450: 0 prior_billable_hours,
1451: 0 prior_sch_util_hours,
1452: 0 prior_actual_hours,
1453: 0 prior_scheduled_hours
1454: FROM PJI_PMV_JB_DIM_TMP
1455: WHERE name <> '-1'
1456: UNION ALL
1457: SELECT '-1' org_id,
1458: '-1' organization_id,

Line 1534: PJI_PMV_JB_DIM_TMP job,

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

Line 1596: PJI_PMV_JB_DIM_TMP job,

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

Line 2776: PJI_PMV_JB_DIM_TMP job,

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

Line 2820: PJI_PMV_JB_DIM_TMP job,

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

Line 2880: FROM PJI_PMV_JB_DIM_TMP

2876: 0 prior_utilization_hours,
2877: 0 prior_billable_hours,
2878: 0 prior_nonbillable_hours,
2879: 0 prior_training_hours
2880: FROM PJI_PMV_JB_DIM_TMP
2881: WHERE name <> '-1'
2882: UNION ALL
2883: SELECT '-1' org_id,
2884: '-1' organization_id,

Line 2991: PJI_PMV_JB_DIM_TMP job,

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,
2993: PA_IMPLEMENTATIONS_ALL imp
2994: WHERE fct.expenditure_org_id = hou.id
2995: AND fct.expenditure_organization_id = horg.id

Line 3046: PJI_PMV_JB_DIM_TMP job,

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,
3048: PA_IMPLEMENTATIONS_ALL imp
3049: WHERE fct.expenditure_org_id = hou.id
3050: AND fct.expenditure_organization_id = horg.id

Line 3138: FROM PJI_PMV_JB_DIM_TMP

3134: 0 prior_utilization_hours,
3135: 0 prior_billable_hours,
3136: 0 prior_nonbillable_hours,
3137: 0 prior_training_hours
3138: FROM PJI_PMV_JB_DIM_TMP
3139: WHERE name <> '-1'
3140: UNION ALL
3141: SELECT '-1' org_id,
3142: '-1' organization_id,

Line 3213: PJI_PMV_JB_DIM_TMP job,

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

Line 3269: PJI_PMV_JB_DIM_TMP job,

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

Line 4539: PJI_PMV_JB_DIM_TMP job,

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

Line 4602: PJI_PMV_JB_DIM_TMP job,

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

Line 4698: FROM PJI_PMV_JB_DIM_TMP

4694: 0 prior_conf_billable_hours,
4695: 0 prior_conf_nonbillable_hours,
4696: 0 prior_actual_util_hours,
4697: 0 prior_actual_hours
4698: FROM PJI_PMV_JB_DIM_TMP
4699: WHERE name <> '-1'
4700: UNION ALL
4701: SELECT '-1' org_id,
4702: '-1' organization_id,

Line 4892: PJI_PMV_JB_DIM_TMP job,

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,
4894: PA_IMPLEMENTATIONS_ALL imp
4895: WHERE fct.expenditure_org_id = hou.id
4896: AND fct.expenditure_organization_id = horg.id

Line 4965: PJI_PMV_JB_DIM_TMP job,

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,
4967: PA_IMPLEMENTATIONS_ALL imp
4968: WHERE fct.expenditure_org_id = hou.id
4969: AND fct.expenditure_organization_id = horg.id

Line 5111: FROM PJI_PMV_JB_DIM_TMP

5107: 0 prior_conf_billable_hours,
5108: 0 prior_conf_nonbillable_hours,
5109: 0 prior_actual_util_hours,
5110: 0 prior_actual_hours
5111: FROM PJI_PMV_JB_DIM_TMP
5112: WHERE name <> '-1'
5113: UNION ALL
5114: SELECT '-1' org_id,
5115: '-1' organization_id,

Line 5229: PJI_PMV_JB_DIM_TMP job,

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

Line 5303: PJI_PMV_JB_DIM_TMP job,

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

Line 5960: ,pji_pmv_jb_dim_tmp jbt

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
5964: ,pa_implementations_all imp

Line 5994: ,pji_pmv_jb_dim_tmp jbt

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'
5998: AND resd.job_id = jbt.id

Line 6183: ,pji_pmv_jb_dim_tmp jbt

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
6186: ,pa_resources_denorm resd
6187: ,pa_implementations_all imp

Line 6220: ,pji_pmv_jb_dim_tmp jbt

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'
6224: AND resd.job_id = jbt.id

Line 6247: ,pji_pmv_jb_dim_tmp jbt

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
6251: ,pa_implementations_all imp

Line 6611: ,pji_pmv_jb_dim_tmp jbt

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
6615: ,pa_implementations_all imp

Line 6646: ,pji_pmv_jb_dim_tmp jbt

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
6650: AND resd.utilization_flag = 'Y'

Line 6847: ,pji_pmv_jb_dim_tmp jbt

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
6850: ,pa_resources_denorm resd
6851: ,pa_implementations_all imp

Line 6885: ,pji_pmv_jb_dim_tmp jbt

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
6889: AND resd.utilization_flag = 'Y'

Line 6915: ,pji_pmv_jb_dim_tmp jbt

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
6919: ,pa_implementations_all imp

Line 7396: ,pji_pmv_jb_dim_tmp jbt

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
7400: ,pa_implementations_all imp

Line 7441: ,pji_pmv_jb_dim_tmp jbt

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
7445: ,pa_implementations_all imp

Line 7482: ,pji_pmv_jb_dim_tmp jbt

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
7486: AND resd.utilization_flag = 'Y'

Line 7842: ,pji_pmv_jb_dim_tmp jbt

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
7845: ,pa_resources_denorm resd
7846: ,pa_implementations_all imp

Line 7893: ,pji_pmv_jb_dim_tmp jbt

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
7896: ,pa_resources_denorm resd
7897: ,pa_implementations_all imp

Line 7939: ,pji_pmv_jb_dim_tmp jbt

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'
7943: AND resd.job_id = jbt.id

Line 7980: ,pji_pmv_jb_dim_tmp jbt

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
7984: ,pa_implementations_all imp

Line 8026: ,pji_pmv_jb_dim_tmp jbt

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
8030: ,pa_implementations_all imp