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 ...
Application: Lease and Finance Management
Source: Contract Lines Financial Report
Short Name: OKLLNFINEXT
DB package: OKL_K_LINE_FIN_EXT_PVT
                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