PA Revenue Categories

Description
Categories: BI Publisher
Application: Projects
Source: IMP: Revenue Categories (XML)
Short Name: PAXRWRVC_XML
DB package: PA_PAXRWRVC_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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