PA Summarize Unbilled Receivables/Unearned Revenue Balances Process

Description
Categories: BI Publisher
Application: Projects
Source: PRC: Summarize Unbilled Receivables/Unearned Revenue Balances Process (XML)
Short Name: PAUBRUER_XML
DB package: PA_PAUBRUER_XMLP_PKG
Run PA Summarize Unbilled Receivables/Unearned Revenue Balances Process and other Oracle EBS reports with Blitz Report™ on our demo environment
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
 
Char
To Project Number
 
Char
GL Period
 
LOV Oracle
Blitz Report™