PQH Entity Element Summary

Description

Imported from BI Publisher
Application: Public Sector HR
Source: Entity Element Summary Report (XML)
Short Name: PQHWSEES_XML
DB package: PQH_PQHWSEES_XMLP_PKG

PQH Entity Element Summary and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

select element_name  ELEMENT_NAME_A,								  
      element_type_id  ELEMENT_TYPE_ID_A,								  
       entity_name position_name, 						  
       budget_measurement_type, 						  
       budget_unit_id,      							  
       pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt				  
       (									  
        null,									  
        budgeted_entity_cd,							  
        entity_id,								  
        element_type_id,							  
        :p_start_date,								  
        :p_end_date,								  
        budget_unit_id,								  
:p_currency_code								  
       )  budgeted_amt,								  
       pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts				  
       (									  
        null,									  
       budgeted_entity_cd,							  
        entity_id,								  
        element_type_id,							  
        :p_start_date,								  
        :p_end_date,								  
        budget_unit_id,								  
        'C',									  
:p_currency_code								  
       )  committed_amt,							  
       pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts				  
       (									  
        null,									  
      budgeted_entity_cd,							  
        entity_id,								  
        element_type_id,							  
        :p_start_date,								  
        :p_end_date,								  
        budget_unit_id,								  
        'A',									  
:p_currency_code								  
       )  actual_amt, 
	PQH_PQHWSEES_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, 
	PQH_PQHWSEES_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, 
	PQH_PQHWSEES_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1
from 	pqh_entity_element_types_v						  
where 	element_type_id = :p_element_type_id					  
And    budgeted_entity_cd = :p_budgeted_entity_cd
And 	pqh_mgmt_rpt_pkg.check_ent_type_and_variance				  
      (   null, 	:p_budgeted_entity_cd,	entity_id,			  
	 :p_start_date,              :p_end_date,				  
	  budget_unit_id ,	:p_entity_type,					  
NVL(:p_variance_percent,0)   , :p_currency_code    ) =  NVL(:p_entity_type,'A')
order by 1,3,5

select element_name ELEMENT_NAME_A, element_type_id ELEMENT_TYPE_ID_A, entity_name position_name, budget_measurement_type, budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null, budgeted_entity_cd, entity_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, :p_currency_code ) budgeted_amt, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null, budgeted_entity_cd, entity_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'C', :p_currency_code ) committed_amt, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null, budgeted_entity_cd, entity_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'A', :p_currency_code ) actual_amt, PQH_PQHWSEES_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, PQH_PQHWSEES_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, PQH_PQHWSEES_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, PQH_PQHWSEES_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, PQH_PQHWSEES_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1 from pqh_entity_element_types_v where element_type_id = :p_element_type_id And budgeted_entity_cd = :p_budgeted_entity_cd And pqh_mgmt_rpt_pkg.check_ent_type_and_variance ( null, :p_budgeted_entity_cd, entity_id, :p_start_date, :p_end_date, budget_unit_id , :p_entity_type, NVL(:p_variance_percent,0) , :p_currency_code ) = NVL(:p_entity_type,'A') order by 1,3,5

Parameter Name

SQL text

Validation

Effective Date

Date

Element Name

LOV Oracle

Entity

LOV Oracle

Entity Type

LOV Oracle

Variance Percent

Number

Start Date

Date

End Date

Date

Currency

LOV Oracle

Download

Related Blitz Reports

PQH Position Element Summary CAC Purchase Price Variance ECC Project Procurement, Procurement Plan PQH Position Element Detail PQH Budget Period Position Detail CAC Missing WIP Accounting Transactions CAC WIP Material Usage with Configuration and Lot Variances CAC Material Account Summary PN GL Reconciliation

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ