PQH Report Under Budgeted Entities

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Report Under Budgeted Entities for a unit
Application: Public Sector HR
Source: Report Under Budgeted Entities (XML)
Short Name: PQUBGTEN_XML
DB package: PQH_PQUBGTEN_XMLP_PKG
Run PQH Report Under Budgeted Entities and other Oracle EBS reports with Blitz Report™ on our demo environment
select  hr_general.decode_lookup('PQH_BUDGET_ENTITY', information8) entity_code, 
hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',  information9) uom,
            -- ':'||hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',  information9) uom,
information9 uomcode, 
                log_context   name, 
                to_char(fnd_date.canonical_to_date(information10),'DD-MON-YYYY') under_budgeted_date, 
                NVL(to_number(information3),0)  budgeted_amount, 
                NVL(to_number(information4),0)  reallocation_amount, 
                NVL(to_number(information5),0)  actual_amount, 
                NVL(to_number(information6),0)  commitment_amount, 
               Decode(Information9,'MONEY', ((nvl(information3,0) + nvl(information4,0)) - 
(nvl(information5,0) + nvl(information6,0)) ),
            ( (Nvl(Information3,0) + Nvl(Information4,0)) -
            ((Nvl(Information5,0)))))
                            under_budgeted_amount, 
	PQH_PQUBGTEN_XMLP_PKG.cf_amount_format_maskformula(':' || hr_general.decode_lookup ( 'BUDGET_MEASUREMENT_TYPE' , information9 )) CF_AMOUNT_FORMAT_MASK
from pqh_process_log 
        where module_cd = 'POSITION_BUDGET_ANALYSIS' 
          and information12 = 'REPORT' 
      and information11 like  :P_BATCH_NAME||'%'
order by uomcode,entity_code,uom,name,budgeted_amount,reallocation_amount,actual_amount,commitment_amount,under_budgeted_amount,under_budgeted_date
Parameter Name SQL text Validation
Batch Name 
 
 Char
P_EFFECTIVE_DATE 
 
 Date
Start Date 
 
 Date
End Date 
 
 Date
P_ENTITY_CODE 
 
 LOV Oracle
Budget Measurement Unit 
 
 LOV Oracle
P_ORG_STRUCTURE_ID 
 
 LOV Oracle
Starting Organization 
 
 LOV Oracle
Download
Related Blitz Reports
FND Concurrent Requests 11i FND Concurrent Requests CST Margin Analysis Report with Order Management PER Employee Approved Leave History PQH Position Element Summary PQH Position Summary PQH IPEDS Report - Staff Survey (S1) - Part F(obsoleted) PQH Budget Period Position Detail XLA Export Application Accounting Definitions- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: