OKL Report - Vendor Residual Share

➜ Back to Library
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
			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 NameSQL textValidation
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
Download
Related Blitz Reports
OKL Equipment Exchange Request OKL Lease Shipping Instructions OKL Receipt Inquiry OKL Termination Quotes OKL Billing Inquiry Data OKL Lease Advance Monies OKL Lease Property Tax OKL Amortization Schedule OKL Loans Amortization Schedule
Blitz Report™