OKL Lease Subsidy Pool Reconciliation

Description
Categories: BI Publisher, Financials
Application: Lease and Finance Management
Source: Lease Subsidy Pool Reconciliation Report
Short Name: OKLLASUBPOOLRECONRPT
DB package: OKL_SUBSIDY_POOL_RPT_PVT
			SELECT VALUE1_TEXT TRANS_REC_TYPE,
				VALUE2_TEXT SOURCE,
				VALUE3_TEXT CONTRACT_NUMBER,
				VALUE4_TEXT ASSET_NUMBER,
				VALUE5_TEXT VENDOR,
				VALUE6_TEXT SUBSIDY_NAME,
				VALUE1_DATE SOURCE_TRX_DATE,
				VALUE7_TEXT TRX_AMOUNT,
				VALUE1_NUM CONVERSION_RATE,
				VALUE8_TEXT SUBSIDY_POOL_AMOUNT,
				VALUE2_NUM SUBSIDY_AMOUNT_NUM,
				VALUE9_TEXT OPERATING_UNIT,
				VALUE10_TEXT POOL_CURRENCY_CODE
			FROM OKL_G_REPORTS_GT
			WHERE VALUE1_TEXT = 'TRANS_SUMMRY'
Parameter Name SQL text Validation
To Date
 
Date
From Date
 
Date
Subsidy Pool Name
 
LOV Oracle