PA Summarize Unbilled Receivables/Unearned Revenue Balances Process

Description
Categories: BI Publisher
Columns: Project Number, Project Type, Draft Revenue Num, Gl Period, Revenue Amount, Unbilled Receivables Amount, Unearned Revenue Amount, Gl Header Id, Gl Line Num ...
Application: Projects
Source: PRC: Summarize Unbilled Receivables/Unearned Revenue Balances Process (XML)
Short Name: PAUBRUER_XML
DB package: PA_PAUBRUER_XMLP_PKG
SELECT uudp.project_number,uudp.project_type,uudp.draft_revenue_num,
       uudp.gl_period,uudp.revenue_amount,uudp.unbilled_receivables_amount,
	   uudp.unearned_revenue_amount,uudp.gl_header_id,uudp.gl_line_num
FROM pa_ubr_uer_dr_prj_v uudp
WHERE uudp.request_id = :p_conc_request_id
ORDER BY uudp.project_number,uudp.draft_revenue_num
Parameter Name SQL text Validation
From Project Number
 
To Project Number
 
GL Period
 
LOV Oracle