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
SQL 8 lines
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' |
Parameters 20
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |