OKL Contract Financial

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Contract Financial Report
Short Name: OKLFINEXTR
DB package: OKL_CNTRCT_FIN_EXTRACT_PVT
Run OKL Contract Financial and other Oracle EBS reports with Blitz Report™ on our demo environment
	                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
Download
Related Blitz Reports
CAC WIP Jobs With Complete Status Which Are Ready for Close CAC ICP PII WIP Pending Cost Adjustment CAC Manufacturing Variance Summary FA Cost Clearing Reconciliation - draft CAC WIP Jobs With Complete Status But Not Ready for Close CAC Purchase Price Variance INV Organization parameters listing CAC Subinventory Accounts Setup CAC WIP Accounts Setup CAC Shipping Network (Inter-Org) Accounts Setup
Blitz Report™

Blitz Report™ provides multiple benefits: