PA Revenue Categories
Description
- Categories
- BI Publisher
- Application
- Projects
- Source
- IMP: Revenue Categories (XML)
- Short Name
- PAXRWRVC_XML
- DB package
- PA_PAXRWRVC_XMLP_PKG
SQL 11 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Revenue Category | LOV Oracle |