OKL Report - Vendor Residual Share
Description
- Categories
- BI Publisher
- Application
- Lease and Finance Management
- Source
- OKL Report - Vendor Residual Share Report
- Short Name
- OKL_AM_VEND_RES_SHR_RPT
- DB package
- OKL_AM_VENDOR_RES_SHARE_PVT
SQL 17 lines
SELECT VPA.contract_number PROGRAM_AGREEMENT, CLE.name ASSET_NUMBER, CLE.item_description ASSET_DESCRIPTION, CHR.contract_number CONTRACT_NUMBER, CLE.date_terminated ASSET_TERMINATION_DATE, PPD.vendor_name VENDOR, TAL.fa_trx_date DISPOSITION_DATE, TAL.residual_shr_amount||' '||CHR.currency_code VENDOR_SHARE FROM OKC_K_LINES_V CLE, OKC_K_HEADERS_B CHR, OKC_K_HEADERS_B VPA, OKL_K_HEADERS KHR, OKL_TRX_ASSETS TAS, OKL_TXL_ASSETS_B TAL, OKL_PARTY_PAYMENT_DTLS_UV PPD &WHERE_CLAUSE |
Parameters 7
| Parameter | Type | List of values SQL |
|---|---|---|
| Asset Number | LOV Oracle | |
| Disposition Date From | Date | |
| Disposition Date To | Date | |
| Program Agreement | LOV Oracle | |
| Asset Termination Date From | Date | |
| Asset Termination Date To | Date | |
| Currency Code | LOV Oracle |