OKL Lease Subsidy Pool Reconciliation
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
SQL 16 lines
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' |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Subsidy Pool Name | LOV Oracle | |
| From Date | Date | |
| To Date | Date |