PSB Worksheet Account Costing

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Worksheet Account Costing Report (XML)
Short Name: PSBRPWAC_XML
DB package: PSB_PSBRPWAC_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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