OKL Lease Subsidy Pool At-Limit
Description
- Categories
- BI Publisher
- Application
- Lease and Finance Management
- Source
- Lease Subsidy Pool At-Limit Report
- Short Name
- OKLLASUBPOOLATLMTRPT
- DB package
- OKL_SUBSIDY_POOL_RPT_PVT
SQL 11 lines
SELECT VALUE1_TEXT EOT_TYPE, VALUE2_TEXT EOT_SUBSIDY_POOL_NAME, VALUE3_TEXT EOT_CURRENCY_CODE, VALUE4_TEXT EOT_TOTAL_BUDGETS, VALUE5_TEXT EOT_REMAINING_BALANCE, VALUE6_TEXT EOT_PERCENT_REMAINING, VALUE1_DATE EOT_EFFECTIVE_TO_DATE, VALUE1_NUM EOT_REMAINING_DAYS FROM OKL_G_REPORTS_GT WHERE VALUE1_TEXT = 'DAYS' |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Pools with remaining budget below (%) | Number | |
| Pools with remaining budget below (amount) | Number | |
| Subsidy Pool Currency | LOV Oracle | |
| Subsidy Pool End of Term | Date | |
| Subsidy Pool Remaining Days | Number |