ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F42C3869E053B46B63588994 select a.wal_sp_package_id,a.name year_name,a.wal_budget_group_id, b.worksheet_id ,a.est_amt,a.stat_amt,bg.name bg_name from psb_budget_groups bg, ( SELECT wal.budget_group_id wal_budget_group_id, wal.service_package_id wal_sp_package_id, p.name, sum(decode(balance_type,'E',nvl(YTD_AMOUNT,0),0)) EST_AMT, sum(decode(currency_code,'STAT',nvl(YTD_AMOUNT,0),0)) STAT_AMT FROM psb_budget_periods p, psb_ws_account_lines wal, psb_ws_lines wl where wl.worksheet_id = :sp_global_worksheet_id and wl.account_line_id = wal.account_line_id and p.budget_period_id = wal.budget_year_id and ( (:cp_sequence_number IS NULL AND end_stage_seq IS NULL) OR (:cp_sequence_number BETWEEN start_stage_seq AND NVL(end_stage_seq,start_stage_seq) )) group by wal.service_package_id,wal.budget_group_id,p.name ) a, ( select ws.worksheet_id,ws.budget_group_id from psb_worksheets ws where ( ws.worksheet_id = :sp_global_worksheet_id or ws.global_worksheet_id = :sp_global_worksheet_id ) ) b where a.wal_budget_group_id = b.budget_group_id(+) and a.wal_budget_group_id = bg.budget_group_id and a.wal_sp_package_id=:sp_service_package_id --order by a.wal_sp_package_id,a.wal_budget_group_id,a.name ORDER BY 7 ASC,4 ASC,1 ASC , a.wal_sp_package_id , a.wal_budget_group_id , a.name Y PSB PSBRPSPU_XML US PSB Service Package Utilization Application: Public Sector Budgeting (Obsolete) Source: Service Package Utilization Report (XML) Short Name: PSBRPSPU_XML DB package: PSB_PSBRPSPU_XMLP_PKG BI Publisher :cp_sequence_number :sp_global_worksheet_id :sp_service_package_id 1 10 :p_global_worksheet_id LOV Oracle PSB_SRS_GLOBAL_WS Y select worksheet_id id, worksheet_id value, name description from psb_worksheets where global_worksheet_flag='Y' and nvl(federal_ws_flag,'N')='N' order by worksheet_id desc,name Y US Worksheet 2 20 :p_stage_id LOV Oracle PSB_SRS_BJE_STAGE 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_global_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_SERVICE_PACKAGES Y select service_package_id id, short_name value, name description from psb_service_packages where global_worksheet_id=:$flex$.psb_srs_global_ws order by global_worksheet_id US Service Package 4 40 :p_order_by LOV Oracle PSB_SRS_SERVICE_PKG_PRIORITY Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='PSB_SORT_ORDER_SERVICE_PACKAGE' order by value,description Y US Sort By :$flex$.psb_srs_global_ws Worksheet Budget Stage :$flex$.psb_srs_global_ws Worksheet Service Package