OKL Contract Financial
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Contract Financial Report
Short Name: OKLFINEXTR
DB package: OKL_CNTRCT_FIN_EXTRACT_PVT
Source: Contract Financial Report
Short Name: OKLFINEXTR
DB package: OKL_CNTRCT_FIN_EXTRACT_PVT
select meaning BOOK_CLASS from fnd_lookups where lookup_type like 'OKL_BOOK_CLASS' AND lookup_code like NVL (:P_BOOK_CLASS, 'XXX') and nvl(start_date_active,sysdate) <=sysdate and nvl(end_date_active,sysdate+1) > sysdate and enabled_flag = 'Y' |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Operating Unit | LOV Oracle | ||
| Report Date | Date | ||
| Contract Start Date From | Date | ||
| Contract Start Date To | Date | ||
| Include AR Billing Details | LOV Oracle | ||
| Book Classification | LOV Oracle | ||
| Financial Product | LOV Oracle | ||
| Contract Status | LOV Oracle | ||
| Customer Party Number | LOV Oracle | ||
| Customer Party Name | LOV Oracle | ||
| Customer SIC Code | LOV Oracle | ||
| Vendor Party Number | LOV Oracle | ||
| Vendor Party Name | LOV Oracle | ||
| Sales Channel | LOV Oracle | ||
| Contract On Accrual | LOV Oracle | ||
| Contract End Date From | Date | ||
| Contract End Date To | Date | ||
| Contract Termination Date From | Date | ||
| Contract Termination Date To | Date | ||
| Delete Report Data | LOV Oracle |