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
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 |