PA Revenue Categories

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Revenue Categories (XML)
Short Name: PAXRWRVC_XML
DB package: PA_PAXRWRVC_XMLP_PKG
Run PA Revenue Categories and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	et.expenditure_type
,	et.expenditure_category
,	et.revenue_category_code
,	et.start_date_active
,	et.end_date_active
FROM	pa_expenditure_types et 
 WHERE et.revenue_category_code=:LOOKUP_CODE
ORDER BY
	et.expenditure_type
,	et.start_date_active
Parameter Name SQL text Validation
Revenue Category 
 
 LOV Oracle
Download
Related Blitz Reports
PA Missing Timecards PA Project Subledger: Detail by Project ECC Projects, Projects Costing: Transactions, SQL1 PA Sweep Transaction Accounting Events PA Payroll Distribution Employee Detail ECC Project Manufacturing, Expenditures ECC Procurement, Requisitions ECC Projects, Projects Costing: Transactions, SQL2 PA Expense Report Entry ECC Procurement, Purchase Orders
Blitz Report™

Blitz Report™ provides multiple benefits: