OKL Contract Lines Financial
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
Source: Contract Lines Financial Report
Short Name: OKLLNFINEXT
DB package: OKL_K_LINE_FIN_EXT_PVT
Run
OKL Contract Lines Financial and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |