PA Summarize Unbilled Receivables/Unearned Revenue Balances Process

➜ Back to Library
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
Download
Related Blitz Reports
ECC Projects, Projects Billing: Revenue, Invoice, and Distributions PA Invoice Review XLA Distribution Links Summary ECC Projects, Projects Costing: Transactions, SQL1 PA Project Subledger: Detail by Expenditure Type PA Project Subledger Summary PA Project Subledger: Detail by Project PA Project Billing Status PO IDV Modification
Blitz Report™

Blitz Report™ provides multiple benefits: