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
SQL 7 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| From Project Number | Char | |
| To Project Number | Char | |
| GL Period | LOV Oracle |