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

ParameterTypeList of values SQL
Asset NumberLOV Oracle
Disposition Date FromDate
Disposition Date ToDate
Program AgreementLOV Oracle
Asset Termination Date FromDate
Asset Termination Date ToDate
Currency CodeLOV Oracle