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
Source: Worksheet Account Costing Report By Responsibility (XML)
Short Name: PSBRRWAC_XML
DB package: PSB_PSBRPWAC_XMLP_PKG
Run
PSB Worksheet Account Costing Report By Responsibility and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |