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
Source: OKL Report - Vendor Residual Share Report
Short Name: OKL_AM_VEND_RES_SHR_RPT
DB package: OKL_AM_VENDOR_RES_SHARE_PVT
Run
OKL Report - Vendor Residual Share and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
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 |