PQH Position Element Summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: Position Element Summary Report (XML)
Short Name: PQHWSEPS_XML
DB package: PQH_PQHWSEPS_XMLP_PKG
Run PQH Position Element Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select element_name,
      element_type_id,
       position_name, 
       budget_measurement_type, 
       budget_unit_id, 
       pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt
       (
        null,
        position_id,
        element_type_id,
        :p_start_date,
        :p_end_date,
        budget_unit_id,
:p_currency_code
       )  budgeted_amt,
       pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts
       (
        null,
        position_id,
        element_type_id,
        :p_start_date,
        :p_end_date,
        budget_unit_id,
        'C',
:p_currency_code
       )  committed_amt,
       pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts
       (
        null,
        position_id,
        element_type_id,
        :p_start_date,
        :p_end_date,
        budget_unit_id,
        'A',
:p_currency_code
       )  actual_amt, 
	PQH_PQHWSEPS_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, 
	PQH_PQHWSEPS_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, 
	PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1
from 	pqh_position_element_types_v
where 	element_type_id = :p_element_type_id
And 	pqh_mgmt_rpt_pkg.check_pos_type_and_variance
                  (   null, 		position_id,
                     :p_start_date,              :p_end_date,
                      budget_unit_id ,	:p_position_type,
	   NVL(:p_variance_percent,0)   , :p_currency_code    ) =  NVL(:p_position_type,'A')
Parameter Name SQL text Validation
Effective Date 
 
 Date
Element Name 
 
 LOV Oracle
Position Type 
 
 LOV Oracle
Variance Percent 
 
 Number
Start Date 
 
 Date
End Date 
 
 Date
Currency 
 
 LOV Oracle
Download
Related Blitz Reports
PQH Entity Element Summary PQH Position Element Detail PSB Pooled Position Report for Worksheet PSB Pooled Position Report for Worksheet by Responsibility PQH Budget Period Position Detail PQH Position Summary CLVSTAFF PSB Worksheet Position Costing Report XML PSB Worksheet Position Costing
Blitz Report™

Blitz Report™ provides multiple benefits: