PQH Entity Element Summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: Entity Element Summary Report (XML)
Short Name: PQHWSEES_XML
DB package: PQH_PQHWSEES_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Missing WIP Accounting Transactions CAC Material Account Detail ECC Project Procurement, Procurement Plan CAC ICP PII WIP Material Usage Variance CAC Purchase Price Variance CAC Deferred COGS Out-of-Balance CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Material Usage with Configuration and Lot Variances
Blitz Report™

Blitz Report™ provides multiple benefits: