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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

			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
Download
 
Related Blitz Reports
OKL Equipment Exchange Request OKL Lease Shipping Instructions OKL Termination Quotes OKL Receipt Inquiry OKL Billing Inquiry Data OKL Lease Advance Monies OKL Lease Property Tax OKL Amortization Schedule RK: AR Transactions and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: