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

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 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