PQH Position Element Summary
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
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 |