OKL Contract Lines Financial

Description

Categories: BI Publisher
Columns: Request Id, Contract Id, Contract Line Id, Contract Number, Contract Operating Unit Id, Operating Unit, Operating Unit Short Code, Contract Status Type Code, Contract Status Code, Contract Status ... Columns: Request Id, Contract Id, Contract Line Id, Contract Number, Contract Operating Unit Id, Operating Unit, Operating Unit Short Code, Contract Status Type Code, Contract Status Code, Contract Status, Contract Currency, Contract Currency Conv Type, Contract Currency Conv Rate, Contract Currency Conv Date, Functional Currency, Contract Start Date, Contract End Date, Contract Financial Product Id, Contract Financial Product, Contract Reporting Product Id, Contract Reporting Product, Interest Calclation Basis Code, Revenue Recogntion Method Code, Interest Calculation Basis, Revenue Recognition Method, Contract Interest Index Id, Contract Interest Index, Contract Term Duration, Contract Book Class Code, Contract Book Classification, Contract Legal Entity Id, Legal Entity, Ledger Id, Ledger, Cntrct Customer Party Name, Cntrct Cust Party Id, Cntrct Cust Party Number, Cntrct Cust Acount Id, Cntrct Cust Acct Number, Cntrct Cust Party Site Id, Cntrct Cust Party Site Num, Cntrct Cust Party Site Name, Cntrct Cust Party Site Loc Id, Cntrct Cust Party Site Use Id, Created By, Creation Date, Last Updated By, Last Update Date, Last Update Login, Program Application Id, Program Id, Program Login Id, Program Update Date, Contract Line Type Id, Contract Line Type Code, Contract Line Type Name, Contract Line Name, Contract Line Status Code, Contract Line Status, Asset Date Delivery Expected, Asset Date Funding Expected, Asset Residual Percent, Asset Res Guarantor Type Code, Asset Res Guarantor Type, Asset Residual Amt Guarantee, Asset Residual Amount, Asset Upfront Tax, Asset Bill To Site Use Id, Asset Bill To Address, Asset Billing Payment Method, Asset Billing Bank Account, Asset Billing Bank, Asset St Transfer Of Title, Asset St Sale And Lease Back, Asset St Purchase Of Lease, Asset St Intended Use, Asset St Asset Upfront Tax, Asset St Equipment Age, Asset Prop Tax Applicable, Asset Prop Tax Lessee Report, Asset Prop Tax Bill Method, Line Supplier Id, Line Supplier Number, Line Supplier, Inv Supplr Ship To Site Use Id, Inv Supplier Ship To Site, Inv Supplier Invoice Line Id, Inv Supplier Invoice Number, Inv Supplier Invoice Date, Inv Supplier Ship To Site Id, Inv Supplier Ship To Site Num, Fixed Asset Line Id, Fa Asset Key Id, Fa Asset Key, Fa Manufacturer Name, Fa Asset Location Id, Fa Asset Location Name, Fa Model Number, Fa Asset Id, Fa Corp Book Type Code, Fa Corporate Book, Fa Corp Sal Value Basis Code, Fa Corp Sal Value Basis, Fa Corp Salvage Value, Fa Corp Salvage Value Percent, Fa Corp Dep Rate, Fa Corp Dep Life In Months, Fa Corp Dep Method Code, Fa Corp Dep Method Id, Fa Corp Dep Method Name, Fa Corp Category Id, Fa Corp Category, Fa Corp Orig Cost, Fa Corp Dep Cost, Fa Corp Date In Service, Fa Tax Book Type Code, Fa Tax Book, Fa Tax Sal Value Basis Code, Fa Tax Sal Value Basis, Fa Tax Salvage Value, Fa Tax Salvage Value Percent, Fa Tax Dep Rate, Fa Tax Dep Life In Months, Fa Tax Dep Method Code, Fa Tax Dep Method Id, Fa Tax Dep Method Name, Fa Tax Orig Cost, Fa Tax Dep Cost, Fa Tax Date In Service, Fee Or Service Name, Fee Or Service Effective From, Fee Or Service Effective To, Fee Or Service Total Amount, Fee Or Serv Number Of Periods, Fee Or Serv Amount Per Period, Fee Or Service Frequency Code, Fee Or Service Frequency, Fee Type Code, Fee Type, Fee Trx Tax Yn, Fee Initial Direct Cost, Fee Rollover Quote Id, Fee Rollover Quote Number, Fee Rollover Contract Number, Service Contract Number, Service Payment Type, Insurance Policy Id, Insurance Quote Number, Insurance Policy Number, Insurance Policy Type Code, Insurance Policy Type, Insurance Policy Status Code, Insurance Policy Status, Insurance Provider, Insurance Policy Location, Insurance Payment Frequency, Ins Policy Lessor Insured Yn, Ins Policy Lessor Payee Yn, Insurance Policy Eff From, Insurance Policy Eff To, Insurance Product Id, Insurance Product, Insurance Factor Value, Insurance Name Of Insured, Insurance Covered Amount, Insurance Calc Premium, Insurance Tot Premium, Insurance Activation Date, Insurance Cancellation Date, Insurance Sales Rep, Model Line Id, Inventory Item Id, Inventory Item Org Id, Inventory Item Name, Inventory Item Description, Inventory Total Units, Inventory Unit Cost, Asset Filing Lien Type Code, Asset Filing Lien Type, Asset Filing Lien Number, Asset Filing Lien Date, Asset Filing Lien Status Code, Asset Filing Lien Status, Asset Filing Lienholder, Asset Filing Jurisdiction, Asset Filing Sub Jurisdiction, Asset Filing Lien Exp Date, Asset Filing Lien Cont Number, Asset Filing Lien Cont Date, Asset Filing Title Type Code, Asset Filing Title Type, Asset Filing Title Number, Asset Filing Title Issuer, Asset Filing Title Date, Asset Filing Title Custodian, Asset Filing Title Regis Num, Asset Filing Title Location, Asset Filing Title Regis Loc, Asset Filing Payee Site, Asset Filing Regis Exp Date, Line Pth Evg Payout Basis Code, Line Pth Evg Payout Basis, Line Pth Evg Start Date, Line Pth Evg Pyout Formula Id, Line Pth Evg Pyout Formula, Line Pth Evg Stream Type Id, Line Pth Evg Stream Type Code, Line Pth Evg Stream Type, Line Pth Base Pay Basis Code, Line Pth Base Payout Basis, Line Pth Base Stream Type Id, Line Pth Base Stream Type Code, Line Pth Base Stream Type, Line Pth Base Start Date, Ib Install Site Id, Ib Install Site Number, Ib Install Site Use Id, Ib Install Site, Ib Serial Number, Fa Mg Book Type Code, Fa Mg Book, Fa Mg Sal Value Basis Code, Fa Mg Sal Value Basis, Fa Mg Salvage Value, Fa Mg Salvage Value Percent, Fa Mg Dep Rate, Fa Mg Dep Life In Months, Fa Mg Dep Method Code, Fa Mg Dep Method Id, Fa Mg Dep Method Name, Fa Mg Orig Cost, Fa Mg Dep Cost, Fa Mg Date In Service, Usage Price List Id, Usage Price List Name, Usage Period Code, Usage Period, Usage No Of Period, Usage Minimum Qty, Usage Level Flag, Usage Default Quantity, Usage Base Reading Uom Code, Usage Base Reading Uom, Usage Base Reading, Usage Avg Monthly Counter Flag, Usage Type Code, Usage Type, Usage Fixed Quantity, Line Accumulated Depreciation, Line Capitalized Reduction, Line Capitalized Interest, Line Discount, Line Unbilled Due Amount, Line Oec, Line Cap Amount, Line Asset Cost, Line Residual Amount, Line Rent Amount, Line Net Investment, Line Net Investment Func, Line Billed Rents, Line Billed Rents Func, Line Billed Non Rents, Line Billed Non Rents Func, Assets Funded Amount, Expense Funded Amount, Asset Termination Date, Total Asset Addon Cost, Total Asset Subsidy Amount, Total Asset Subsidy Ovrd Amt, Total Asset Cap Service Amount, Total Asset Cap Fee Amount, Total Asset Financed Fee Amt, Total Asset Rollover Fee Amt, Total Asset Tradein Amount, Total Active Line Financed Amt, Contract Line Dff Category, Contract Line Dff1, Contract Line Dff2, Contract Line Dff3, Contract Line Dff4, Contract Line Dff5, Contract Line Dff6, Contract Line Dff7, Contract Line Dff8, Contract Line Dff9, Contract Line Dff10, Contract Line Dff11, Contract Line Dff12, Contract Line Dff13, Contract Line Dff14, Contract Line Dff15, Asset Billing Bank Acct Id, Instrument Number, Bank Name

Application: Lease and Finance Management
Source: Contract Lines Financial Report
Short Name: OKLLNFINEXT
DB package: OKL_K_LINE_FIN_EXT_PVT

Copy

                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 AR Transactions and Lines Avalara VAT listing RK: AR Transactions and Lines OKL Receipt Inquiry OKL Termination Quotes OKL Billing Inquiry Data OKL Inform Service and Maintenance Provider

Blitz Report In Action

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ