PQH Budget Period Position Detail

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: Budget Period Position Detail Report (XML)
Short Name: PQHWSBPR_XML
DB package: PQH_PQHWSBPR_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 budget_name,
       budgeted_entity,
       budget_style,
       budget_calendar_name,
       budget_calendar_frequency,
       budget_start_date,
       budget_end_date,
       budget_version_number,
       budget_version_start_date,
       budget_version_end_date,
       position_name, 
       budget_measurement_type, 
       budget_period_name,
       budget_period_budgeted_value,
       budget_period_cmmtmnt_value,
       budget_period_actual_value,
       budget_unit_Id,
       pqh_mgmt_rpt_pkg.get_pos_org(position_id) Organization_name, 
	PQH_PQHWSBPR_XMLP_PKG.cf_act_performula(budget_period_budgeted_value, budget_period_actual_value) CF_act_per, 
	PQH_PQHWSBPR_XMLP_PKG.cf_com_performula(budget_period_budgeted_value, budget_period_cmmtmnt_value) CF_com_per, 
	PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value) cf_projected_exp, 
	PQH_PQHWSBPR_XMLP_PKG.cf_proj_performula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value)) CF_proj_per, 
	PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_amtformula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value)) cf_def_ex_amt, 
	PQH_PQHWSBPR_XMLP_PKG.cf_format_maskformula(budget_unit_Id) CF_format_mask, 
	PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_performula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_amtformula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value))) CF_def_ex_per
from pqh_budget_details_v
where budget_version_id = :p_budget_version_id
and (:p_record_type='A' or  budget_period_budgeted_value is not null)
Parameter Name SQL text Validation
Effective Date 
 
 Date
Budget Name 
 
 LOV Oracle
Record Type 
 
 LOV Oracle
Download
 
Related Blitz Reports
PQH Position Element Summary PQH Entity Element Summary PQH Organizational Position Summary PQH Position Element Detail PQH Position Summary ECC Projects, Projects Costing: Transactions, SQL1 PQH Report Under Budgeted Entities GL Journals (Drilldown) PA PCO Report Data Template
Blitz Report™

Blitz Report™ provides multiple benefits: