PQH Report Under Budgeted Entities

Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: Report Under Budgeted Entities (XML)
Short Name: PQUBGTEN_XML
DB package: PQH_PQUBGTEN_XMLP_PKG
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
Business Group
 
Number
Starting Organization
 
LOV Oracle
P_ORG_STRUCTURE_ID
 
LOV Oracle
Budget Measurement Unit
 
LOV Oracle
P_ENTITY_CODE
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
P_EFFECTIVE_DATE
 
Date
Batch Name