[Home] [Help]
1761: AND rbs_aggr_level = 'T'
1762: AND wbs_rollup_flag = 'Y'
1763: AND calendar_type = 'A'
1764: AND time_id = -1
1765: AND project_element_id = apps.pa_project_structure_utils.Get_fin_structure_id(f.project_id)
1766: AND plan_type_id IN (SELECT fin_plan_type_id
1767: FROM pa_fin_plan_types_b
1768: WHERE approved_cost_plan_type_flag = 'Y')
1769: AND f.currency_code = p.projfunc_currency_code
1806: AND rbs_aggr_level = 'T'
1807: AND wbs_rollup_flag = 'Y'
1808: AND calendar_type = 'A'
1809: AND time_id = -1
1810: AND project_element_id = apps.pa_project_structure_utils.Get_fin_structure_id(f.project_id)
1811: AND plan_type_id IN (SELECT fin_plan_type_id
1812: FROM pa_fin_plan_types_b
1813: WHERE approved_rev_plan_type_flag = 'Y')
1814: AND f.currency_code = p.projfunc_currency_code
1856: AND f.wbs_rollup_flag = 'Y'
1857: AND f.prg_rollup_flag = 'N'
1858: AND period_type_id = 2048
1859: AND time_id = -1
1860: AND project_element_id = pa_project_structure_utils.Get_fin_structure_id(f.project_id)
1861: AND p.template_flag = 'N'
1862: AND p.org_id = nvl(p_operating_unit, p.org_id )
1863: ) fact1
1864: WHERE p1.project_id = cdl1.project_id (+)
1883: WHERE plan_version_id IN (SELECT budget_version_id
1884: FROM pa_budget_versions bv
1885: WHERE bv.project_id = f.project_id
1886: AND project_structure_version_id =
1887: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(f.project_id))
1888: AND rbs_version_id = -1 AND time_id = -1
1889: AND rbs_aggr_level = 'T' AND wbs_rollup_flag = 'Y' AND prg_rollup_flag = 'N'
1890: AND bitand(curr_record_type_id,4) = 4
1891: AND project_element_id = (SELECT proj_element_id
1891: AND project_element_id = (SELECT proj_element_id
1892: from pa_proj_element_versions e
1893: where e.project_id = f.project_id
1894: and element_version_id =
1895: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(f.project_id))
1896: GROUP BY project_id) rep,
1897: (SELECT res.project_id project_id,
1898: Sum(Decode(res.resource_class_code,'PEOPLE',Nvl(init_quantity,0),0)) act_ppl_effort,
1899: Sum(Decode(res.resource_class_code,'EQUIPMENT',Nvl(init_quantity,0),0)) act_eq_effort,
1903: WHERE bl.budget_version_id IN (SELECT budget_version_id
1904: FROM pa_budget_versions bv
1905: WHERE bv.project_id = res.project_id
1906: AND project_structure_version_id =
1907: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(bv.project_id))
1908: AND bl.budget_version_id = res.budget_version_id
1909: AND bl.resource_assignment_id = res.resource_assignment_id
1910: GROUP BY res.project_id) base
1911: WHERE base.project_id = rep.project_id(+)
1936: AND plan_version_id = -3
1937: AND rbs_version_id = -1 AND time_id = -1
1938: AND rbs_aggr_level = 'T' AND wbs_rollup_flag = 'Y' AND prg_rollup_flag = 'N'
1939: AND bitand(curr_record_type_id,4) = 4
1940: AND project_element_id = pa_project_structure_utils.Get_fin_structure_id(f.project_id)
1941: GROUP BY project_id) rep,
1942: (SELECT res.project_id project_id,
1943: Sum(Decode(res.resource_class_code,'PEOPLE',Nvl(init_quantity,0),0)) act_ppl_effort,
1944: Sum(Decode(res.resource_class_code,'EQUIPMENT',Nvl(init_quantity,0),0)) act_eq_effort,