OKL Report - Vendor Residual Share

Description
Categories: BI Publisher
Columns: Program Agreement, Asset Number, Asset Description, Contract Number, Asset Termination Date, Vendor, Disposition Date, Vendor Share ...
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 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