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