OKL Lease Subsidy Pool Reconciliation

Description
Categories: BI Publisher
Columns: Trans Rec Type, Source, Contract Number, Asset Number, Vendor, Subsidy Name, Source Trx Date, Trx Amount, Conversion Rate, Subsidy Pool Amount ...
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
Subsidy Pool Name
 
LOV Oracle
From Date
 
Date
To Date
 
Date