OKL Contract Financial

Description
Categories: BI Publisher
Columns: Book Class ...
Application: Lease and Finance Management
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