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
Run
OKL Lease Subsidy Pool At-Limit and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
