PQH Organizational Position Summary
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: Organizational Position Summary Report (XML)
Short Name: PQHWSPCH_XML
DB package: PQH_PQHWSPCH_XMLP_PKG
Application: Public Sector HR
Source: Organizational Position Summary Report (XML)
Short Name: PQHWSPCH_XML
DB package: PQH_PQHWSPCH_XMLP_PKG
Run
PQH Organizational Position Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
Select business_group_id bgrp_business_group_id, budget_measurement_type bgrp_budget_measure_type, budget_unit_id bgrp_budget_unit_id, NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id, :p_start_date, :p_end_date, budget_unit_id, :p_currency_code ),0) bgrp_budgeted_amt, NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id, :p_start_date, :p_end_date, budget_unit_id, 'A', :p_currency_code ) ,0) bgrp_actual_amt, NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id, :p_start_date, :p_end_date, budget_unit_id, 'C' , :p_currency_code ),0) bgrp_committed_amt, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )) CF_bgrp_projected_amt, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_amtformula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 ))) CF_bgrp_def_ex_amt, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_com_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )) CF_bgrp_com_per, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_proj_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 ))) CF_bgrp_proj_per, PQH_PQHWSPCH_XMLP_PKG.cf_format_mask3(budget_unit_id) CF_Format_Mask3, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_amtformula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )))) CF_bgrp_def_ex_per, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_actual_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 )) CF_bgrp_actual_per from pqh_pc_org_summary_v where business_group_id=:business_group_id group by business_group_id, budget_measurement_type, budget_unit_id |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Effective Date |
|
Date | |
Position Type |
|
LOV Oracle | |
Variance Percent |
|
Number | |
Start Date |
|
Date | |
End Date |
|
Date | |
Currency |
|
LOV Oracle |