ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4313869E053B46B63588994 SELECT pos.name posid ,bg.short_name bgname ,sp.service_package_short_name spname ,elm.currency_code currency_code ,round(sum(decode(budget_year_id,:p_budgeT_group_id1 ,nvl(element_cost,0),0)), 2) y1_amt ,round(sum(decode(budget_year_id,:p_budget_group_id2 ,nvl(element_cost,0),0)), 2) y2_amt ,round(sum(decode(budget_year_id,:p_budget_group_id3 ,nvl(element_cost,0),0)), 2) y3_amt ,round(sum(decode(budget_year_id,:p_budget_group_id4 ,nvl(element_cost,0),0)), 2) y4_amt FROM psb_ws_element_lines elm ,psb_ws_lines_positions lp ,psb_ws_position_lines pl ,psb_ws_service_packages_v sp ,psb_budget_groups bg ,psb_positions pos where lp.worksheet_id = :p_global_worksheet_id and ((:cp_sequence_number is NULL AND elm.end_stage_seq is NULL) or elm.current_stage_seq = :cp_sequence_number) and ( (:p_service_package_id is not null and sp.service_package_id = :p_service_package_id) or (:p_service_package_id is null ) ) and sp.service_package_id = elm.service_package_id and lp.worksheet_id = sp.worksheet_id and elm.position_line_id = lp.position_line_id and pl.position_line_id = lp.position_line_id and bg.budget_group_id = pl.budget_group_id and pos.position_id = pl.position_id and pl.copy_of_position_line_id is null and elm.end_stage_seq is null group by bg.short_name,sp.service_package_short_name,pos.name,elm.currency_code ORDER BY 2 ASC Y PSB PSBRPWPC_XML US PSB Worksheet Position Costing Application: Public Sector Budgeting (Obsolete) Source: Worksheet Position Costing Report (XML) Short Name: PSBRPWPC_XML DB package: PSB_PSBRPWPC_XMLP_PKG BI Publisher :cp_sequence_number :p_budget_group_id1 :p_budget_group_id2 :p_budget_group_id3 :p_budget_group_id4 :p_global_worksheet_id :p_service_package_id 1 10 :p_global_worksheet_id LOV Oracle PSB_SRS_POS_WS Y select worksheet_id id, worksheet_id value, name description from psb_worksheets where budget_by_position='Y' and ws_creation_complete='Y' order by worksheet_id Y US Worksheet 2 20 :p_stage_id LOV Oracle PSB_SRS_STAGE_POS_WS Y select budget_stage_id id, name value, description description from psb_budget_stages where budget_stage_id in (select a.budget_stage_id from psb_budget_stages a,psb_budget_stage_sets b,psb_worksheets c where c.worksheet_id=:$flex$.psb_srs_pos_ws and b.budget_stage_set_id=c.stage_set_id and a.budget_stage_set_id=b.budget_stage_set_id and a.sequence_number=c.current_stage_seq) order by sequence_number desc US Budget Stage 3 30 :p_service_package_id LOV Oracle PSB_SRS_SPACKAGE_POS_WS Y select service_package_id id, short_name value, name description from psb_service_packages where global_worksheet_id=(select nvl(global_worksheet_id,worksheet_id) from psb_worksheets where worksheet_id=:$flex$.psb_srs_pos_ws) order by short_name US Service Package 4 40 :p_budget_group_id1 LOV Oracle PSB_SRS_RPT_POS_WS_YEAR1 Y select budget_period_id id, name value, description description from psb_budget_periods where budget_period_type='Y' and budget_calendar_id=(select a.budget_calendar_id from psb_worksheets a where a.worksheet_id=:$flex$.psb_srs_pos_ws) and budget_year_type_id in (select budget_year_type_id from psb_budget_year_types where year_category_type='PP') order by value,description Y US First Year 5 50 :p_budget_group_id2 LOV Oracle PSB_SRS_RPT_POS_WS_YEAR2 Y select budget_period_id id, name value, description description from psb_budget_periods where budget_period_type='Y' and budget_period_id<>:$flex$.psb_srs_rpt_pos_ws_year1 and budget_calendar_id=(select a.budget_calendar_id from psb_worksheets a where a.worksheet_id=:$flex$.psb_srs_pos_ws) and budget_year_type_id in (select budget_year_type_id from psb_budget_year_types where year_category_type='PP') order by value,description US Second Year 6 60 :p_budget_group_id3 LOV Oracle PSB_SRS_RPT_POS_WS_YEAR3 Y select budget_period_id id, name value, description description from psb_budget_periods where budget_period_type='Y' and budget_period_id<>:$flex$.psb_srs_rpt_pos_ws_year1 and budget_period_id<>:$flex$.psb_srs_rpt_pos_ws_year2 and budget_calendar_id=(select a.budget_calendar_id from psb_worksheets a where a.worksheet_id=:$flex$.psb_srs_pos_ws) and budget_year_type_id in (select budget_year_type_id from psb_budget_year_types where year_category_type='PP') order by value,description US Third Year 7 70 :p_budget_group_id4 LOV Oracle PSB_SRS_RPT_POS_WS_YEAR4 Y select budget_period_id id, name value, description description from psb_budget_periods where budget_period_type='Y' and budget_period_id<>:$flex$.psb_srs_rpt_pos_ws_year1 and budget_period_id<>:$flex$.psb_srs_rpt_pos_ws_year2 and budget_period_id<>:$flex$.psb_srs_rpt_pos_ws_year3 and budget_calendar_id=(select a.budget_calendar_id from psb_worksheets a where a.worksheet_id=:$flex$.psb_srs_pos_ws) and budget_year_type_id in (select budget_year_type_id from psb_budget_year_types where year_category_type='PP') order by value,description US Fourth Year :$flex$.psb_srs_pos_ws Worksheet Budget Stage :$flex$.psb_srs_pos_ws Worksheet First Year :$flex$.psb_srs_pos_ws Worksheet Fourth Year :$flex$.psb_srs_pos_ws Worksheet Second Year :$flex$.psb_srs_pos_ws Worksheet Service Package :$flex$.psb_srs_pos_ws Worksheet Third Year :$flex$.psb_srs_rpt_pos_ws_year1 First Year Fourth Year :$flex$.psb_srs_rpt_pos_ws_year1 First Year Second Year :$flex$.psb_srs_rpt_pos_ws_year1 First Year Third Year :$flex$.psb_srs_rpt_pos_ws_year2 Second Year Fourth Year :$flex$.psb_srs_rpt_pos_ws_year2 Second Year Third Year :$flex$.psb_srs_rpt_pos_ws_year3 Third Year Fourth Year