[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select (NVL(PPRU.ppl_act_effort_to_date,0) + NVL(ppru.eqpmt_act_effort_to_date,0)) -
-- (NVL(pfxat.labor_hours, 0) + NVL(pfxat.equipment_hours, 0))
(NVL(pxpv.labor_effort,0) + NVL(pxpv.equipment_effort,0))
from pji_xbs_plans_v pxpv,
-- from pji_fm_xbs_accum_tmp1 pfxat,
pa_progress_rollup ppru,
pa_proj_element_versions ppev
where ppev.element_version_id = c_wp_ver_id
and ppev.project_id = ppru.project_id
and ppev.proj_element_id = ppru.object_id
and ppev.object_type = ppru.object_type
and ppru.structure_type = 'WORKPLAN'
and ppev.project_id = pxpv.project_id
and ppev.proj_element_id = pxpv.proj_element_id
and ppev.element_version_id = pxpv.structure_version_id
and pxpv.structure_type(+) = 'WORKPLAN'
-- and ppev.project_id = pfxat.project_id
-- and ppev.proj_element_id = pfxat.project_element_id
-- and ppev.element_version_id = pfxat.struct_version_id
-- and pfxat.calendar_type (+) = 'A'
order by ppru.as_of_date desc;
select (NVL(ppru.estimated_remaining_effort,0) +
NVL(ppru.eqpmt_etc_effort,0) +
NVL(ppru.PPL_ACT_EFFORT_TO_DATE, 0) +
NVL(ppru.EQPMT_ACT_EFFORT_TO_DATE, 0) ) -
-- (NVL(pfxat.labor_hours, 0) + NVL(pfxat.equipment_hours, 0))
(NVL(pxpv.labor_effort,0) + NVL(pxpv.equipment_effort,0))
from pji_xbs_plans_v pxpv,
-- from pji_fm_xbs_accum_tmp1 pfxat,
pa_progress_rollup ppru,
pa_proj_element_versions ppev
where ppev.element_version_id = c_wp_ver_id
and ppev.project_id = ppru.project_id
and ppev.proj_element_id = ppru.object_id
and ppev.object_type = ppru.object_type
and ppru.structure_version_id is null -- Added for bug 6337529
and ppru.structure_type = 'WORKPLAN'
and ppev.project_id = pxpv.project_id
and ppev.proj_element_id = pxpv.proj_element_id
and ppev.element_version_id = pxpv.structure_version_id
and pxpv.structure_type(+) = 'WORKPLAN'
-- and ppev.project_id = pfxat.project_id
-- and ppev.proj_element_id = pfxat.project_element_id
-- and ppev.element_version_id = pfxat.struct_version_id
-- and pfxat.calendar_type (+) = 'A'
order by ppru.as_of_date desc;
select (NVL(ppru.estimated_remaining_effort,0) + NVL(ppru.eqpmt_etc_effort,0))
from pa_progress_rollup ppru,
pa_proj_element_versions ppev
where ppev.element_version_id = c_wp_ver_id
and ppev.project_id = ppru.project_id
and ppev.proj_element_id = ppru.object_id
and ppev.object_type = ppru.object_type
and ppru.structure_type = 'WORKPLAN'
order by ppru.as_of_date desc;
select baseline_finish_date, scheduled_finish_date
from pa_projects_all
where project_id = p_object_id;
select baseline_start_date, scheduled_start_date
from pa_projects_all
where project_id = p_object_id;
select sch.scheduled_finish_date
from pa_proj_elem_ver_schedule sch,
pa_proj_elem_ver_structure str,
pa_proj_structure_types ppst,
pa_structure_types pst
where pst.structure_type = 'WORKPLAN'
and pst.structure_type_id = ppst.structure_type_id
and ppst.proj_element_id = str.proj_element_id
and str.project_id = p_object_id
and str.project_id = sch.project_id
and str.proj_element_id = sch.proj_element_id
and str.element_version_id = sch.element_version_id
and str.status_code = 'STRUCTURE_PUBLISHED' --bug 3956895
order by str.published_date desc;
select sch.scheduled_start_date
from pa_proj_elem_ver_schedule sch,
pa_proj_elem_ver_structure str,
pa_proj_structure_types ppst,
pa_structure_types pst
where pst.structure_type = 'WORKPLAN'
and pst.structure_type_id = ppst.structure_type_id
and ppst.proj_element_id = str.proj_element_id
and str.project_id = p_object_id
and str.project_id = sch.project_id
and str.proj_element_id = sch.proj_element_id
and str.element_version_id = sch.element_version_id
and str.status_code = 'STRUCTURE_PUBLISHED' --bug 3956895
order by str.published_date desc;
select sch.scheduled_finish_date, nvl(sch.estimated_finish_date, sch.scheduled_finish_date)
from pa_proj_elem_ver_schedule sch,
pa_proj_elem_ver_structure str,
pa_proj_structure_types ppst,
pa_structure_types pst
where pst.structure_type = 'WORKPLAN'
and pst.structure_type_id = ppst.structure_type_id
and ppst.proj_element_id = str.proj_element_id
and str.project_id = p_object_id
and str.project_id = sch.project_id
and str.proj_element_id = sch.proj_element_id
and str.element_version_id = sch.element_version_id
and str.status_code = 'STRUCTURE_PUBLISHED' --bug 3956895
order by str.published_date desc;
select sch.scheduled_start_date, nvl(sch.estimated_start_date, sch.scheduled_start_date)
from pa_proj_elem_ver_schedule sch,
pa_proj_elem_ver_structure str,
pa_proj_structure_types ppst,
pa_structure_types pst
where pst.structure_type = 'WORKPLAN'
and pst.structure_type_id = ppst.structure_type_id
and ppst.proj_element_id = str.proj_element_id
and str.project_id = p_object_id
and str.project_id = sch.project_id
and str.proj_element_id = sch.proj_element_id
and str.element_version_id = sch.element_version_id
and str.status_code = 'STRUCTURE_PUBLISHED' --bug 3956895
order by str.published_date desc;