PQH Organizational Position Summary

➜ Back to Library
Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: Organizational Position Summary Report (XML)
Short Name: PQHWSPCH_XML
DB package: PQH_PQHWSPCH_XMLP_PKG 
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
Business Group 
 
 Number
Currency 
 
 LOV Oracle
End Date 
 
 Date
Start Date 
 
 Date
Variance Percent 
 
 Number
Position Type 
 
 LOV Oracle
Effective Date 
 
 Date
Download
Related Blitz Reports
JL Regional Fixed Assets Inflation Adjusted Asset Summary - draft
PQH Budget Period Position Detail
FA Fully Reserved Assets - draft
FA Diminishing Value - draft
FA Financial Adjustments - draft
FA Asset Additions Responsibility - draft
FA Conversion Assets - draft
FA Asset Additions By Cost Center - draft
FA Asset Additions - draft
Blitz Report In Action