PQH Organizational Position Summary

➜ Back to Library
Description
Categories: BI Publisher
Columns: Bgrp Business Group Id, Bgrp Budget Measure Type, Bgrp Budget Unit Id, Bgrp Budgeted Amt, Bgrp Actual Amt, Bgrp Committed Amt, Cf Bgrp Projected Amt, Cf Bgrp Def Ex Amt, Cf Bgrp Com Per, Cf Bgrp Proj Per ...
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
Effective Date 
 
 Date
Position Type 
 
 LOV Oracle
Variance Percent 
 
 Number
Start Date 
 
 Date
End Date 
 
 Date
Currency 
 
 LOV Oracle
Business Group 
 
 Number
Download
Related Blitz Reports
JL Regional Fixed Assets Inflation Adjusted Asset Summary - draft PQH Budget Period Position Detail ECC Project Procurement, Procurement Plan CST Period Close Subinventory Value Summary INV Shortages Summary PO IDV Modification ECC Service, Service Request PO Modification Data template ZX Use Tax Liability - draft
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: