DBA Data[Home] [Help]

APPS.PJI_PMV_UTLZ dependencies on PJI_RM_RES_F

Line 5875: ,pji_rm_res_f fct

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
5878: ,pa_implementations_all imp
5879: WHERE

Line 5961: ,pji_rm_res_f fct

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
5965: WHERE

Line 6114: ,pji_rm_res_f fct

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
6117: ,pa_implementations_all imp
6118: WHERE

Line 6248: ,pji_rm_res_f fct

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
6252: WHERE

Line 6520: ,pji_rm_res_f fct

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
6523: ,pa_implementations_all imp
6524: WHERE

Line 6612: ,pji_rm_res_f fct

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
6616: WHERE

Line 6775: ,pji_rm_res_f fct

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
6778: ,pa_implementations_all imp
6779: WHERE

Line 6916: ,pji_rm_res_f fct

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
6920: WHERE

Line 7231: ,pji_rm_res_f fct

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
7234: ,pa_implementations_all imp
7235: WHERE

Line 7275: ,pji_rm_res_f fct

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
7278: ,pa_implementations_all imp
7279: WHERE

Line 7397: ,pji_rm_res_f fct

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
7401: WHERE

Line 7442: ,pji_rm_res_f fct

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
7446: WHERE

Line 7702: ,pji_rm_res_f fct

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
7705: ,pa_implementations_all imp
7706: WHERE

Line 7745: ,pji_rm_res_f fct

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
7748: ,pa_implementations_all imp
7749: WHERE

Line 7981: ,pji_rm_res_f fct

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
7985: WHERE

Line 8027: ,pji_rm_res_f fct

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
8031: WHERE