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
Source: Lease Subsidy Pool At-Limit Report
Short Name: OKLLASUBPOOLATLMTRPT
DB package: OKL_SUBSIDY_POOL_RPT_PVT
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' |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| 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 |