OKL Contract Lines Financial

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Contract Lines Financial Report
Short Name: OKLLNFINEXT
DB package: OKL_K_LINE_FIN_EXT_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 LFE.*, RMA.DESCRIPTION INSTRUMENT_NUMBER, RMA.BANK BANK_NAME 
                FROM 
		OKL_CNTRCT_LINE_FIN_EXTRACT_T LFE, OKX_RCPT_METHOD_ACCOUNTS_V RMA
		WHERE REQUEST_ID = :L_REQUEST_ID 
            AND CONTRACT_LINE_TYPE_NAME = 'Financial Asset Line' AND RMA.ID1(+) = LFE.ASSET_BILLING_BANK_ACCT_ID
            ORDER BY CONTRACT_CURRENCY, line_supplier, CONTRACT_BOOK_CLASSIFICATION, fa_corp_category, CONTRACT_NUMBER
Parameter Name SQL text Validation
Operating Unit 
 
 LOV Oracle
Report Date 
 
 Date
Contract Start Date From 
 
 Date
Contract Start Date To 
 
 Date
Book Classification 
 
 LOV Oracle
Financial Product 
 
 LOV Oracle
Contract Number 
 
 LOV Oracle
Contract Status 
 
 LOV Oracle
Contract Line Status 
 
 LOV Oracle
Contract Line Type 
 
 LOV Oracle
Customer Party Name 
 
 LOV Oracle
Customer Party Number 
 
 LOV Oracle
Supplier Name 
 
 LOV Oracle
Supplier Number 
 
 LOV Oracle
Include Fixed Asset Details 
 
 LOV Oracle
Asset Tax Book 
 
 LOV Oracle
Delete Report Data 
 
 LOV Oracle
Download
 
Related Blitz Reports
OKL Lease Advance Monies OKL Generate Pending Asset Repossession Report for Loans Avalara VAT listing Avalara VAT LinesData RK: AR Transactions and Lines OKL Receipt Inquiry OKL Termination Quotes WSH Shipping/Delivery Transactions GL Account Analysis (Distributions)
Blitz Report™

Blitz Report™ provides multiple benefits: