PQH Position Element Detail

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: Position Element Detail Report (XML)
Short Name: PQHWSPBD_XML
DB package: PQH_PQHWSPBD_XMLP_PKG
Run PQH Position Element Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
select organization_name,
       position_name,
       budget_measurement_type, 
       element_name,
      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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_XMLP_PKG.cf_format_mask(budget_unit_id) CF_Format_Mask
from pqh_position_budgets_v
where position_id = NVL(:p_position_id,position_id)
  and organization_id = NVL(:p_organization_id,organization_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
Organization Name 
 
 LOV Oracle
Position Name 
 
 LOV Oracle
Position Type 
 
 LOV Oracle
Variance Percent 
 
 Number
Start Date 
 
 Date
End Date 
 
 Date
Currency 
 
 LOV Oracle
Download
Related Blitz Reports
PQH Position Summary PQH Position Element Summary PQH Budget Period Position Detail PQH Entity Element Summary PQH Report Under Budgeted Entities PER Requisition Summary PSB Pooled Position Report for Worksheet by Responsibility PSB Stage Variance Report for Position PSB Pooled Position Report for Worksheet
Blitz Report™

Blitz Report™ provides multiple benefits: