[Home] [Help]
5662: -- Bug 3627315 : In case of Financial Structure, it should select normal(without BASE) columns from PJI table
5663: -- Anyhow it is baselined plan version
5664: -- SELECT decode(p_task_weight_method, 'EFFORT',nvl(BASE_LABOR_HOURS,0)+nvl(BASE_EQUIP_HOURS,0), PRJ_BASE_BRDN_COST)
5665: SELECT
5666: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5667: decode(p_task_weight_method, 'EFFORT',nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0), PRJ_BRDN_COST)
5668: INTO l_value
5669: FROM PJI_FM_XBS_ACCUM_TMP1
5670: WHERE project_id = p_project_id
5665: SELECT
5666: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5667: decode(p_task_weight_method, 'EFFORT',nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0), PRJ_BRDN_COST)
5668: INTO l_value
5669: FROM PJI_FM_XBS_ACCUM_TMP1
5670: WHERE project_id = p_project_id
5671: AND project_element_id = p_proj_element_id
5672: AND PLAN_VERSION_ID = l_plan_version_id
5673: AND txn_currency_code is null --bug no. 3646988
5689: nvl(BASE_EQUIP_HOURS,nvl(EQUIPMENT_HOURS,0)),
5690: NVL(PRJ_BASE_BRDN_COST,nvl(PRJ_BRDN_COST,0))) --if base is not avilable then select the published planned. bug 3781922*/
5691: -- Bug 4493105 : Added p_program_flag decode
5692: SELECT
5693: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5694: decode(p_task_weight_method, 'EFFORT', decode(p_program_flag, 'N', nvl(P_BASE_LBR_HOURS, nvl(P_LPB_LBR_HOURS, nvl(P_LBR_HOURS,0)))+
5695: nvl(P_BASE_EQP_HOURS, nvl(P_LPB_EQP_HOURS, nvl(P_EQP_HOURS,0))),
5696: nvl(BASE_LABOR_HOURS, nvl(LPB_LABOR_HOURS, nvl(LABOR_HOURS,0)))+
5697: nvl(BASE_EQUIP_HOURS, nvl(LPB_EQUIP_HOURS, nvl(EQUIPMENT_HOURS,0)))
5700: ,NVL(PRJ_BASE_BRDN_COST, nvl(PRJ_LPB_BRDN_COST, nvl(PRJ_BRDN_COST,0)))
5701: )
5702: ) --if base is not avilable then select the published planned. bug 3781922
5703: INTO l_value
5704: FROM PJI_FM_XBS_ACCUM_TMP1
5705: WHERE project_id = p_project_id
5706: AND struct_version_id = p_structure_version_id
5707: AND project_element_id = p_proj_element_id
5708: AND txn_currency_code is null --bug no. 3646988
5710:
5711: else
5712: -- Bug 4493105 : Added p_program_flag decode
5713: SELECT
5714: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5715: decode(p_task_weight_method, 'EFFORT',decode(p_program_flag,'N',nvl(P_LBR_HOURS,0)+nvl(P_EQP_HOURS,0)
5716: ,nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0))
5717: , decode(p_program_flag,'N',P_BRDN_COST,PRJ_BRDN_COST))
5718: INTO l_value
5715: decode(p_task_weight_method, 'EFFORT',decode(p_program_flag,'N',nvl(P_LBR_HOURS,0)+nvl(P_EQP_HOURS,0)
5716: ,nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0))
5717: , decode(p_program_flag,'N',P_BRDN_COST,PRJ_BRDN_COST))
5718: INTO l_value
5719: FROM PJI_FM_XBS_ACCUM_TMP1
5720: WHERE project_id = p_project_id
5721: AND struct_version_id = p_structure_version_id
5722: AND project_element_id = p_proj_element_id
5723: AND txn_currency_code is null --bug no. 3646988
6540: and pppa.structure_type = p_structure_type;
6541:
6542: cursor c2 (p_project_id NUMBER, p_proj_element_id NUMBER, p_structure_version_id NUMBER) is
6543: select
6544: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6545: nvl(pfxat.BASE_LABOR_HOURS,pfxat.labor_hours) labor_hours
6546: ,nvl(pfxat.BASE_EQUIP_HOURS,pfxat.equipment_hours) equipment_hours
6547: ,nvl(pfxat.PRJ_BASE_BRDN_COST,pfxat.prj_brdn_cost) prj_brdn_cost
6548: from pji_fm_xbs_accum_tmp1 pfxat
6544: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6545: nvl(pfxat.BASE_LABOR_HOURS,pfxat.labor_hours) labor_hours
6546: ,nvl(pfxat.BASE_EQUIP_HOURS,pfxat.equipment_hours) equipment_hours
6547: ,nvl(pfxat.PRJ_BASE_BRDN_COST,pfxat.prj_brdn_cost) prj_brdn_cost
6548: from pji_fm_xbs_accum_tmp1 pfxat
6549: where pfxat.struct_version_id = p_structure_version_id
6550: and pfxat.project_id = p_project_id
6551: and pfxat.project_element_id = p_proj_element_id
6552: and pfxat.plan_version_id > 0