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 |