PSB Worksheet Account Costing Report By Responsibility

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Worksheet Account Costing Report By Responsibility (XML)
Short Name: PSBRRWAC_XML
DB package: PSB_PSBRPWAC_XMLP_PKG
SELECT
wal.code_combination_id ccid
,cc.concatenated_segments
,bg.short_name bgname
,sp.service_package_short_name spname
,wal.currency_code
,sum(decode(budget_year_id,:p_budgeT_group_id1 ,nvl(ytd_amount,0),0)) y1_amt
,sum(decode(budget_year_id,:p_budget_group_id2 ,nvl(ytd_amount,0),0)) y2_amt
,sum(decode(budget_year_id,:p_budget_group_id3 ,nvl(ytd_amount,0),0)) y3_amt
,sum(decode(budget_year_id,:p_budget_group_id4 ,nvl(ytd_amount,0),0)) y4_amt
FROM  psb_ws_account_lines wal
     ,psb_ws_lines wl
     ,psb_worksheets ws
     ,psb_ws_service_packages_v sp
     ,psb_budget_groups bg
     , gl_code_combinations_kfv cc
where ws.worksheet_id = :p_global_worksheet_id and
     cc.code_combination_id = wal.code_combination_id and
   ((:cp_sequence_number is NULL and wal.end_stage_seq is null ) OR
         ws.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
      wl.worksheet_id  = ws.worksheet_id and
      wl.worksheet_id  = sp.worksheet_id and
      sp.service_package_id = wal.service_package_id and
      wal.balance_type = 'E' and
      wl.account_line_id = wal.account_line_id and
      bg.budget_group_id = wal.budget_group_id and
      cc.summary_flag = 'N' 
group by bg.short_name,sp.service_package_short_name ,wal.code_combination_id,cc.concatenated_segments, currency_code
order by bg.short_name
Parameter Name SQL text Validation
Worksheet
 
LOV Oracle
Budget Stage
 
LOV Oracle
Service Package
 
LOV Oracle
First Year
 
LOV Oracle
Second Year
 
LOV Oracle
Third Year
 
LOV Oracle
Fourth Year
 
LOV Oracle