OKL Lease Subsidy Pool Reconciliation

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Lease Subsidy Pool Reconciliation Report
Short Name: OKLLASUBPOOLRECONRPT
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 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
Download
 
Related Blitz Reports
OKL Generate Reconciliation OKL Billable Streams Reconciliation OKL Lease Subsidy Pool Association OKL Lease Subsidy Pool At-Limit AP Open Items Revaluation AP Open Balances Revaluation ECC Project Procurement, Procurement Plan Blitz Reports CE General Ledger Reconciliation
Blitz Report™

Blitz Report™ provides multiple benefits: