[Home] [Help]
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
5880: fct.expenditure_org_id = hou.id
5881: AND fct.expenditure_organization_id = horg.id
5901: ,0 actual_weighted_hours
5902: ,0 billable_weighted_hours
5903: ,0 nonbillable_weighted_hours
5904: FROM
5905: pa_resources_denorm resd
5906: ,pji_pmv_orgz_dim_tmp horg
5907: WHERE
5908: resd.resource_organization_id = horg.id
5909: AND resd.utilization_flag = 'Y'
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
5966: fct.expenditure_org_id = hou.id
5967: AND fct.expenditure_organization_id = horg.id
5988: ,0 actual_weighted_hours
5989: ,0 billable_weighted_hours
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
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
6057: ,pa_implementations_all imp
6058: WHERE
6059: fct.expenditure_org_id = hou.id
6060: AND fct.expenditure_organization_id = horg.id
6083: ,0 actual_weighted_hours
6084: ,0 billable_weighted_hours
6085: ,0 nonbillable_weighted_hours
6086: FROM
6087: pa_resources_denorm resd
6088: ,pji_pmv_orgz_dim_tmp horg
6089: WHERE
6090: resd.resource_organization_id = horg.id
6091: AND resd.utilization_flag = 'Y'
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
6119: fct.expenditure_org_id = hou.id
6120: AND fct.expenditure_organization_id = horg.id
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
6188: WHERE
6189: fct.expenditure_org_id = hou.id
6190: AND fct.expenditure_organization_id = horg.id
6214: ,0 actual_weighted_hours
6215: ,0 billable_weighted_hours
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
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
6253: fct.expenditure_org_id = hou.id
6254: AND fct.expenditure_organization_id = horg.id
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
6525: fct.expenditure_org_id = hou.id
6526: AND fct.expenditure_organization_id = horg.id
6549: ,0 unassigned_hours
6550: ,0 actual_hours
6551: FROM
6552: pji_pmv_orgz_dim_tmp horg
6553: ,pa_resources_denorm resd
6554: WHERE
6555: resd.resource_organization_id = horg.id
6556: AND resd.utilization_flag = 'Y'
6557: AND TO_DATE(p_as_of_date,'j') between resd.resource_effective_start_date and
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
6617: fct.expenditure_org_id = hou.id
6618: AND fct.expenditure_organization_id = horg.id
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'
6651: AND resd.job_id = jbt.id
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
6713: ,pa_implementations_all imp
6714: WHERE
6715: fct.expenditure_org_id = hou.id
6716: AND fct.expenditure_organization_id = horg.id
6742: ,0 unassigned_hours
6743: ,0 actual_hours
6744: FROM
6745: pji_pmv_orgz_dim_tmp horg
6746: ,pa_resources_denorm resd
6747: WHERE
6748: resd.resource_organization_id = horg.id
6749: AND resd.utilization_flag = 'Y'
6750: AND TO_DATE(p_as_of_date,'j') between resd.resource_effective_start_date and
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
6780: fct.expenditure_org_id = hou.id
6781: AND fct.expenditure_organization_id = horg.id
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
6852: WHERE
6853: fct.expenditure_org_id = hou.id
6854: AND fct.expenditure_organization_id = horg.id
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'
6890: AND resd.job_id = jbt.id
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
6921: fct.expenditure_org_id = hou.id
6922: AND fct.expenditure_organization_id = horg.id
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
7236: fct.expenditure_org_id = hou.id
7237: AND fct.expenditure_organization_id = horg.id
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
7280: fct.expenditure_org_id = hou.id
7281: AND fct.expenditure_organization_id = horg.id
7310: ,0 prior_capacity_hours
7311: ,0 prior_actual_hours
7312: FROM
7313: pji_pmv_orgz_dim_tmp horg
7314: ,pa_resources_denorm resd
7315: WHERE
7316: resd.resource_organization_id = horg.id
7317: AND resd.utilization_flag = 'Y'
7318: AND TO_DATE(p_as_of_date,'j') between resd.resource_effective_start_date and
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
7402: fct.expenditure_org_id = hou.id
7403: AND fct.expenditure_organization_id = horg.id
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
7447: fct.expenditure_org_id = hou.id
7448: AND fct.expenditure_organization_id = horg.id
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'
7487: AND resd.job_id = jbt.id
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
7573: ,pa_implementations_all imp
7574: WHERE
7575: fct.expenditure_org_id = hou.id
7576: AND fct.expenditure_organization_id = horg.id
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
7621: ,pa_implementations_all imp
7622: WHERE
7623: fct.expenditure_org_id = hou.id
7624: AND fct.expenditure_organization_id = horg.id
7657: ,0 prior_red_capacity_hours
7658: ,0 prior_actual_hours
7659: FROM
7660: pji_pmv_orgz_dim_tmp horg
7661: ,pa_resources_denorm resd
7662: WHERE
7663: resd.resource_organization_id = horg.id
7664: AND resd.utilization_flag = 'Y'
7665: AND TO_DATE(p_as_of_date,'j') between resd.resource_effective_start_date and
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
7707: fct.expenditure_org_id = hou.id
7708: AND fct.expenditure_organization_id = horg.id
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
7750: fct.expenditure_org_id = hou.id
7751: AND fct.expenditure_organization_id = horg.id
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
7847: WHERE
7848: fct.expenditure_org_id = hou.id
7849: AND fct.expenditure_organization_id = horg.id
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
7898: WHERE
7899: fct.expenditure_org_id = hou.id
7900: AND fct.expenditure_organization_id = horg.id
7933: ,0 prior_capacity_hours
7934: ,0 prior_red_capacity_hours
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
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
7986: fct.expenditure_org_id = hou.id
7987: AND fct.expenditure_organization_id = horg.id
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
8032: fct.expenditure_org_id = hou.id
8033: AND fct.expenditure_organization_id = horg.id